public static DbContextOptionsBuilder UseConfiguration(this DbContextOptionsBuilder optionsBuilder, IDatabaseConfig databaseConfiguration, DatabaseType databaseType)
{
var connectionString = databaseConfiguration.GetConnectionString(databaseType);
switch (connectionString.Provider)
{
case DatabaseProvider.MySql:
optionsBuilder.UseMySql(connectionString.ConnectionString, b =>
{
b.EnableRetryOnFailure(5, TimeSpan.FromSeconds(10), null);
});
break;
default:
throw new NotSupportedException($"The requested database provider: {connectionString.Provider:G} is not supported.");
}
return(optionsBuilder);
}
/// <summary>
/// Create a new database.
/// </summary>
/// <param name="connection">The connection config.</param>
public PostgresDatabase(IDatabaseConfig config, IServiceProvider serviceProivder) : base(serviceProivder)
{
connection = config.GetConnectionString();
}
/// <summary>
/// Creates a new database connection with the configuration
/// provided
/// </summary>
/// <param name="config">The database access configuration</param>
/// <returns>Returns a new database connection</returns>
public IDatabaseConnection CreateConnection(IDatabaseConfig config)
{
if (config == null)
{
throw new ArgumentNullException("config");
}
if (string.Compare(config.Vendor, DatabaseConfig.MySql, true) == 0)
{
return String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionMySql("MySql.Data", "MySql.Data.MySqlClient.MySqlConnection", config.GetConnectionString())
: new DatabaseConnectionMySql(config.AssemblyName, config.FullClassName, config.GetConnectionString());
}
if (string.Compare(config.Vendor, DatabaseConfig.SqlServer, true) == 0)
{
return String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionSqlServer("System.Data", "System.Data.SqlClient.SqlConnection", config.GetConnectionString())
: new DatabaseConnectionSqlServer(config.AssemblyName, config.FullClassName, config.GetConnectionString());
}
if (string.Compare(config.Vendor, DatabaseConfig.SqlServerCe, true) == 0)
{
return String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionSqlServerCe("System.Data.SqlServerCe", "System.Data.SqlServerCe.SqlCeConnection", config.GetConnectionString())
: new DatabaseConnectionSqlServerCe(config.AssemblyName, config.FullClassName, config.GetConnectionString());
}
if (string.Compare(config.Vendor, DatabaseConfig.Oracle, true) == 0)
{
return String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionOracle("System.Data.OracleClient, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089", "System.Data.OracleClient.OracleConnection",
config.GetConnectionString())
: new DatabaseConnectionOracle(config.AssemblyName, config.FullClassName, config.GetConnectionString());
}
if (string.Compare(config.Vendor, DatabaseConfig.Access, true) == 0)
{
return String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionAccess("System.Data", "System.Data.OleDb.OleDbConnection", config.GetConnectionString())
: new DatabaseConnectionAccess(config.AssemblyName, config.FullClassName, config.GetConnectionString());
}
if (string.Compare(config.Vendor, DatabaseConfig.PostgreSql, true) == 0)
{
return String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionPostgreSql("Npgsql", "Npgsql.NpgsqlConnection", config.GetConnectionString())
: new DatabaseConnectionPostgreSql(config.AssemblyName, config.FullClassName, config.GetConnectionString());
}
if (string.Compare(config.Vendor, DatabaseConfig.SQLite, true) == 0)
{
return String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionSQLite("System.Data.SQLite", "System.Data.SQLite.SQLiteConnection", config.GetConnectionString())
: new DatabaseConnectionSQLite(config.AssemblyName, config.FullClassName, config.GetConnectionString());
}
if (string.Compare(config.Vendor, DatabaseConfig.Firebird, true) == 0)
{
return String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionFirebird("FirebirdSql.Data.FirebirdClient", "FirebirdSql.Data.FirebirdClient.FbConnection",
config.GetConnectionString())
: new DatabaseConnectionFirebird(config.AssemblyName, config.FullClassName, config.GetConnectionString());
}
if (string.Compare(config.Vendor, DatabaseConfig.FirebirdEmbedded, true) == 0)
{
return String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionFirebird("FirebirdSql.Data.FirebirdClient", "FirebirdSql.Data.FirebirdClient.FbConnection",
config.GetConnectionString())
: new DatabaseConnectionFirebird(config.AssemblyName, config.FullClassName, config.GetConnectionString());
}
if (string.Compare(config.Vendor, DatabaseConfig.Access2007, true) == 0)
{
return String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionAccess2007("System.Data", "System.Data.OleDb.OleDbConnection",
config.GetConnectionString())
: new DatabaseConnectionAccess2007(config.AssemblyName, config.FullClassName, config.GetConnectionString());
}
return null;
}
/// <summary>
/// Creates a new database connection with the configuration
/// provided
/// </summary>
/// <param name="config">The database access configuration</param>
/// <returns>Returns a new database connection</returns>
public IDatabaseConnection CreateConnection(IDatabaseConfig config)
{
if (config == null)
{
throw new ArgumentNullException("config");
}
if (string.Compare(config.Vendor, DatabaseConfig.MySql, true) == 0)
{
return(String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionMySql("MySql.Data", "MySql.Data.MySqlClient.MySqlConnection", config.GetConnectionString())
: new DatabaseConnectionMySql(config.AssemblyName, config.FullClassName, config.GetConnectionString()));
}
if (string.Compare(config.Vendor, DatabaseConfig.SqlServer, true) == 0)
{
return(String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionSqlServer("System.Data", "System.Data.SqlClient.SqlConnection", config.GetConnectionString())
: new DatabaseConnectionSqlServer(config.AssemblyName, config.FullClassName, config.GetConnectionString()));
}
if (string.Compare(config.Vendor, DatabaseConfig.SqlServerCe, true) == 0)
{
return(String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionSqlServerCe("System.Data.SqlServerCe", "System.Data.SqlServerCe.SqlCeConnection", config.GetConnectionString())
: new DatabaseConnectionSqlServerCe(config.AssemblyName, config.FullClassName, config.GetConnectionString()));
}
if (string.Compare(config.Vendor, DatabaseConfig.Oracle, true) == 0)
{
return(String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionOracle("System.Data.OracleClient, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089", "System.Data.OracleClient.OracleConnection",
config.GetConnectionString())
: new DatabaseConnectionOracle(config.AssemblyName, config.FullClassName, config.GetConnectionString()));
}
if (string.Compare(config.Vendor, DatabaseConfig.Access, true) == 0)
{
return(String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionAccess("System.Data", "System.Data.OleDb.OleDbConnection", config.GetConnectionString())
: new DatabaseConnectionAccess(config.AssemblyName, config.FullClassName, config.GetConnectionString()));
}
if (string.Compare(config.Vendor, DatabaseConfig.PostgreSql, true) == 0)
{
return(String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionPostgreSql("Npgsql", "Npgsql.NpgsqlConnection", config.GetConnectionString())
: new DatabaseConnectionPostgreSql(config.AssemblyName, config.FullClassName, config.GetConnectionString()));
}
if (string.Compare(config.Vendor, DatabaseConfig.SQLite, true) == 0)
{
return(String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionSQLite("System.Data.SQLite", "System.Data.SQLite.SQLiteConnection", config.GetConnectionString())
: new DatabaseConnectionSQLite(config.AssemblyName, config.FullClassName, config.GetConnectionString()));
}
if (string.Compare(config.Vendor, DatabaseConfig.Firebird, true) == 0)
{
return(String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionFirebird("FirebirdSql.Data.FirebirdClient", "FirebirdSql.Data.FirebirdClient.FbConnection",
config.GetConnectionString())
: new DatabaseConnectionFirebird(config.AssemblyName, config.FullClassName, config.GetConnectionString()));
}
if (string.Compare(config.Vendor, DatabaseConfig.FirebirdEmbedded, true) == 0)
{
return(String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionFirebird("FirebirdSql.Data.FirebirdClient", "FirebirdSql.Data.FirebirdClient.FbConnection",
config.GetConnectionString())
: new DatabaseConnectionFirebird(config.AssemblyName, config.FullClassName, config.GetConnectionString()));
}
if (string.Compare(config.Vendor, DatabaseConfig.Access2007, true) == 0)
{
return(String.IsNullOrEmpty(config.AssemblyName)
? new DatabaseConnectionAccess2007("System.Data", "System.Data.OleDb.OleDbConnection",
config.GetConnectionString())
: new DatabaseConnectionAccess2007(config.AssemblyName, config.FullClassName, config.GetConnectionString()));
}
return(null);
}