public async Task <List <T> > SelectAsync <T>()
{
try
{
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
var tInstance = (T)Activator.CreateInstance <T>();
var query = _queryBuilder.GetSelectRawQuery(tInstance);
using (MySqlDataAdapter da = new MySqlDataAdapter(query, con))
{
DataTable dt = new DataTable();
await da.FillAsync(dt);
List <T> lstResult = DataTableUtility.DataTableToList <T>(dt);
return(lstResult);
}
}
}
catch (Exception ex)
{
ex.ToString();
throw ex;
}
}
