public static DataSet GetDataSetResult <TEntity>(this ModelSource <TEntity> models, IQueryable items) where TEntity : class, new() { using (SqlCommand sqlCmd = (SqlCommand)models.GetCommand(items)) { sqlCmd.Connection = (SqlConnection)models.GetDataContext().Connection; using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd)) { DataSet ds = new DataSet(); adapter.Fill(ds); return(ds); } } }
public static DataSet GetDataSetResult <TEntity>(this ModelSource <TEntity> models, IQueryable items, DataTable table) where TEntity : class, new() { using (SqlCommand sqlCmd = (SqlCommand)models.GetCommand(items)) { sqlCmd.Connection = (SqlConnection)models.GetDataContext().Connection; using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd)) { int colCount = table.Columns.Count; adapter.Fill(table); if (colCount > 0) { while (table.Columns.Count > colCount) { table.Columns.RemoveAt(table.Columns.Count - 1); } } return(table.DataSet); } } }