private static string PrintAbstractFactory_GetFactoryName(EnumDbProvider dbProvider)
{
switch (dbProvider)
{
case EnumDbProvider.Odbc:
return("System.Data.Odbc");
case EnumDbProvider.OleDb:
return("System.Data.OleDb");
case EnumDbProvider.OracleClient:
return("System.Data.OracleClient");
case EnumDbProvider.SqlClient:
return("System.Data.SqlClient");
default:
throw new ArgumentOutOfRangeException(nameof(dbProvider), dbProvider, null);
}
}
public Database(EnumDbProvider provider, string connectionString = null)
: this(DbProviderFactories.GetFactory(GetProviderName(provider)), connectionString)
{
}
private static string GetProviderName(EnumDbProvider provider)
{
string providerInvariantName = null;
if (provider == EnumDbProvider.SqlServer)
providerInvariantName = "System.Data.SqlClient";
else if (provider == EnumDbProvider.Oracle)
providerInvariantName = "System.Data.OracleClient";
else if (provider == EnumDbProvider.OleDb)
providerInvariantName = "System.Data.OleDb";
else if (provider == EnumDbProvider.Odbc)
providerInvariantName = "System.Data.Odbc";
else if (provider == EnumDbProvider.SqlServerCompact)
providerInvariantName = "System.Data.SqlServerCe.4.0";
else if (provider == EnumDbProvider.MySql)
providerInvariantName = "MySql.Data.MySqlClient";
return providerInvariantName;
}
