在项目开始时应用代码优先迁移

我想在项目开始时执行自动迁移。

代码及描述:创建到数据库的连接字符串，并映射数据库。

static class Program
{
    static void Main()
    {
        var connectStr = new SqlConnectionFactory()
            .CreateConnection(new SqlConnectionStringBuilder
            {
                DataSource = "NAME-DATABASE",
                InitialCatalog = "TestDB",
                IntegratedSecurity = true,
                ApplicationName = "TestDB"
            }.ToString());
        var SessionDB = new ContentDb(connectStr);
    }
}

数据库表TestDB和映射表的描述。

public class File
{
    public int Id { get; set; }
    public string Name { get; set; }
}
public class FileMap : EntityTypeConfiguration<File>
{
    public FileMap()
    {
        ToTable("FILE");
        HasKey(x => x.Id);
        Property(x => x.Name).HasColumnName("NAME");
    }
}

主类域。

public class ContentDb : DbContext
{
    public ContentDb(DbConnection connection): base(connection, true)
    {
        Database.SetInitializer(new ContentInitializer());
        Database.Initialize(true);
    }   
    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Configurations.Add(new FileMap());
        base.OnModelCreating(modelBuilder);
    }
}

类初始化和迁移

public class ContentInitializer : IDatabaseInitializer<ContentDb>
{
    public void InitializeDatabase(ContentDb context)
    {   
        if (!context.Database.Exists() || !context.Database.CompatibleWithModel(false))
        {
            var mConfig = new DbMigrationsConfiguration();
            mConfig.TargetDatabase = new DbConnectionInfo(context.Database.Connection.ConnectionString);
            var migrator = new DbMigrator(mConfig);
            var migrations = migrator.GetPendingMigrations();
            if (migrations.Any())
            {
                var scriptor = new MigratorScriptingDecorator(migrator);
                string script = scriptor.ScriptUpdate(null, migrations.Last());
                if (!String.IsNullOrEmpty(script))
                {
                    context.Database.ExecuteSqlCommand(script);
                }
            } 
        }
    }
}

Database.SetInitializer<ContentDb>(new MigrateDatabaseToLatestVersion<ContentDb, 
                                           Project.Migrations.Configuration>());
using (var dB = new ContentDb(connectStr))
{
    dB.Database.Initialize(true);
}