Menu
Using Entity Framework 6 using a model first setup with
Run application, database created. Woot!
Delete .mdf/.ldf in App_Data folder.
Run application, database connection error.
Why did it not recreate the database?
P.S. Tried doing How to re-create database for Entity Framework? but it doesn't work.
So how do I convince EF to recreate the database (and why is this dang hard?)?
461
In order to be deleted, first it should be stopped. Type the SqlLocalDB stop MSSQLLocaDB command in the Command Prompt window: LocalDB instance “MSSQLLocalDB” stopped. Now, repeat the SqlLocalDB delete MSSQLLocalDB command.
Table select o; foreach (var row in rows) { dataDb. Table. Remove(row); } dataDb. SaveChanges();
You likely deleted the MDF file in Windows Explorer. SQL Server LocalDb doesn't know about it and the error is probably complaining about not being able to locate the MDF file.
To delete it properly, you can delete the database from SQL Server Management Studio or SQL Server Object Explorer in Visual Studio.
Alternatively, you could have selected "Show All Files" in Visual Studio Solution Explorer, located the MDF file in App_Data, right-clicked to delete it from within Solution Explorer itself. Visual Studio seems to do the right thing and let SQL Server know about this change.
168
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
