public virtual async Task <GridReader> QueryMultipleAsync(string sql, object param = null, CommandType?commandType = null)
{
using (IDbConnection conn = new SqlConnection(ConnectionString))
{
return(await conn.QueryMultipleAsync(sql, param, null, null, commandType));
}
}
public async Task <Result> FetchMany <T>(T cmd)
{
Result result = new Result();
var functionParameter = new DynamicParameters();
try
{
functionParameter = parameters;
parameters = null;
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings[ConnectionStringName].ConnectionString))
{
var query = await db.QueryMultipleAsync(queryHandler.GetQuery(cmd), functionParameter == null?null : functionParameter, commandTimeout : 2, commandType : CommandType);
var listResult = query.Read <ProcResult>().ToList();
result.Source = listResult[0];
result.Success = true;
}
}
catch (Exception ex)
{
logging.WriteErrorLog($"FetchMany - {cmd} - { ConnectionStringName } " + ex.Message);
foreach (string item in functionParameter.ParameterNames)
{
logging.WriteErrorLog($"FetchMany - {item} ");
}
result.Message = ex.Message;
result.Success = false;
result.AffectedRows = 0;
}
return(result);
}