Linq How to group joined queries

user_13819766 0
Viewed 18

I am newbee and can join two datasets. I want to group these by OrderNo query. How can I manage that?

var result = context.Order
               .Join(context.OrderDetails
               , od => od.OrderId
               , o => o.OrderId
               , (o, od) => new {  
                       o.OrderNo, od.ProductName, o.OrderDate  
                })  
                .Select(s => s);
linq
1 Answers

try this

 var result = context.Order
                   .Join(context.OrderDetails
                   , od => od.OrderId
                   , o => o.OrderId
                   , (o, od) => new {  
                           o.OrderNo, od.ProductName, o.OrderDate  
                    })  
                    .GroupBy(p => new{
                          o.OrderNo
                    })
     
                    .Select(s => s);
user_138190700
Related