EF, Code First, how to initialize database on a specific location (HDD)

I was able to get the below working, in both the database exists and non-exists scenarios, however, there is one issue in that the Code First table creation isn't being triggered (i.e. this is only a partial solution - there is still a step needed to actually get EF to create the Code First tables).

(My context was called Model1)

public class MyCustomInitialized : DropCreateDatabaseAlways<Model1>
{
    public override void InitializeDatabase(Model1 context)
    {
        if (context.Database.Exists())
        {
            // set the database to SINGLE_USER so it can be dropped
            context.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction,
                "ALTER DATABASE [" + context.Database.Connection.Database +
                "] SET SINGLE_USER WITH ROLLBACK IMMEDIATE");

            // drop the database
            context.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction,
                "USE master DROP DATABASE [" + context.Database.Connection.Database + "]");
        }
        var directoryPath = @"c:\temp";
        var fileName = "Foo";

        var qry = string.Format(
            "USE master CREATE DATABASE {0}" + Environment.NewLine +
            "ON PRIMARY" + Environment.NewLine +
            "( NAME = {0}, FILENAME = '{1}')" + Environment.NewLine +
            "LOG ON" + Environment.NewLine +
            "( NAME = {2}, FILENAME = '{3}')" + Environment.NewLine
            , context.Database.Connection.Database,
            Path.Combine(directoryPath, fileName + ".mdf"),
            context.Database.Connection.Database + "_log",
            Path.Combine(directoryPath, fileName + "_log.ldf"));

        using (var conn = new SqlConnection(@"data source=.\SQLExpress;initial catalog=master;integrated security=True;"))
        using (var cmd = new SqlCommand(qry, conn))
        {
            conn.Open();
            cmd.ExecuteNonQuery();
        }

        -- TODO trigger the table creation
        this.Seed(context);
        context.SaveChanges();
    }
}

Some notes:

• Database belongs to the context
• You won't be able to recreate the database on the Context connection, since when you drop the database, the Initial Catalog in your EF connection string will have disappeared. I've just used a new Ado Connection to do the Drop, else "Cannot open database \"FOO\" requested by the login". I would also consider moving the DROP of the Context connection into a master connection.

Calling

base.InitializeDatabase(context);

Causes the Db to be dropped and recreated because of the DropCreateDatabaseAlways strategy which includes:

context.Database.Delete();
context.Database.Create(DatabaseExistenceState.DoesNotExist);

So hence

-- missing something here, viz creating the tables
this.Seed(context);
context.SaveChanges();