EF Core 迁移整理
PowerShell
Add-Migration InitialCreate
多数据源
Add-Migration InitialCreate -Context MyDbContext -OutputDir Migrations\SqlServerMigrations
Add-Migration InitialCreate -Context MySqliteDbContext -OutputDir Migrations\SqliteMigrations
Console
dotnet ef migrations add InitialCreate
dotnet ef migrations add InitialCreate --context MyDbContext --output-dir Migrations/SqlServerMigrations
dotnet ef migrations add InitialCreate --context MySqliteDbContext --output-dir Migrations/SqliteMigrations
更新数据库
PowerShell
Update-Database
Console
dotnet ef database update
删除迁移
PowerShell
Remove-Migration
Console
dotnet ef migrations remove
还原迁移
PowerShell
Update-Database LastGoodMigration
Console
dotnet ef database update LastGoodMigration
生成迁移Sql
PowerShell
Script-Migration
Script-Migration -From migrationName1 -To migrationName2 -Context ContextName
Console
dotnet ef migrations script
dotnet ef migrations script -From migrationName1 -To migrationName2 -Context ContextName
迁移脚本的帮助说明
我们可以通过命令来获取帮助说明
Get-Help about_EntityFrameworkCore
get-help Add-Migration -full
get-help Script-Migration -full
