如何使用实体框架将查询结果填充到数据集中 [英] How Can I Fill Query Results Into Dataset Using Entity Framework
本文介绍了如何使用实体框架将查询结果填充到数据集中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想使用Linq
解决方案
public DataTable GetDepartmentsForSorting(DepartmentInfo _DepartmentInfo)
{
QuizEntity entity = new QuizEntity();
DataTable dt = new DataTable();
dt.Columns.Add( DeptID, typeof ( double ));
dt.Columns.Add( DeptName, typeof ( string ));
尝试
{
var a = entity.tblDepartments.AsQueryable ();
if (_DepartmentInfo.DeptName!= string .Empty)
{
a = a.Where(e = > e.ClientID == _DepartmentInfo.ClientID&& e.DeptName.Contains(_DepartmentInfo.DeptName))。OrderByDescending (e = > e.DeptID);
}
else
{
a = a.Where(e = > e.ClientID == _DepartmentInfo.ClientID).OrderBy(e = > e.DeptName);
}
foreach ( var dr in a)
{
DataRow row = dt.NewRow();
row.SetField< double>( DeptID,dr.DeptID );
row.SetField< string>( DeptName,dr.DeptName);
dt.Rows.Add(row);
}
}
catch (例外情况)
{
throw new 例外(ex.Message);
}
最后
{
entity.Dispose();
}
return dt;
}
< / string > < / double > ; 跨度>
Hi,
I want to fill query results into dataset using Linq
解决方案
public DataTable GetDepartmentsForSorting(DepartmentInfo _DepartmentInfo) { QuizEntity entity = new QuizEntity(); DataTable dt = new DataTable(); dt.Columns.Add("DeptID", typeof(double)); dt.Columns.Add("DeptName", typeof(string)); try { var a = entity.tblDepartments.AsQueryable(); if (_DepartmentInfo.DeptName != string.Empty) { a = a.Where(e => e.ClientID == _DepartmentInfo.ClientID && e.DeptName.Contains(_DepartmentInfo.DeptName)).OrderByDescending(e => e.DeptID); } else { a = a.Where(e => e.ClientID == _DepartmentInfo.ClientID).OrderBy(e => e.DeptName); } foreach (var dr in a) { DataRow row = dt.NewRow(); row.SetField<double>("DeptID", dr.DeptID); row.SetField<string>("DeptName", dr.DeptName); dt.Rows.Add(row); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { entity.Dispose(); } return dt; } </string></double>
这篇关于如何使用实体框架将查询结果填充到数据集中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文