How to recreate database in EF if my model changes?

Question

I created a DbContext like so :

   public class myDB : DbContext
   {
     public DbSet<Party> Parties { get; set; }
     public DbSet<Booking> Bookings { get; set; }
   }

This generated my DataBase and the two tables above..Great

I then decided to add another DbSet into the mix & I got an error:

the model backing the 'Party' context has changed since the database was created

I'm aware of the fixes for this using modelbuilder.IncludeMetadataInDatabase = false; and Database.SetInitializer<ClubmansGuideDB>(null);

1) What's the correct way to add my new classes to the context and have them generated in the DataBase?

2) In my futile attempts to solve this myself I deleted the tables and tried to re-run the app with no success I then deleted the full database and re-run and it doesn't re-generate the DB. How can I start from scratch - is there some cache somewhere?

entity framework issue isn't the best title I have ever seen. — gdoron
– gdoron, Commented Jan 9, 2012 at 18:26

kamranicus · Accepted Answer · 2012-01-09 18:24:40Z

15

I believe you're looking for:

Database.SetInitializer<ClubmansGuideDB>(new DropCreateDatabaseIfModelChanges<ClubmansGuideDB>());

As of EF 4.1 and above.

Note that this assumes you have permission to even drop your database. I do this locally for ease of development but disable it in staging/production (I do a manual Schema Compare and push my changes).

By the way, for testing, if you need to force recreate the database, you can do:

using (var context = new ClubmansGuideDB()) {
    context.Database.Initialize(force: true);
}

(using if you don't already have a reference to your DB)

answered Jan 9, 2012 at 18:24

kamranicus

4,4632 gold badges41 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AminM Over a year ago

Database.SetInitializer(new DropCreateDatabaseIfModelChanges<MyDbContext>()); Database.Initialize(true); why not work form me??

Wouter de Kort · Accepted Answer · 2012-01-09 18:26:06Z

3

You can let the Entity Framework recreate the whole database by using a Database Initializer or if you want to migrate data you can look at the Code First Migrations

The following would recreate your database when the model changes:

Database.SetInitializer<myDB>(new DropCreateDatabaseIfModelChanges<myDB>());

answered Jan 9, 2012 at 18:26

Wouter de Kort♦

40k13 gold badges88 silver badges104 bronze badges

Comments

Kyle · Accepted Answer · 2012-01-09 18:42:58Z

0

Try putting this in your Global.asax.cs Application_Start() method.

Database.SetInitializer<DatabaseContext>(null);

To reset the database from scratch on app run make a class like this

//Where myDB is your context
public class EntityBase: DropCreateDatabaseAlways<myDB>
{

}

Then in your Application_Start() method you can do this

Database.SetInitializer(new EntityBase());

edited Jan 9, 2012 at 18:42

answered Jan 9, 2012 at 18:22

Kyle

3,3101 gold badge20 silver badges20 bronze badges

1 Comment

Kyle Over a year ago

you can also override the Seed method and fill your database with test data. msdn.microsoft.com/en-us/library/gg679212(v=vs.103).aspx

Collectives™ on Stack Overflow

How to recreate database in EF if my model changes?

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related