select list of related grandchild entities

Question

Trying to get an IEnumerable WorkOrderHeader given the following table structure:

OrderHeader 1:many OrderDetails
OrderDetail 1:1 WorkOrderHeader

Code:

public IEnumerable<WorkOrderHeader> GetInProcessWorkOrdersForOrderBy(OrderHeader orderHeader)
{
    var orderDetails = orderHeader.OrderDetails;
    var workOrders= orderDetails.Select(od => od.WorkOrderHeaders.Where(woh => woh.StatusId < (int)WorkOrderStatus.Complete));
    return workOrders;
}

This is returning a nested IEnumerable<IEnumerable<WorkOrderHeader>>. How do I get just the inner IEnumerable<WorkOrderHeader>?

List of list? `SelectMany()` to flatten it. http://stackoverflow.com/questions/958949/ — Yuck, Mar 10 '14 at 20:03
@Yuck yep...I always forget about the ol' SelectMany(). Thanks. — crichavin, Mar 10 '14 at 20:14

score 2 · Accepted Answer · answered Mar 10 '14 at 20:10

2

I think you are looking for SelectMany

var workOrders= orderDetails.SelectMany(od => ...)

answered Mar 10 '14 at 20:10

Aducci

25,111
8
64
65

select list of related grandchild entities

1 Answers1