private static void SetDatabase <T>(IServiceCollection services, DatabaseType databaseType,
CosmosConfigurationParams cosmosConfigurationParams, string connectionString) where T : DbContext
{
switch (databaseType)
{
case DatabaseType.SqlServer:
services.AddDbContext <T>(options => options.UseSqlServer(connectionString,
sqlServerOptionsAction: sqlOptions =>
{
sqlOptions.EnableRetryOnFailure(
maxRetryCount: MaxRetryCount,
maxRetryDelay: TimeSpan.FromSeconds(MaxRetryDelay),
errorNumbersToAdd: null);
}), ServiceLifetime);
break;
case DatabaseType.InMemory:
services.AddDbContext <T>(options => options.UseInMemoryDatabase(connectionString), ServiceLifetime);
break;
case DatabaseType.MySql:
services.AddDbContext <T>(options => options.UseMySql(ServerVersion.AutoDetect(connectionString), sqlOptions =>
{
sqlOptions.EnableRetryOnFailure(
maxRetryCount: MaxRetryCount,
maxRetryDelay: TimeSpan.FromSeconds(MaxRetryDelay),
errorNumbersToAdd: new List <int>());
}), ServiceLifetime);
break;
case DatabaseType.MariaDb:
services.AddDbContext <T>(options => options.UseMySql(ServerVersion.AutoDetect(connectionString), sqlOptions =>
{
sqlOptions.EnableRetryOnFailure(
maxRetryCount: MaxRetryCount,
maxRetryDelay: TimeSpan.FromSeconds(MaxRetryDelay),
errorNumbersToAdd: new List <int>());
}), ServiceLifetime);
break;
case DatabaseType.Sqlite:
services.AddDbContext <T>(options => options.UseSqlite(connectionString), ServiceLifetime);
break;
case DatabaseType.Cosmos:
if (cosmosConfigurationParams == null)
{
throw new ArgumentException("The Cosmos configuration can not be null.");
}
services.AddDbContext <T>(options => options.UseCosmos(cosmosConfigurationParams.Endpoint,
cosmosConfigurationParams.Key, cosmosConfigurationParams.DatabaseName), ServiceLifetime);
break;
case DatabaseType.PostgreSQL:
services.AddDbContext <T>(options => options.UseNpgsql(connectionString, sqlOptions =>
{
sqlOptions.EnableRetryOnFailure(
maxRetryCount: MaxRetryCount,
maxRetryDelay: TimeSpan.FromSeconds(MaxRetryDelay),
errorCodesToAdd: new List <string>());
}), ServiceLifetime);
break;
case DatabaseType.FireBird:
services.AddDbContext <T>(options => options.UseFirebird(connectionString), ServiceLifetime);
break;
case DatabaseType.Oracle:
services.AddDbContext <T>(options => options.UseOracle(connectionString), ServiceLifetime);
break;
default:
throw new ArgumentException("Not provided a database driver");
}
}
public static void SetupDatabase <T>(this IServiceCollection services, string connectionString, DatabaseType databaseType, ServiceLifetime serviceLifetime = ServiceLifetime.Transient, CosmosConfigurationParams cosmosConfigurationParams = null) where T : DbContext
{
if (string.IsNullOrWhiteSpace(connectionString))
{
throw new ArgumentException($"The provided connection string ({connectionString}) provided does not exists.");
}
ServiceLifetime = serviceLifetime;
SetDatabase <T>(services, databaseType, cosmosConfigurationParams, connectionString);
}
public static async Task SetupDatabase <T>(this IServiceCollection services, IConfiguration configuration, string connectionStringName, DatabaseType databaseType, ServiceLifetime serviceLifetime = ServiceLifetime.Transient, bool migrate = false, CosmosConfigurationParams cosmosConfigurationParams = null) where T : DbContext
{
IConfigurationSection connectionString = GetConnectionString(configuration, connectionStringName);
ServiceLifetime = serviceLifetime;
SetDatabase <T>(services, databaseType, cosmosConfigurationParams, connectionString.Value);
if (migrate)
{
await Migrate <T>(services).ConfigureAwait(false);
}
}
public static void SetupDatabase <T>(this IServiceCollection services, IConfiguration configuration, string connectionStringName, DatabaseType databaseType, ServiceLifetime serviceLifetime = ServiceLifetime.Transient, bool migrate = false, CosmosConfigurationParams cosmosConfigurationParams = null) where T : DbContext
{
ServiceLifetime = serviceLifetime;
var applicationConnectionStrings = configuration.GetSection("ConnectionStrings").GetChildren();
if (applicationConnectionStrings == null)
{
throw new ArgumentException("There are no connection strings provided.");
}
var connectionString = applicationConnectionStrings.FirstOrDefault(c => c.Key.ToLower() == connectionStringName.ToLower());
if (connectionString == null || string.IsNullOrEmpty(connectionString.Value))
{
throw new ArgumentException($"The provided connection string ({connectionStringName}) provided does not exists.");
}
SetDatabase <T>(services, databaseType, cosmosConfigurationParams, connectionString.Value);
if (migrate)
{
Migrate <T>(services);
}
}
