How to force EF code first to recreate databases?

asp.net-mvc c# ef-code-first entity-framework

Question

I had a bunch of tables Code First created.

Then in SQL i deleted one table so that i could inevitably ask this question on stack.

Upon using update-database in package management console I get:

Cannot find the object "dbo.ContractParents" because it does not exist or you do not have permissions.

What is the best way to recreate my table?

I've read up about context.Database.CreateIfNotExists();

I put it in my seed function, but nothing doing.

Thanks!

1
14
10/2/2013 2:28:49 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

To explain what happens with your update-database command and why the context.Database.CreateIfNotExists() method in the seed did not work:

When you run the update-database command it first looks at your connection string to see if the database is there. If it is it looks at the migration history table and checks that against what is in you DbContext class. If it sees that there are tables missing or changes it will attempt to update the database. The Seed method is not called until after that is done, so that is why that did not work.

While developing using EF-Code First I usually approach the problem in a few different ways depending on how large my database is. I usually went the route of deleting all the tables (including the migration history table) and then running the update-database command again. Works fine, just really time consuming if you have a lot of tables with a lot of FK constraints on it.

I finally became tired of it and found these scripts to make the dropping of tables exponentially faster. I went to this because I was running my app on Azure. When I am running it on my local machine, I would just delete the whole database and make a brand new database with the same name.

Elegant solution? No. Does it work? More or less...

9
10/1/2013 4:56:21 PM

Popular Answer

For yet another cheesy option...

Right click on your db in server explorer, and hit delete Then you can do

Enable-Migrations -EnableAutomaticMigrations -Force

Update-Database -Force

Dirty update, clean result :)

Steve

Related Questions

EF Code First - Recreate Database If Model Changes

As of EF Code First in CTP5, this is not possible. Code First will drop and create your database or it does not touch it at all. I think in your case, you should manually create your full database and then try to come up with an object model that matches the DB. ...That said, EF team is actively working on the feature that you are looking for: alte...
asp.net-membership entity-framework poco
asked by Morteza Manavi

EF Code First - {"CREATE DATABASE permission denied in database 'master'."}

I once faced this problem and resolved it. The key is using SQL authentication instead of Windows'. This is the clearest way to specify the default db....Try connection string in this way:...<add name="MFCConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MFC.mdf;Initial Catalog=MFC;Integrated Security=fal...
c# ef-code-first entity-framework sql-server-2008
asked by cheny

Cannot recreate the database using EF-Code first

The Error was occurring in some other part of application, due to which database schema is created but the table ...dbo._MigrationHistory... is unable to create on the sqlServer i.e is why the Codefirst is not able to drop the database coz the required info is not there. when i deleted the database it mst worked but i guess browers is showing the c...
ef-code-first entity-framework
asked by Vivek

Forcing code-first to always initialize a non-existent database?

Initializer... is executed when you need to access the database so if you want to create database on app start use anything of the following:... context.Database.Initialize(true); //If set to true the initializer is run even if it has already been run. context.Database.Create() ...http://msdn.microsoft.com/en-us/library/system.data.en...
ado.net ef-code-first entity-framework sql-server-2008
asked by Matija Grcic

Drop or Recreate database with Entity Framework Migrations (Code-First)

You can get the same behavior with Migrations by using automatic migrations....PM> enable-migrations -EnableAutomaticMigrations ...In Configuration.cs in the constructor, make sure automatic migrations and allow data loss are set to true......public Configuration() { AutomaticMigrationsEnabled = true; AutomaticMigrationDataLossAllowed = tru...
.net asp.net ef-migrations entity-framework
asked by Anthony Chu

EF Code Frirst: Before you update your database using Code First Migrations,

I believe it's a one time occurrence while you upgrade your database. ...You can read more at the ....NET Web Development and Tools Blog.... And also see ...Updating ASP.NET applications from ASP.NET Identity 1.0 to 2.0.0-alpha1... linked from that blog post.
asp.net-identity entity-framework
asked by Michael Fürstenberg

Code First Existing Database vs EF Designer to Existing Database

In any case you'll have to synchronize the EDM (entity data model) and the DB. You have to make sure that the EDM is fully compatible with your database. If not, it will fail, no matter if it's Code First or you use a Model....The only difference is that:...using the designer you can do it graphically, and easyly set properties, column names, and s...
entity-framework
asked by JotaBe

How to update model working with EF code first with 'Code First from Database'

Go through the generation process, and during the generation process, it allows you to select tables. Select the newer ones only....Instead of selecting all tables, expand the little triangle and select what you need. You also will have to select any dependent tables, or else the process will fail. If those dependent tables are already there, just ...
.net c# ef-code-first entity-framework entity-framework-6
asked by Mrchief

update-database -force command is not updating the base in entity framework code -first

Using an Existing Database...Depending on the state of your context you need to the one of the following......IF YOUR DATABASE CONTEXT CONTAINS ONLY YOUR EXISTING TABLES AND NO CUSTOM CHANGES DO THE FOLLOWING...Add-Migration Initial -IgnoreChanges ...This will create a blank migration script...update-database ...This will update the database to thi...
asp.net-mvc ef-code-first entity-framework sql-server
asked by heymega

EF Code First CREATE DATABASE permission denied in database 'master'

To create the database:...Open the Security folder, then open the Logins folder and select the user account under which you want to create the database. Open the account's Properties, select the Server Roles tab and then select the dbcreator checkbox (sysadmin works even better). You can also try to create the database while logged in under the sta...
asp.net-mvc-4 c# code-first entity-framework-6 sql-server
asked by Parth Patel

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow