public static IEnumerable <T> Query <T>(this IDbConnection cnn, SQL sql, IDbTransaction transaction = null, bool buffered = true, int?commandTimeout = default(int?), CommandType?commandType = default(CommandType?)) { var strSql = sql.Compile(); var param = new DapperParameter(sql.Parameters); return(SqlMapper.Query <T>(cnn, strSql, param, transaction, buffered, commandTimeout, commandType)); }
public static async Task <IEnumerable <dynamic> > QueryAsync(this IDbConnection cnn, SQL sql, IDbTransaction transaction = null, int?commandTimeout = default(int?), CommandType?commandType = default(CommandType?)) { var strSql = sql.Compile(); var param = new DapperParameter(sql.Parameters); return(await SqlMapper.QueryAsync(cnn, strSql, param, transaction, commandTimeout, commandType)); }
public static IDataReader ExcuteReader(this IDbConnection cnn, SQL sql, IDbTransaction transaction = null, int?commandTimeout = default(int?), CommandType?commandType = default(CommandType?)) { var strSql = sql.Compile(); var param = new DapperParameter(sql.Parameters); return(SqlMapper.ExecuteReader(cnn, strSql, param, transaction, commandTimeout, commandType)); }
public static async Task <T> ExcuteScalarAsync <T>(this IDbConnection cnn, SQL sql, IDbTransaction transaction = null, int?commandTimeout = default(int?), CommandType?commandType = default(CommandType?)) { var strSql = sql.Compile(); var param = new DapperParameter(sql.Parameters); return(await SqlMapper.ExecuteScalarAsync <T>(cnn, strSql, param, transaction, commandTimeout, commandType)); }
public static T QuerySingleOrDefault <T>(this IDbConnection cnn, SQL sql, IDbTransaction transaction = null, int?commandTimeout = default(int?), CommandType?commandType = default(CommandType?)) { var strSql = sql.Compile(); var param = new DapperParameter(sql.Parameters); return(SqlMapper.QuerySingleOrDefault <T>(cnn, strSql, param, transaction, commandTimeout, commandType)); }