How do you downgrade a Entity Framework 5 migration in Visual Studio 2012?

Question

I've noticed that when I create a code first database migration using `add-migration` it generates a `Down()` method as well as an `Up()` method. How do I tell my database to downgrade?

Accepted Answer

After almost giving up with researching on Google I managed to find this quote from here:

- http://msdn.microsoft.com/en-gb/data/jj591621.aspx#specific

Which Specifies:

Let’s say we want to migrate our database to the state it was in after running our AddBlogUrl migration. We can use the `–TargetMigration` switch to downgrade to this migration.

Run the `Update-Database –TargetMigration: AddBlogUrl` command in Package Manager Console. This command will run the Down script for our AddBlogAbstract and AddPostClass migrations.

If you want to roll all the way back to an empty database then you can use the `Update-Database –TargetMigration: $InitialDatabase` command.

How do you downgrade a Entity Framework 5 migration in Visual Studio 2012?

Solution

Problem