Create Migration Script (Windows Bash)

createmigrationscript.cmd

@echo off
setlocal

if /i not [%1] == [] (
  set migrationname=%1
  goto Begin
)

for /f "delims=" %%i in ('dotnet ef migrations list') do (
  set migrationname=%%i
)

:Begin
for /f "delims=:" %%i in ('dotnet ef migrations list ^| findstr /N %migrationname%') do (
  set /A before=%%i-1
)

if %before% == 1 (
  set migrationfrom=0
  goto Ok
)

for /f "tokens=1* delims=:" %%i in ('dotnet ef migrations list ^| findstr /N "^" ^| findstr /B %before%') do (
  set migrationfrom=%%j
  goto Ok
)

:Ok
echo Migration from: %migrationfrom%
echo Migration to: %migrationname%

dotnet ef migrations script %migrationfrom% %migrationname% -o Migrations/Scripts/%migrationname%.sql
echo Script file generated in Migrations/Scripts/%migrationname%.sql