public static async Task <List <dynamic> > ExecuteQueryAsync <T>(this T instance, string sql) where T : new()
{
var mereTable = MereUtils.CacheCheck <T>();
var toReturn = new List <dynamic>();
using (var myCn = mereTable.GetConnection())
{
var cmd = myCn.CreateCommand();
cmd.CommandText = sql;
await myCn.OpenAsync();
using (var reader = new MereSqlDataReader <T>(await cmd.ExecuteReaderAsync()))
{
while (reader.Read())
{
toReturn.Add((dynamic)reader);
}
myCn.Close();
}
}
return(toReturn);
}
public static IEnumerable <dynamic> ExecuteCustomDynamicQueryToDynamic <T>(this T instance, string sql) where T : new()
{
var mereTable = MereUtils.CacheCheck <T>();
var toReturn = new List <dynamic>();
using (var myCn = mereTable.GetConnection())
{
var cmd = myCn.CreateCommand();
cmd.CommandText = sql;
myCn.Open();
using (var reader = new MereSqlDataReader <T>(cmd.ExecuteReader()))
{
while (reader.Read())
{
toReturn.Add((dynamic)reader);
}
myCn.Close();
}
}
return(toReturn);
}
