Linq To Sql Problem.

See more:

LINQ

/*Find All Customer Whose Purchase is Less then 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))),
                           };

/*I have solved it but if i want to access Order table information like orderid,region then how can i access... For your information i am binding customer obj to grid....so i can not use for each */
pls help me on this.....