如何在ASP中取消应用迁移。NET Core与EF Core

当我在VS2015中使用ASP运行PM> Remove-Migration -context BloggingContext时。NET Core项目使用EF Core我得到以下错误:

System.InvalidOperationException: The migration '20160703192724_MyFirstMigration' has already been applied to the database. Unapply it and try again. If the migration has been applied to other databases, consider reverting its changes using a new migration.    at Microsoft.EntityFrameworkCore.Migrations.Design.MigrationsScaffolder.RemoveMigration(String projectDir, String rootNamespace, Boolean force) 
    at Microsoft.EntityFrameworkCore.Design.MigrationsOperations.RemoveMigration(String contextType, Boolean force) 
    at Microsoft.EntityFrameworkCore.Tools.Cli.MigrationsRemoveCommand.<>c__DisplayClass0_0.<Configure>b__0() 
    at Microsoft.Extensions.CommandLineUtils.CommandLineApplication.Execute(String[] args) 
    at Microsoft.EntityFrameworkCore.Tools.Cli.Program.Main(String[] args) 
 The migration '20160703192724_MyFirstMigration' has already been applied to the database. Unapply it and try again. If the migration has been applied to other databases, consider reverting its changes using a new migration.

如何取消申请?我使用的是ASP的最新版本。NET Core 1.0, EF Core和VS2015更新3。

当前回答

您仍然可以使用Update-Database命令。

Update-Database -Migration <migration name> -Context <context name>

然而，根据迁移的名称判断，我假设这是第一次迁移，因此该命令可能不起作用。您应该能够从数据库中的__MigrationHistory表中删除该条目，然后再次运行Remove-Migration命令。您还可以删除迁移文件并重新开始。

2016-07-05 09:29:04

其他回答

在迁移已经应用到数据库后“取消”最近的迁移:

Open the SQL Server Object Explorer (View -> "SQL Server Object Explorer") Navigate to the database that is linked to your project by expanding the small triangles to the side. Expand "Tables" Find the table named "dbo._EFMigrationsHistory". Right click on it and select "View Data" to see the table entries in Visual Studio. Delete the row corresponding to your migration that you want to unapply (Say "yes" to the warning, if prompted). Run "dotnet ef migrations remove" again in the command window in the directory that has the project.json file. Alternatively, run "Remove-Migration" command in the package manager console.

希望这有助于并适用于项目中的任何迁移…我只测试了最近的迁移…

编码快乐!

2016-12-02 20:36:30

要完全删除所有迁移并重新开始，请执行以下操作:

dotnet ef database update 0
dotnet ef migrations remove

2016-11-27 18:22:21

要恢复所有应用到DB的迁移，只需运行:

update-database 0

在migration目录中有可见的迁移文件时，应该多次运行Remove-Migration。该命令删除最近一次迁移，同时更新快照。

2020-03-22 12:04:13

在包管理器控制台:

- database就Your_Migration_You_Want_To_Revert_To

关于如何恢复迁移的更多选项和解释可以在这里看到

2018-02-16 12:53:50

您仍然可以使用Update-Database命令。

Update-Database -Migration <migration name> -Context <context name>

2016-07-05 09:29:04

如何在ASP中取消应用迁移。NET Core与EF Core

推荐文章

最新文章

标签