EF Migrations: Rollback last applied migration?

by

I want to add some clarification to this thread: 

Update-Database -TargetMigration:"name_of_migration"

What you are doing above is saying that you want to rollback all migrations UNTIL you’re left with the migration specified. Thus, if you use GET-MIGRATIONS and you find that you have A, B, C, D, and E, then using this command will rollback E and D to get you to C:

Update-Database -TargetMigration:"C"

Also, unless anyone can comment to the contrary, I noticed that you can use an ordinal value and the short -Target switch (thus, -Target is the same as -TargetMigration). If you want to rollback all migrations and start over, you can use:

Update-Database -Target:0

0, above, would rollback even the FIRST migration (this is a destructive command–be sure you know what you’re doing before you use it!)–something you cannot do if you use the syntax above that requires the name of the target migration (the name of the 0th migration doesn’t exist before a migration is applied!). So in that case, you have to use the 0 (ordinal) value. Likewise, if you have applied migrations A, B, C, D, and E (in that order), then the ordinal 1 should refer to A, ordinal 2 should refer to B, and so on. So to rollback to B you could use either:

Update-Database -TargetMigration:"B"

or

Update-Database -TargetMigration:2

Edit October 2019:

According to this related answer on a similar question, correct command is -Target for EF Core 1.1 while it is -Migration for EF Core 2.0.

More Related Contents:

  1. Reset Entity-Framework Migrations
  2. AutomaticMigrationsEnabled false or true?
  3. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  4. Disable lazy loading by default in Entity Framework 4
  5. EntityFramework code-first custom connection string and migrations
  6. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  7. How to include a child object’s child object in Entity Framework 5
  8. Entity Framework 4 / POCO – Where to start? [closed]
  9. Debug code-first Entity Framework migration codes
  10. Asp.Net Web API Error: The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8’
  11. The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid
  12. Unique keys in Entity Framework 4
  13. Entity Framework 4 selective lazy loading properties
  14. Upgrade EF 4 EDMX to EF 6
  15. Querying objects after AddObject before SaveChanges?
  16. Value cannot be null. Parameter name: entitySet
  17. MVC3 and Code First Migrations – “model backing the ‘blah’ context has changed since the database was created”
  18. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  19. How can I disable migration in Entity Framework 6.0
  20. Using Entity Framework with an SQL Compact Private Installation
  21. Map two different entities to the same table?
  22. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  23. Best way to incrementally seed data in Entity Framework 4.3
  24. Entity Framework Code First Using Guid as Identity with another Identity Column
  25. Compose queries across Entity Data Models
  26. Changing Inherited Types in Entity Framework
  27. Entity Framework Core 2.0 – Run migrations step by step
  28. How do I singularize my tables in EF Code First?
  29. Efficient way to do bulk insert/update with Entity Framework
  30. Nullable property to entity field, Entity Framework through Code First

Leave a Comment