some query can't be supported

Aug 19, 2009 at 4:39 PM

from o in db.Orders
                     group o by new { o.CustomerID, o.OrderDate } into g
                     select new
                     {
                         g.Key.CustomerID,
                         g.Key.OrderDate,
                         Amount = g.Sum(item => item.Items.Sum(d=>d.Amount))
                     };

from o in db.Orders
                     group o by new { o.Cusotmer.CustomerCode, o.OrderDate } into g
                     select new
                     {
                         g.Key.CustomerCode,
                         g.Key.OrderDate,
                         Amount = g.Sum(item.Amount)
                     };

 

and can't support left/right/full outer join, but i have add some code to support it.

 

Feb 1, 2011 at 10:47 AM

Can you post that code to support outer joins? Struggling with it right now and really don't feel like reinventing the wheel.

 

Thanks