Generate dotnet ef migration scripts for all migrations that don't have a script yet

dotnet-ef-migration-script.ps1

# build the latest code
dotnet build 

# get all migration ids and store them in an array
$migrations = dotnet ef migrations list --no-build --no-connect --json | ConvertFrom-Json 

# iterate through the array
for ($i = 0; $i -lt $migrations.Length; $i++) {

    # get the current migration id
    $current = $migrations[$i].id

    # get the previous migration id, if it doesn't exist, set it to 0
    $previous = if ($i -gt 0) { $migrations[$i-1].id } else { 0 }
    

    # if the migration file doesn't exist
    if (-not (Test-Path "sql\$current.sql")) {
        Write-Host "Generating migration script for $current"

        # generate the SQL script for the current migration and save it as <migrationId.sql>
	dotnet ef migrations script --no-build $previous $current -o "sql\$current.sql" -i
	}
}