How can I drop and recreate a database with Entity Framework?

Question

I have the following code:

public class DataInitializer : DropCreateDatabaseAlways<DataContext>
// public class DataInitializer : CreateDatabaseIfNotExists<DataContext>
// public class DataInitializer : MigrateDatabaseToLatestVersion<DataContext, >
{
    public DataInitializer()
    {
        // System.Diagnostics.Debug.Write("Set Initializer\n");
        Database.SetInitializer<DataContext>(null);

        try
        {

This does not seem to be dropping my database and recreating. Can someone give me advice as to why it does not do that.

Sergey Berezovskiy · Accepted Answer · 2013-03-16 08:38:54Z

1

You are removing initializer by setting it to null. Make following initializer (suppose DataContext is your context class, inherited from DbContext):

public class DataInitializer : DropCreateDatabaseAlways<DataContext>
{
    // optionally override Seed method
}

And at the start of application (before first creation of your context) call

Database.SetInitializer(new DataInitializer());

Consider also to use DropCreateDatabaseIfModelChanges initializer.

answered Mar 16, 2013 at 8:38

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

Collectives™ on Stack Overflow

How can I drop and recreate a database with Entity Framework?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related