Create EF Core database migrations as a single idempotent SQL script

CreateDatabaseMigrations.xml

// Paste this snippet in your .NET Core main .csproj file
// Change (or remove) the Condition statement if you want this to run on Debug builds (locally) as well

<Target Name="Create Migrations Script" AfterTargets="PostBuildEvent" Condition="'$(Configuration)' == 'Release'">
  <Exec Command="dotnet ef migrations script --configuration $(Configuration) --no-build --idempotent --output $(TargetDir)/migrations.sql"/>
</Target>