Reset EF code-first database in LocalDB

c# entity-framework ef-code-first reset localdb
angularsen picture angularsen · Jul 3, 2012 · Viewed 8.3k times · Source

I am using Entity Framework 5.0 RC with the LocalDB database that comes pre-configured with VS 2012 RC for some prototyping and testing of code-first database.

After a few cycles of changing my code-first database and running "update-database" I did a huge breaking change and automatic migration failed bad. I don't care about resolving this conflict since this is just prototyping, so losing data is fine.

How do I reset or delete the database? Reset must also reset the migration table, which seems to be hidden from Server Explorer in Visual Studio.

Answer

Nico picture Nico · Dec 10, 2013

Drop the whole database in Visual Studio

  1. Open SQL Server Object Explorer
  2. Find the database you are working with Right click and select delete
  3. Select the two check boxes (Delete backup and restore history, and Close existing connections) and click ok
  4. Run program again and it should recreate the dabase

Related questions

The entity type <type> is not part of the model for the current context

I am getting into the Entity Framework, but I am unsure if I am missing a critical point in the code-first approach. I am using a generic repository pattern based on the code from https://genericunitofworkandrepositories.codeplex.com/ and have …

Read More
Ignoring a class property in Entity Framework 4.1 Code First

My understanding is that the [NotMapped] attribute is not available until EF 5 which is currently in CTP so we cannot use it in production. How can I mark properties in EF 4.1 to be ignored? UPDATE: I noticed something else strange. …

Read More
How to fix the datetime2 out-of-range conversion error using DbContext and SetInitializer?

I'm using the DbContext and Code First APIs introduced with Entity Framework 4.1. The data model uses basic data types such as string and DateTime. The only data annotation I'm using in some cases is [Required], but that's not on any …

Read More