c# - 用 Linq 订购

Question

我与两个实体有一对多关系:

Order:
int OrderId 
string OrderNumber
...

OrderItem:
int ItemId
int sequence
decimal Quantity
...

一个 Order 有多个 OrderItems，我想编写一个 Linq 返回所有订单及其项目，项目按序列字段排序。我如何编写查询，例如以下查询？

Order myOrder = db.Orders.Include("OrderItems").Include("sequence").FirstOrDefault(x => x.OrderId == 3);

Answer 1

var result = from a in Order 
             join b in OrderItems
                on a.Id equals b.OrderId
             order by b.sequence
             select new
             {     
                 a.Id,
                 b.sequence,
                 ...
             };