/// <summary>
/// 执行ＳＱＬ语句或者存储过程 ,返回IEnumerable<T>
/// </summary>
/// <typeparam name="T">返回类似</typeparam>
/// <param name="connKey">连接字符串Key</param>
/// <param name="commandText">ＳＱＬ语句或者存储过程名</param>
/// <param name="commandParameters">ＳＱＬ语句或者存储过程参数</param>
/// <param name="commandType">ＳＱＬ语句类型</param>
/// <param name="commandTimeout">超时时间</param>
/// <returns>IEnumerable</returns>
public IEnumerable <T> ExecuteIEnumerable <T>(string connKey, string commandText, List <IDataParameter> commandParameters = null, CommandType commandType = CommandType.Text, int?commandTimeout = null) where T : class, new()
{
using (SqlConnection conn = GetConnByKey(connKey))
{
using (IDataReader dr = SQLHelper.ExecuteReader(conn, commandText, commandParameters, commandType, commandTimeout))
{
return(DataReaderExtensions.DataReaderToList <T>(dr));
}
}
}
/// <summary>
/// 执行ＳＱＬ语句或者存储过程 ,返回IEnumerable<T>
/// </summary>
/// <typeparam name="T">返回类似</typeparam>
/// <param name="trans">语句所在的事务</param>
/// <param name="commandText">ＳＱＬ语句或者存储过程名</param>
/// <param name="commandParameters">ＳＱＬ语句或者存储过程参数</param>
/// <param name="commandType">ＳＱＬ语句类型</param>
/// <param name="commandTimeout">超时时间</param>
/// <returns>IEnumerable</returns>
public IEnumerable <T> ExecuteIEnumerable <T>(IDbTransaction trans, string commandText, List <IDataParameter> commandParameters = null, CommandType commandType = CommandType.Text, int?commandTimeout = null) where T : class, new()
{
IDataReader dr = SQLHelper.ExecuteReader(trans, commandText, commandParameters, commandType, commandTimeout);
return(DataReaderExtensions.DataReaderToList <T>(dr));
}