blocks|key|4406554|text|您仍然可以使用Update-Database命令。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4406555|Update-Database+-Migration+<migration+name>+-Context+<context+name>|code-block|syntax|javascript|4406556|但是，从您的迁移名称判断，我假设这是第一次迁移，因此该命令可能不起作用。您应该能够从数据库的__MigrationHistory表中删除该条目，然后再次运行Remove-Migration命令。您也可以删除迁移文件，然后重新开始。|4406557|entityMap^0|7|F|0|0|1A|I|26|G|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

You can still use the <code>Update-Database</code> command.

<pre><code>Update-Database -Migration &lt;migration name&gt; -Context &lt;context name&gt;
</code></pre>

However, judging by the name of your migration i'm assuming it's the first migration so that command may not work. You should be able to delete the entry from the <code>__MigrationHistory</code> table in your database and then run the <code>Remove-Migration</code> command again. You could also delete the migration file and just start again.

blocks|key|4406419|text|要完全删除所有迁移并重新开始，请执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4406420|dotnet+ef+database+update+0
dotnet+ef+migrations+remove|code-block|syntax|javascript|4406421|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

To completely remove all migrations and start all over again, do the following:

<pre><code>dotnet ef database update 0
dotnet ef migrations remove
</code></pre>

blocks|key|4406620|text|通常，如果您正在使用Package+Manager控制台，删除特定迁移的正确方法是引用迁移的名称|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4406621|Update-Database+-Migration+{Name+of+Migration}+-Context+{context}|code-block|syntax|javascript|4406622|根据docs删除上次应用的迁移的另一种方法是使用以下命令：|offset|length|4406623|dotnet+ef+migrations+remove|4406624|此命令应从解决方案目录中的开发人员命令提示符(how+to+open+command+prompt)执行。|4406625|例如，如果您的应用程序的内部名称为"+application“，并且位于文件夹c:\Projects中。那么你的路径应该是：|4406626|C:\Projects\Application|4406627|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/el-gr/ef/core/miscellaneous/cli/dotnet#dotnet-ef-migrations-remove|1|https://www.lifewire.com/how-to-open-command-prompt-2618089^0|0|0|2|4|0|0|0|N|Q|1|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@$I|15|J|16|1|17]]|A|$]]|$1|K|3|L|5|D|7|18|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|19|8|@]|9|@$I|1A|J|1B|1|1C]]|A|$]]|$1|O|3|P|5|6|7|1D|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|1E|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]|10|$5|V|W|X|A|$Y|11]]]]

In general if you are using the Package Manager Console the right way to remove a specific Migration is by referencing the name of the migration

<pre><code>Update-Database -Migration {Name of Migration} -Context {context}
</code></pre>

Another way to remove the last migration you have applied according to the <a href="https://docs.microsoft.com/el-gr/ef/core/miscellaneous/cli/dotnet#dotnet-ef-migrations-remove" rel="noreferrer">docs</a> is by using the command:

<pre><code>dotnet ef migrations remove
</code></pre>

This command should be executed from the developer command prompt (<a href="https://www.lifewire.com/how-to-open-command-prompt-2618089" rel="noreferrer">how to open command prompt</a>) inside your solution directory.

For example if your application is inside name "Application" and is in the folder c:\Projects. Then your path should be:

<pre><code>C:\Projects\Application
</code></pre>

blocks|key|4406647|text|要在EF+Core+1.0中取消应用迁移，请使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4406648|dotnet+ef数据库更新{migration_name}|4406649|使用要保留更改的迁移的迁移名称。可以使用以下命令找到迁移的名称列表：|4406650|dotnet+ef迁移列表|4406651|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

In order to unapply a migration in EF Core 1.0 use the command:

dotnet ef database update {migration_name}

Use the migration name of the migration until which you would like to preserve your changes. The list of names of the migration can be found using:

dotnet ef migrations list

blocks|key|4406506|text|在Package+Manager控制台中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4406507|Update-Database+Your_Migration_You_Want_To_Revert_To|offset|length|style|CODE|4406508|More+options+and+explanation+on+how+to+revert+migrations+can+be+seen+here|4406509|entityMap|0|LINK|mutability|MUTABLE|url|http://www.learnentityframeworkcore.com/migrations#reversing-a-migration^0|0|0|1G|0|0|21|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@$D|W|E|X|1|Y]]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

In Package Manager Console: 

<code>Update-Database Your_Migration_You_Want_To_Revert_To</code>

<a href="http://www.learnentityframeworkcore.com/migrations#reversing-a-migration" rel="noreferrer">More options and explanation on how to revert migrations can be seen here</a>

blocks|key|4406537|text|简单地说，您可以通过值确定迁移目标|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4406538|+Update-Database+-Migration:0|code-block|syntax|javascript|4406539|然后继续并删除它|4406540|+Remove-Migration|4406541|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Simply you can target a Migration by value

<pre><code> Update-Database -Migration:0
</code></pre>

Then go ahead and remove it

<pre><code> Remove-Migration
</code></pre>

blocks|key|4406548|text|1.找到表dbo._EFMigrationsHistory，删除需要移除的迁移记录。2.在PM(包管理器控制台)中运行"remove-migration“。这对我很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4406549|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

1.find table "dbo._EFMigrationsHistory", then delete the migration record that you want to remove.
2. run "remove-migration" in PM(Package Manager Console).
Works for me.

blocks|key|4406586|text|首先运行以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4406587|PM>update-database+-migration:0|code-block|syntax|javascript|4406588|然后运行这个命令：|4406589|PM>remove_migration|4406590|完成|4406591|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

at first run the following command :

<pre><code>PM&gt;update-database -migration:0
</code></pre>

and then run this one :

<pre><code>PM&gt;remove_migration
</code></pre>

Finish

blocks|key|4406621|text|要恢复应用于数据库的所有迁移，只需运行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4406622|update-database+0|code-block|syntax|javascript|4406623|运行Remove-Migration的次数应与迁移目录中可见的迁移文件的次数相同。此命令将删除最新的迁移并更新快照。|offset|length|style|CODE|4406624|entityMap^0|0|0|2|G|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

To revert all the migrations which are applied to DB simply run:

<pre><code>update-database 0
</code></pre>

It should be followed with running <code>Remove-Migration</code> as many times as there are migration files visible in the Migration directory. The command deletes the latest migration and also updates the snapshot.

blocks|key|4406645|text|您可以使用以下命令来完成此操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4406646|dotnet+ef+migrations+remove|code-block|syntax|javascript|4406647|警告|4406648|注意不要删除已应用于生产数据库的任何迁移。如果不这样做，您将无法恢复它，并可能破坏后续迁移所做的假设。|4406649|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can do it with:
<pre><code>dotnet ef migrations remove
</code></pre>
<h3>Warning</h3>
Take care not to remove any migrations which are already applied to production databases. Not doing so will prevent you from being able to revert it, and may break the assumptions made by subsequent migrations.

blocks|key|4406657|text|dotnet+ef+database+update+<the-migration-you-want-to-recover>
dotnet+ef+migrations+remove|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4406658|不要忘记remove-Call，因为这将为您删除迁移文件并更新快照文件。|unstyled|4406659|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>dotnet ef database update &lt;the-migration-you-want-to-recover&gt;
dotnet ef migrations remove
</code></pre>
Don't forget the remove-Call since this will remove the migration files for you and update the Snapshot-file.

blocks|key|4406854|text|因为我被重定向到这个问题是为了搜索ef而不是ef+core中的回滚迁移，所以我将这个答案添加到这个问题中，以供每个想要了解ef中相同问题的人使用。如果您使用的是ef，可以使用以下命令回滚迁移：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4406855|Update-Database+[[-Migration]+<String>]+
++++++++++++++++[-Context+<String>]
++++++++++++++++[-Project+<String>]
++++++++++++++++[-StartupProject+<String>]+
++++++++++++++++[<CommonParameters>]+|code-block|syntax|javascript|4406856|基于问题：|4406857|Update-Database+-Migration+<previous-migration-name>+-context+BloggingContext|4406858|entityMap^0|H|2|M|7|1P|2|28|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|P|$]]

Because I've been redirected to this question for searching about roll back migration in <code>ef</code> not <code>ef core</code>, I'm adding this answer to the question for everybody who want to know about the same problem in <code>ef</code>. If you're using <code>ef</code> you can use the following command to roll back the migration:
<pre><code>Update-Database [[-Migration] &lt;String&gt;] 
 [-Context &lt;String&gt;]
 [-Project &lt;String&gt;]
 [-StartupProject &lt;String&gt;] 
 [&lt;CommonParameters&gt;] 
</code></pre>
Based on question:
<pre><code>Update-Database -Migration &lt;previous-migration-name&gt; -context BloggingContext
</code></pre>

When I run <code>PM&gt; Remove-Migration -context BloggingContext</code> in VS2015 with an ASP.NET Core project using EF Core I get the following error:

<pre><code>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.&lt;&gt;c__DisplayClass0_0.&lt;Configure&gt;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.
</code></pre>

How can I unapply it? I'm using latest release of ASP.NET Core 1.0, EF Core, and VS2015 Update 3.

How to unapply a migration in ASP.NET Core with EF Core

包管理器

数据库

当我在使用EF核心的ASP.NET核心项目中运行VS2015中的PM> Remove-Migration -context BloggingContext时，我得到以下错误：System.InvalidOperationException: The migration '20160703192724_MyFirstMi...

问如何在具有EF核心的ASP.NET核心中取消应用迁移
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在具有EF核心的ASP.NET核心中取消应用迁移EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在具有EF核心的ASP.NET核心中取消应用迁移
EN