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