Delete and create database from seed method?

Could you perhaps first run the Update-Database like so:

Update-Database -TargetMigration:0

That would roll all migrations back to zero. And then run Update-Database again.

Edit: The seed method should not do anything to database structure, it should only modify the data. Migrations should be used instead.

Edit2: I can't find information on deleting the database with Update-Database, it will only rollback until first migration, which you seem to have none. Only when deploying it through code, you can use DropCreateDatabaseAlways-strategy like so: http://www.entityframeworktutorial.net/code-first/database-initialization-strategy-in-code-first.aspx If you will do the migration manually, you'll probably have to manually remove the database before running Update-Database.

Do you want to drop and recreate the database when the model changes? How about...

Database.SetInitializer(new DropCreateDatabaseIfModelChanges());

You are right, EF6 has changed the way migrations are handled.

You will have to delete your Migrations folder and all the classes in there.

@cederlof is right about update-database: there is not a drop database switch, or a create database switch. The only wan (AFAIK!) to create a EF6 database is to do new CloudMinderDataContext(someconnectionstring)

I had a problem because I wanted migrations to update my staging database but could not then create a new database in code. This was fine in EF4 but not in EF6. I had to use SQL to create database, then migrate it...

How do I generate an EF6 database with migrations enabled, without using update-database?

and

http://softwaremechanik.wordpress.com/2013/11/04/ef6-if-migrations-are-enabled-cannot-createdatabaseifnotexists/

Hi Steve: To drop one database use this. If you are integration testing your tests might actually run in parallel so be sure you've finished with this database before calling this...

    private void DropDatabase(string connectionString)
    {
        var bld = new SqlConnectionStringBuilder(connectionString);

        var dbName = bld.InitialCatalog; //database you want to drop

        bld.InitialCatalog = "master";

        var masterConnectionString = bld.ConnectionString;

        using (var cnn = new SqlConnection(masterConnectionString))
        {

            using (var cmd = new System.Data.SqlClient.SqlCommand())
            {
                cmd.Connection = cnn;
                cnn.Open();
                cmd.CommandText = string.Format("ALTER DATABASE {0} SET  SINGLE_USER WITH ROLLBACK IMMEDIATE",
                              dbName);
                cmd.ExecuteNonQuery();
                cmd.CommandText = string.Format("DROP DATABASE {0}",
                              dbName);
                cmd.ExecuteNonQuery();
            }
        }             
    }