Linq拼接子对象集合问题
public class Mytest{
private int id;
public int Id
{
get { return id; }
set { id = value; }
}
private string Name;
public string Name1
{
get { return Name; }
set { Name = value; }
}
private IList<CM_Affiche> cM_Affiches;
public IList<CM_Affiche> CM_Affiches
{
get { return cM_Affiches; }
set { cM_Affiches = value; }
}
}
我的封装类是这么写的 我想国通过linq求出 IList<Mytest>中的所有IList<CM_Affiche> list=?
不知道怎么写了 恳求大侠 --------------------编程问答-------------------- 也就是想求出实体集Mytest中 IList<CM_Affiche> 的汇总 --------------------编程问答-------------------- IList<Mytest> list=MytestBLl.GetEntities(sql);
怎么求出其中IList<CM_Affiche> 的汇总 --------------------编程问答--------------------
--------------------编程问答-------------------- IList<Mytest> list = ...
IList<Mytest> tests;
...
var list = (from test in tests select test.CM_Affiches).SelectMany(n => n);
var result = list.SelectManay(x => x.CM_Affiches); --------------------编程问答-------------------- 如下使用Aggregate方法也可以,不如上面的简单。
--------------------编程问答-------------------- 以NorthWindow中的Orders为例
var list2 = (from test in tests select test.CM_Affiches.AsEnumerable()).
Aggregate((cur, next) => cur.Concat(next));
Orders中有属性集合Order_Details
public partial class Orders : INotifyPropertyChanging, INotifyPropertyChanged
{
public EntitySet<Order_Details> Order_Details
{
get
{
return this._Order_Details;
}
set
{
this._Order_Details.Assign(value);
}
}
}
using (DataClassesDataContext db = new DataClassesDataContext())
{
//获取所有Orders中的Order_Details
IList<Order_Details> list = db.Orders.SelectMany(c => c.Order_Details).ToList();
}
补充:.NET技术 , LINQ