linq调用mysql函数_如何为linq对象制作一个展平函数(Linq To Entities for mysql)？

我正在升级一个旧程序并使用

linq进行基本选择,以便我可以在进程中学习linq.

我有一个重复的任务,只是显示来自各种连接的数据是网格视图,

以下是一个示例

protected void Page_Load(object sender, EventArgs e)

{

using ( vavestockModel.vavestockEntities db = new vavestockModel.vavestockEntities())

{

var prod = (from p in db.products select p);

var prodd = (from p in db.productdetails select p);

var prode = (from p in db.product_extra_data select p);

var join1 = (from p in prod

join

pd in prodd

on p.PrStyle equals pd.StyleCode

select new {pr=p,prd=pd }).ToList();

var join2 = (from p in prod

join

pd in prodd

on p.PrStyle equals pd.StyleCode

select new { p.PrShow,p.PrPrice,pd.I_EAN_51,pd.I_EAN_50 }).ToList();

var join3 = (from p in prod

join

pd in prodd

on p.PrStyle equals pd.StyleCode

select new { flattenmodel(p),flattenmodel(pd) }).ToList();

Response.Write(join1);

GridView1.DataSource = join1;

GridView1.DataBind();

}

}

??object flattenmodel(vavestockModel.vavestockEntities en)//? here i want to pass any table row

{

string[] toren;

//foreach (var item in en.)

//{

//}

return toren;

}

join1可以绑定到gridview而join1不能,因为它们返回实体对象.因为我必须选择所有列重复写入所有名称的列,所以这么多表不是明智的选择,因此我想编写一个返回展平数据的函数.

但我发现很难继续下去.我的困难即将到来,因为在这种情况下我不知道应该返回什么并作为参数传递.有人能指出我正确的方向继续吗？

最佳答案 您可以通过System.Reflection获取对象的所有属性.这里是一个示例,您可以从所有属性获取值并将它们存储在List中,并且可以将此List指定为数据源.

Entities ent = new Entities();

var data = (from x in ent.Employees where x.Id == 1 select x).FirstOrDefault();

List list = ConvertToList(data);

public List ConvertToList(object obj)

{

List list = new List();

PropertyInfo[] pinfo = obj.GetType().GetProperties();

foreach (var info in pinfo)

{

if (info.GetValue(obj) != null)

list.Add(info.GetValue(obj, null).ToString());

}

return list;

}

编辑

您还可以从匿名对象返回DataTable.

public DataTable ConvertToDataTable(IEnumerable obj)

{

DataTable dt = new DataTable();

foreach (dynamic item in obj)

{

DataRow dr = dt.NewRow();

PropertyInfo[] pinfo = item.GetType().GetProperties();

foreach (var info in pinfo)

{

if (!dt.Columns.Contains(info.Name))

dt.Columns.Add(info.Name, info.PropertyType);

var val= info.GetValue(item, null);

dr[info.Name] = val;

}

dt.Rows.Add(dr);

}

return dt;

}

以下是您将如何称呼它

Entities ent = new Entities();

var data = (from x in ent.Employees where x.Id == 1 select x).FirstOrDefault();

DataTable dt=ConvertToDataTable(data);