static IDatabaseProvider GetDatabaseProvider(SqlWrap sqlWrap, string partitionValues)
{
var dbConfig = SqlMapping.GetDatabase(sqlWrap.DbName);
if ((dbConfig.DBType & sqlWrap.SupportDbType) == 0)
{
throw new ArgumentOutOfRangeException(string.Format("SqlWrap[{0}] 不支持类型为{1}的数据库[{2}]", sqlWrap.FullName, dbConfig.DBType, sqlWrap.DbName));
}
var dbProvider = DatabaseProviderFactory.GetDatabaseProvider(dbConfig);
return(dbProvider);
}
public override void Start()
{
base.Start();
var databases = new List <DatabaseConfig>(1);
var dbConfig = new DatabaseConfig
{
ConfigName = "TestDB",
ConnectionString = "server=127.0.0.1;port=30603;user id=root;password=db2test;database=testdb;",
DBType = DatabaseType.MySql,
ProviderName = "MySqlProvider"
};
databases.Add(dbConfig);
SqlMapping.AppendDatabases(databases);
}
public override void Start()
{
base.Start();
var databases = new List <DatabaseConfig>(1);
var dbConfig = new DatabaseConfig
{
ConfigName = "TestDB",
ConnectionString = "server=127.0.0.1\\sql2008;user id=sa;password=db2Test;database=TestDb;",
DBType = DatabaseType.SqlServer,
ProviderName = "SqlServerProvider"
};
databases.Add(dbConfig);
SqlMapping.AppendDatabases(databases);
}
/// <summary>
/// 通过指定SQL名称获取SQL语句，执行后返回自增值
/// </summary>
/// <param name="sqlName"></param>
/// <param name="parameterValues"></param>
/// <param name="partitionValues">分区字段值列表</param>
/// <returns></returns>
public static T ExecuteIdentity <T>(string sqlName, IDictionary <string, object> parameterValues, string partitionValues)
{
var sqlWrap = SqlMapping.GetSqlWrap(sqlName);
return(ExecuteIdentity <T>(sqlWrap, parameterValues, partitionValues));
}
/// <summary>
/// 通过指定SQL名称执行SQL语句，获得DbDataReader后，使用委托Action[DbDataReader]处理数据流
/// </summary>
/// <param name="sqlName"></param>
/// <param name="parameterValues"></param>
/// <param name="partitionValues"></param>
/// <param name="action"></param>
public static void ExecuteReader(string sqlName, IDictionary <string, object> parameterValues, string partitionValues, Action <DbDataReader> action)
{
var sqlWrap = SqlMapping.GetSqlWrap(sqlName);
ExecuteReader(sqlWrap, parameterValues, partitionValues, action);
}
/// <summary>
///
/// </summary>
/// <param name="sqlName"></param>
/// <param name="parameterValues"></param>
/// <param name="pagination"></param>
/// <param name="partitionValues"></param>
/// <returns></returns>
public static DataTable ExecutePaginationTable(string sqlName, IDictionary <string, object> parameterValues, Pagination pagination, string partitionValues)
{
var sqlWrap = SqlMapping.GetSqlWrap(sqlName);
return(ExecutePaginationTable(sqlWrap, parameterValues, pagination, partitionValues));
}
