How do I undo the last Add-Migration command?

Question

I have created a migration using the Add-Migration command, but I'd like to change the name of that migration. How can I undo the migration command, so that I can regenerate it using the new desired name?

Is it just a matter of deleting the generated files, or this could be a bad idea?

Colin · Accepted Answer · 2018-11-14T02:29:35.057

158

If you haven't used Update-Database you can just delete the migration file. If you've run the update you should roll it back using Update-Database -TargetMigration "NameOfPreviousMigration" then delete the migration file.

Reference:

http://elegantcode.com/2012/04/12/entity-framework-migrations-tips/

edited Nov 14 '18 at 02:29

answered Jan 23 '14 at 15:32

Colin

22,328
17
103
197

what if it was the first migration added? – Jimmyt1988 Oct 19 '17 at 15:48
@Jimmyt1988, use Update-Database –TargetMigration: $InitialDatabase – Seraphim Nov 24 '17 at 17:28
Then delete it? I don't get it. Then delete what? – tnk479 Nov 12 '18 at 16:57
@tnk479 the migration file. Edited to make it clearer – Colin Nov 14 '18 at 02:33
Sad to see that older version of EF (Like EF 6) doesn't have `drop-database` and `remove-migration` commands – Hamza Khanzada Mar 07 '20 at 19:48

score 17 · Answer 2 · edited May 16 '20 at 03:58

17

If you haven't executed the migration yet with Update-Database, you can run Add-Migration again with the same name (you may need to use -Force) to re-execute the scaffolding. This is noted in the output of the Add-Migration command.

edited May 16 '20 at 03:58

Sayed Muhammad Idrees

1,245
15
25

answered Jan 23 '14 at 19:18

Adrian

42,911
6
107
99

1

This is not a good solution as this will not restore ApplicationDbContextModelSnapshot – Enes Sadık Özbek Dec 24 '18 at 15:26
@Trojaner you are right, so the response https://stackoverflow.com/a/46921867/690958 is the better solution – Alberto León Apr 26 '19 at 09:50
Can it also clean up the files? For me it leaves the migration file, but with empty Up() and Down() methods. – Dmitry Karpenko Nov 16 '20 at 17:02
But the question is not about EF-Core, I find this answer working well with pre-core EF. Am I wrong? – Steve Jan 30 '23 at 15:11
1

@Steve correct. The question and answer are dated 2014, .NET Core had its first release in 2016. – Adrian Jan 30 '23 at 15:31

score 14 · Answer 3 · answered Jul 26 '18 at 13:23

14

Just use command

Remove-migration

It will remove last added migration and update snapshot. It will not affect database so you have to rollback db in first place.

answered Jul 26 '18 at 13:23

Tomasz Maj

1,541
15
15

10

Only in EF Core. – John Oct 26 '18 at 15:47
I wish it would be there in EF 6 along with `drop-database` commands.. I am too used to it – Hamza Khanzada Mar 07 '20 at 19:52

score 6 · Answer 4 · answered Apr 07 '18 at 15:12

6

To add to @Ben 's answer, when using the dotnet ef command variety this is the remove command you need:

dotnet ef migrations remove

Which will remove your last migration and update the model snapshot.

answered Apr 07 '18 at 15:12

veuncent

1,599
1
20
17

Ben · Answer 5 · 2019-02-12T13:25:44.543

With EntityFrameworkCore 2.0 comes the model snapshot. You will need to run the remove migration command in order to update the model snapshot. I have read that EF Core will recognize any update and revert the snapshot for you if you manually delete the migration but this has not worked for me.

https://learn.microsoft.com/en-us/aspnet/core/data/ef-mvc/migrations

https://learn.microsoft.com/en-us/ef/core/miscellaneous/cli/dotnet#dotnet-ef-migrations-remove

score 3 · Answer 6 · answered Sep 12 '18 at 08:09

3

Update your last perfect migration via this command :

Update-Database –TargetMigration

answered Sep 12 '18 at 08:09

Abdus Salam Azad

5,087
46
35

score 0 · Answer 7 · answered Sep 24 '20 at 16:52

0

Just use command:

Update-Database nameMigration -context nameContext

And Then

Remove-migration -Context nameContext

answered Sep 24 '20 at 16:52

Hugo Borges

1
1

How do I undo the last Add-Migration command?

7 Answers7

Linked