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; } }