public static IMigrationRunnerBuilder UseSqlServer(
this IMigrationRunnerBuilder builder,
IConfiguration configuration)
{
builder
.AddSqlServer()
.WithGlobalConnectionString(configuration.GetConnectionString("ExampleSqlServer"));
return(builder);
}
public static IMigrationRunnerBuilder AddSupportedDatabases(this IMigrationRunnerBuilder builder, IEnumerable <string> supportedDialects)
{
foreach (var supportedDialect in supportedDialects)
{
switch (supportedDialect)
{
case MigratorDatabaseDialect.DB2:
builder = builder.AddDb2();
break;
case MigratorDatabaseDialect.Firebird:
builder = builder.AddFirebird();
break;
case MigratorDatabaseDialect.Hana:
builder = builder.AddHana();
break;
case MigratorDatabaseDialect.MySql:
builder = builder.AddMySql5();
break;
case MigratorDatabaseDialect.Oracle:
builder = builder.AddOracle();
break;
case MigratorDatabaseDialect.Postgres:
builder = builder.AddPostgres();
break;
case MigratorDatabaseDialect.Redshift:
builder = builder.AddRedshift();
break;
case MigratorDatabaseDialect.SqlAnywhere:
builder = builder.AddSqlAnywhere();
break;
case MigratorDatabaseDialect.SqlServer:
builder = builder.AddSqlServer();
break;
case MigratorDatabaseDialect.Sqlite:
builder = builder.AddSQLite();
break;
}
}
return(builder);
}
/// <summary>
/// Configure the database server
/// </summary>
/// <param name="builder">Configuring migration runner services</param>
/// <returns></returns>
public static IMigrationRunnerBuilder SetServer(this IMigrationRunnerBuilder builder)
{
var dataSettings = Singleton <DataSettings> .Instance;
switch (dataSettings.DataProvider)
{
case DataProviderType.SqlServer:
builder.AddSqlServer()
// set the connection string
.WithGlobalConnectionString(dataSettings.ConnectionString);
break;
}
return(builder);
}
public static IMigrationRunnerBuilder AddDb(this IMigrationRunnerBuilder rb)
{
if (string.Equals(Name, "Sqlite", StringComparison.OrdinalIgnoreCase))
{
rb.AddSQLite();
}
else if (Name.Equals("Postgres", StringComparison.OrdinalIgnoreCase))
{
rb.AddPostgres();
}
else if (Name.Equals("MySql", StringComparison.OrdinalIgnoreCase))
{
rb.AddMySql5();
}
else if (Name.Equals("MySql4", StringComparison.OrdinalIgnoreCase))
{
rb.AddMySql4();
}
else if (Name.Equals("MySql5", StringComparison.OrdinalIgnoreCase))
{
rb.AddMySql5();
}
else if (Name.Equals("SqlServer", StringComparison.OrdinalIgnoreCase))
{
rb.AddSqlServer();
}
else if (Name.Equals("SqlServer2012", StringComparison.OrdinalIgnoreCase))
{
rb.AddSqlServer2012();
}
else if (Name.Equals("SqlServer2014", StringComparison.OrdinalIgnoreCase))
{
rb.AddSqlServer2014();
}
else if (Name.Equals("SqlServer2016", StringComparison.OrdinalIgnoreCase))
{
rb.AddSqlServer2016();
}
else
{
throw new Exception("Not supported provider name: " + Name);
}
return(rb);
}
private static void ConfigureMigrationRunner(DatabaseEngine engine, IMigrationRunnerBuilder runnerBuilder)
{
switch (engine)
{
case DatabaseEngine.Postgres:
runnerBuilder.AddPostgres()
.WithGlobalConnectionString(GetConnectionString("PostgresDatabaseConnection"));
break;
case DatabaseEngine.SqlServer:
runnerBuilder.AddSqlServer()
.WithGlobalConnectionString(GetConnectionString("SqlServerDatabaseConnection"));
break;
default:
throw new ArgumentOutOfRangeException(nameof(engine), engine, $"Unknown engine {engine}");
}
runnerBuilder.ScanIn(typeof(InitialMigration).Assembly).For.Migrations();
}
/// <summary>
/// Get the correct database provider from the Migration Context
/// </summary>
/// <param name="runnerBuilder">IMigrationRunnerBuilder</param>
/// <param name="context">BaseMigrationContext</param>
/// <returns>IMigrationRunnerBuilder with correct database configured</returns>
public static IMigrationRunnerBuilder GetDatabase(this IMigrationRunnerBuilder runnerBuilder,
BaseMigrationContext context)
{
switch (context.DatabaseProvider)
{
case "postgresql":
return(runnerBuilder.AddPostgres());
case "sqlserver":
return(runnerBuilder.AddSqlServer());
case "sqlite":
return(runnerBuilder.AddSQLite());
case "firebird":
return(runnerBuilder.AddFirebird());
default:
throw new ArgumentException("Unable to define database provider");
}
}
bool IDbConfigurationBuilder.OnConfigureFluentMigrator(IMigrationRunnerBuilder runnerBuilder)
{
runnerBuilder.AddSqlServer().WithGlobalConnectionString(ConnectionString);
return(true);
}
public override void ConfigureMigrator(IMigrationRunnerBuilder builder) => builder.AddSqlServer();
bool IDbConfigurationBuilder.OnConfigureFluentMigrator(IMigrationRunnerBuilder runnerBuilder)
{
runnerBuilder.AddSqlServer().WithGlobalConnectionString("Data Source=localhost;Initial Catalog=TestWeb;Integrated Security=true;");
return(true);
}