public static ISqlProvider Create(string provider)
{
//ISqlConverter Factory
switch (provider)
{
case DbSetting.Provider_Oracle:
if (_oracleConverter == null)
{
_oracleConverter = new OracleProvider();
}
return(_oracleConverter);
case DbSetting.Provider_Odbc:
if (_odbcConverter == null)
{
_odbcConverter = new ODBCProvider();
}
return(_odbcConverter);
case DbSetting.Provider_SqlClient:
case DbSetting.Provider_SqlCe:
default:
if (_sqlConverter == null)
{
_sqlConverter = new SqlServerProvider();
}
return(_sqlConverter);
//throw new NotSupportedException("This type of database is not supportted now:" + provider);
}
}
public static ISqlProvider Create(string provider)
{
//ISqlConverter Factory
switch (provider)
{
case DbSetting.Provider_Odbc:
if (_odbcConverter == null) _odbcConverter = new ODBCProvider();
return _odbcConverter;
case DbSetting.Provider_SqlClient:
case DbSetting.Provider_SqlCe:
if (_sqlConverter == null) _sqlConverter = new SqlServerProvider();
return _sqlConverter;
default:
if (DbSetting.IsOracleProvider(provider))
{
if (_oracleConverter == null) _oracleConverter = new OracleProvider();
return _oracleConverter;
}
if (_sqlConverter == null) _sqlConverter = new SqlServerProvider();
return _sqlConverter;
}
}
/// <summary>
/// 创建指定的链接字符串的转换器
/// </summary>
/// <param name="provider">指定的数据库的提供程序</param>
/// <returns>返回针对指定数据库的 ISqlProvider 类型的具体对象实例</returns>
public static ISqlProvider Create(string provider)
{
//ISqlConverter Factory
switch (provider)
{
case DbSetting.Provider_Odbc:
if (_odbcConverter == null)
{
_odbcConverter = new ODBCProvider();
}
return(_odbcConverter);
case DbSetting.Provider_SqlClient:
case DbSetting.Provider_SqlCe:
case DbSetting.Provider_SQLite:
if (_sqlConverter == null)
{
_sqlConverter = new SqlServerProvider();
}
return(_sqlConverter);
//PatrickLiu 增加的有关 MySql 的代码
case DbSetting.Provider_MySql:
if (_mySqlConverter == null)
{
_mySqlConverter = new MySqlServerProvider();
}
return(_mySqlConverter);
default:
if (DbSetting.IsOracleProvider(provider))
{
if (_oracleConverter == null)
{
_oracleConverter = new OracleProvider();
}
return(_oracleConverter);
}
if (_sqlConverter == null)
{
_sqlConverter = new SqlServerProvider();
}
return(_sqlConverter);
}
}
public static ISqlProvider Create(string provider)
{
//ISqlConverter Factory
switch (provider)
{
case DbSetting.Provider_Oracle:
if (_oracleConverter == null) _oracleConverter = new OracleProvider();
return _oracleConverter;
case DbSetting.Provider_Odbc:
if (_odbcConverter == null) _odbcConverter = new ODBCProvider();
return _odbcConverter;
case DbSetting.Provider_SqlClient:
case DbSetting.Provider_SqlCe:
default:
if (_sqlConverter == null) _sqlConverter = new SqlServerProvider();
return _sqlConverter;
//throw new NotSupportedException("This type of database is not supportted now:" + provider);
}
}
