/// <summary>
/// 执行指定数据库连接字符串的数据阅读器
/// </summary>
/// <param name="connectionString">一个有效的数据库连接字符串</param>
/// <param name="cmdType">命令类型 (存储过程,命令文本或其它)</param>
/// <param name="cmdText">存储过程名或T-SQL语句</param>
/// <param name="dbParameters">执行命令所需要的数据库参数</param>
/// <returns>返回包含结果集的IDataReader对象</returns>
public IDataReader ExecuteReader(string connectionString, CommandType cmdType, string cmdText,
params IDataParameter[] dbParameters)
{
var connection = DbConnectionHelper.CreateConnection(_dbType, connectionString);
return(ExecuteReader(connection, cmdType, cmdText, dbParameters));
}
/// <summary>
/// 执行指定类型的数据库命令
/// </summary>
/// <param name="connectionString">数据库连接字符串</param>
/// <param name="cmdType">数据库命令类型（存储过程、文本以及其它）</param>
/// <param name="cmdText">存储过程名称或者SQL语句</param>
/// <param name="dbParameters">执行命令所需要的参数数组</param>
/// <returns>返回命令所影响的行数</returns>
public int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText,
params IDataParameter[] dbParameters)
{
using (var connection = DbConnectionHelper.CreateConnection(_dbType, connectionString))
{
return(ExecuteNonQuery(connection, cmdType, cmdText, dbParameters));
}
}