protected override void ConfigureMigrator(IMigrationRunnerBuilder runnerBuilder)
{
var sqliteConnectionString = Configuration.GetConnectionString("SQLite");
runnerBuilder.AddSQLite()
.WithGlobalConnectionString(sqliteConnectionString);
}
internal static IMigrationRunnerBuilder AddDatabase(this IMigrationRunnerBuilder self, string connectionString)
{
if (connectionString.EndsWith("temp.db"))
{
return(self.AddSQLite().WithGlobalConnectionString(connectionString));
}
return(self.AddPostgres().WithGlobalConnectionString(connectionString));
}
public static IMigrationRunnerBuilder UseSqlite(
this IMigrationRunnerBuilder builder,
IConfiguration configuration)
{
builder
.AddSQLite()
.WithGlobalConnectionString(configuration.GetConnectionString("ExampleSqlite"));
return(builder);
}
private static IMigrationRunnerBuilder WithDriver(IMigrationRunnerBuilder builder, string?driverName)
{
if ("Postgres" == driverName)
{
return(builder.AddPostgres());
}
if ("Sqlite" == driverName)
{
return(builder.AddSQLite());
}
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);
}
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);
}
/// <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");
}
}
private IMigrationRunnerBuilder ConfigureMigrationRunner(IMigrationRunnerBuilder migrationRunnerBuilder)
{
switch (Configuration.GetValue("DbType", "Sqlite"))
{
case "SQLServer":
migrationRunnerBuilder.AddSqlServer2016();
break;
case "MySQL":
migrationRunnerBuilder.AddMySql5();
break;
case "PostgreSQL":
migrationRunnerBuilder.AddPostgres();
break;
case "Sqlite":
migrationRunnerBuilder.AddSQLite();
break;
}
return(migrationRunnerBuilder);
}
/// <summary>Select database.</summary>
/// <param name="runner"> The migration-runner. </param>
private void SelectDatabase(IMigrationRunnerBuilder runner)
{
switch (SqlType)
{
case SqlType.Mssql:
runner.AddSqlServer2014();
break;
case SqlType.Mysql:
runner.AddMySql5();
break;
case SqlType.Pgsql:
runner.AddPostgres();
break;
case SqlType.Sqlite:
runner.AddSQLite();
break;
default:
throw new ArgumentOutOfRangeException();
}
}
public override void ConfigureMigrator(IMigrationRunnerBuilder builder)
{
builder.AddSQLite();
}
public IMigrationRunnerBuilder ConfigureRunner(IMigrationRunnerBuilder builder)
{
return(builder
.AddSQLite()
.WithGlobalConnectionString(_connectionString));
}