/// <summary>
/// Initializes a new instance of the <see cref="Database"/> class.
/// </summary>
/// <param name="dbProvider">The db provider.</param>
public Database(DbProviders.DbProvider dbProvider)
{
Check.Require(dbProvider != null, "dbProvider could not be null.");
this.dbProvider = dbProvider;
this.queryFactory = dbProvider.GetQueryFactory();
}
static DbProviderFactory()
{
try
{
ConnectionStringSettings connStrSetting = ConfigurationManager.ConnectionStrings[ConfigurationManager.ConnectionStrings.Count - 1];
string[] assAndClass = connStrSetting.ProviderName.Split(',');
if (assAndClass.Length > 1)
{
_Default = CreateDbProvider(assAndClass[1].Trim(), assAndClass[0].Trim(), connStrSetting.ConnectionString);
}
else
{
_Default = CreateDbProvider(null, assAndClass[0].Trim(), connStrSetting.ConnectionString);
}
}
catch
{
_Default = null;
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Database"/> class.
/// </summary>
/// <param name="type">The type.</param>
/// <param name="connectionString">The connection string.</param>
public Database(DatabaseType type, string connectionString)
{
Check.Require(!string.IsNullOrEmpty(connectionString), "connectionString could not be null or empty.");
//switch (type)
//{
// case DatabaseType.MsAccess:
// this.dbProvider = DbProviders.DbProviderFactory.CreateDbProvider(null, typeof(DbProviders.MsAccess.AccessDbProvider).ToString(), connectionString);
// break;
// case DatabaseType.SqlServer:
// this.dbProvider = DbProviders.DbProviderFactory.CreateDbProvider(null, typeof(DbProviders.SqlServer.SqlDbProvider).ToString(), connectionString);
// break;
// case DatabaseType.SqlServer9:
// this.dbProvider = DbProviders.DbProviderFactory.CreateDbProvider(null, typeof(DbProviders.SqlServer.SqlDbProvider9).ToString(), connectionString);
// break;
// case DatabaseType.MySql:
// this.dbProvider = DbProviders.DbProviderFactory.CreateDbProvider("NBearLite.AdditionalDbProviders", "NBearLite.DbProviders.MySql.MySqlDbProvider", connectionString);
// break;
// case DatabaseType.Oracle:
// this.dbProvider = DbProviders.DbProviderFactory.CreateDbProvider(null, typeof(DbProviders.Oracle.OracleDbProvider).ToString(), connectionString);
// break;
// case DatabaseType.Sqlite:
// this.dbProvider = DbProviders.DbProviderFactory.CreateDbProvider("NBearLite.AdditionalDbProviders", "NBearLite.DbProviders.Sqlite.SqliteDbProvider", connectionString);
// break;
// case DatabaseType.PostgreSql:
// this.dbProvider = DbProviders.DbProviderFactory.CreateDbProvider("NBearLite.AdditionalDbProviders", "NBearLite.DbProviders.PostgreSql.PostgreSqlDbProvider", connectionString);
// break;
// case DatabaseType.DB2:
// this.dbProvider = DbProviders.DbProviderFactory.CreateDbProvider("NBearLite.AdditionalDbProviders", "NBearLite.DbProviders.DB2.DB2DbProvider", connectionString);
// break;
// default:
// throw new NotSupportedException("Unknow DatabaseType.");
//}
this.dbProvider = new DbProviders.SqlServer.SqlDbProvider9(connectionString);
this.queryFactory = dbProvider.GetQueryFactory();
}
/// <summary>
/// Initializes a new instance of the <see cref="Database"/> class.
/// </summary>
/// <param name="connectionStringName">Name of the connection string.</param>
public Database(string connectionStringName)
{
this.dbProvider = DbProviders.DbProviderFactory.CreateDbProvider(connectionStringName);
this.queryFactory = dbProvider.GetQueryFactory();
}
static DbProviderFactory()
{
ConnectionStringSettings connStrSetting = ConfigurationManager.ConnectionStrings[ConfigurationManager.ConnectionStrings.Count - 1];
_Default = new SqlServer.SqlDbProvider9(connStrSetting.ConnectionString);
}