Linq-to-SQL问题

Question

查找所有购买量小于10000的客户

var Customer = from c in _NorthWindDataContext.Customers
               join o in _NorthWindDataContext.Orders on c.CustomerID equals o.CustomerID
               group c by c.CustomerID into CutGroup
               where CutGroup.Sum(tab => tab.Orders.Sum(t => t.Order_Details.Sum(t1 => t1.Quantity * t1.Quantity))) < 10000
               select new
               {
                  CustomerID = CutGroup.Key,
                  Total = CutGroup.Sum(tab => tab.Orders.Sum(t => t.Order_Details.Sum(t1 => t1.Quantity *  t1.Quantity))),
               };

我已经解决了它，但如果我想访问Order表信息，那么我如何访问...

供您参考，我将客户绑定到grid....so，但不能分别使用

Answer 1

如果我没弄错你想要什么，你可以试试这个：

    var Customer = from c in _NorthWindDataContext.Customers
                join o in _NorthWindDataContext.Orders on c.CustomerID equals o.CustomerID
                group c by c.CustomerID into CutGroup
                where CutGroup.Sum(tab => tab.Orders.Sum(t => t.Order_Details.Sum(t1 => t1.Quantity * t1.Quantity))) < 10000
                select new
                {
                    CustomerID = CutGroup.Key,
                    Total = CutGroup.Sum(tab => tab.Orders.Sum(t => t.Order_Details.Sum(t1 => t1.Quantity * t1.Quantity))),

                    Orders = from os in _NorthWindDataContext.Orders where os.CustomerID == CutGroup.Key select os,
                };