internal async Task <List <T> > LoadDataAsync <T>(string storedProcedure)
{
IEnumerable <T> results = new List <T>();
using (IDbConnection connection = new SqlConnection(helper.GetConnectionString()))
{
results = await connection.QueryAsync <T>(storedProcedure, CommandType.StoredProcedure);
}
return(results.ToList());
}