How to delete and recreate from scratch an existing EF Code First database

Question

I am using EF Code First with EF 5 in VS 2012  I use PM update-database command and I have a simple seed method to fill some tables with sample data   I would like to delete and recreate my x mdb  The update history seems to be out of sync  If I comment out all my DBSets in my context  update-database runs with no error but leaves some tables in the DB  As I have no valuable data in the DB it seems to the simplest to reset the all thing   How can I accomplish this

User · Answer

Let me help in updating the answers here since new users will find it useful  I believe the aim is to delete the database itself and recreate it using EF Code First approach  1 Open your project in Visual Studio using the  quot  sln quot  extention  2 Select Server Explorer  it is oftentimes on the left  3 Select SQL Server Object Explorer  4 The database you want to delete would be listed under any of the localDB  Right-Click it and select delete

User · Answer

If I m understanding it right      If you want to start clean     1  Manually delete your DB - wherever it is  I m assuming you have your connection sorted   or empty it  but easier safer is to delete it all together - as there is system   MigrationHistory table - you need that removed too     2  Remove all migration files - which are under Migrations - and named like numbers etc  - remove them all     3  Rebuild your project containing migrations  and the rest  - and make sure your project is set up  configuration  to build automatically  that sometimes may cause problems - but not likely for you      4  Run Add-Migration Initial again - then Update-Database

User · Answer

If you created your database following this tutorial  https   msdn microsoft com en-au data jj193542 aspx      then this might work    Delete all  mdf and  ldf files in your project directory Go to View   SQL Server Object Explorer and delete the database from the  localdb  v11 0 subnode  See also https   stackoverflow com a 15832184 2279059

User · Answer

How about     static void Main string   args        Database SetInitializer new DropCreateDatabaseIfModelChanges lt ExampleContext gt               C        o        d        i        n        g     I picked this up from Programming Entity Framework  Code First  Pg 28 First Edition

User · Answer

If you worked the correct way to create your migrations by using the command Add-Migration  Name Of Migration  then you can do the following to get a clean start  reset  with loss of data  of course     Update-database -TargetMigration 0    Normally your DB is empty now since the down methods were executed  Update-database  This will recreate your DB to your current migration

User · Answer

dbctx Database EnsureDeleted    dbctx Database EnsureCreated

User · Answer

Single Liner to Drop  Create and Seed from Package Manager Console    update-database -TargetMigration 0   update-database -force   Kaboom

User · Answer

Since this question is gonna be clicked some day by new EF Core users and I find the top answers somewhat unnecessarily destructive  I will show you a way to start  fresh   Beware  this deletes all of your data    Delete all tables on your MS SQL server  Also delete the   EFMigrations table  Type dotnet ef database update EF Core will now recreate the database from zero up until your latest migration

User · Answer

For EntityFrameworkCore you can use the following   Update-Database -Migration 0   This will remove all migrations from the database  Then you can use   Remove-Migration   To remove your migration  Finally you can recreate your migration and apply it to the database   Add-Migration Initialize Update-Database   Tested on EFCore v2 1 0

User · Answer

There re many ways to drop a database or update existing database  simply you can switched to previous migrations  dotnet ef database update previousMigraionName      But some databases have limitations like not allow to modify after create relationships  means you have not allow privileges to drop columns from ef core database providers but most of time in ef core drop database is allowed so you can drop DB using drop command and then you use previous migration again  dotnet ef database drop PMC command  PM gt  drop-database  OR you can do manually deleting database and do a migration

User · Answer

Take these steps    Delete those object which should be deleted from the context    Dbset lt Item gt  Items get set   and in Nuget Console run these commands add-migration  contextName    update-database -verbose   It will drop table s  that not exist in Context  but already created in database

[ef-code-first] How to delete and recreate from scratch an existing EF Code First database

Examples related to ef-code-first

Examples related to entity-framework-migrations