怎么将数据LINQ到LIST<object>

如何将数据LINQ到LIST<object>

求一 关于 List<CustomerTree> 的 Linq表达式


1. sql 语句
 select fcustno, forderno, forderdate from t_orders
 
2. db 数据
fcustno forderno forderdate
1010 101002 2003/4/25
1010 101001 2003/4/25
1010 101002 2003/4/25
1020 102001 2003/4/25
1020 102002 2003/4/25
 
3.model 对象
  public class CustomerTree
  {
  public string customerId { get; set; }  
  public List<orderInfo> orders { get; set; }  
  }
 
  public class orderInfo
  {
  public string orderNo { get; set; }
  public DateTime orderDate { get; set; }  
  }
 
4.期望 结果

List<CustomerTree> trees 按照第1列分组 讲第2列第3列 放到orderInfo集合中




[解决办法]

C# code

List<CustomerTree> query = db.GroupBy(x => x.fcustno)              .Select(x => new CustomerTree()                               {                                   customerId = x.Key,                                   orders = db.Where(y => y.fcustno == x.Key)                                              .Select(y => new orderInfo()                                                               {                                                                   orderNo = y.forderno,                                                                   orderDate = forderdate                                                               }).ToList()                               }).ToList();