c# - select list of related grandchild entities -
trying ienumerable workorderheader given 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 returning nested ienumerable<ienumerable<workorderheader>>. how inner ienumerable<workorderheader>?
i think looking selectmany
var workorders= orderdetails.selectmany(od => ...)
Comments
Post a Comment