linq-to-sql combine .any expression
- by Victor
I need to filter out parent by property value of child collection.
I am doing something like this:
var results = (from c in db.Customers where
c.Orders.Any(o => o.Status = (int)Status.Ordered)
select c;
It's fine but now I need to filter by 2 values, i.e. take all parent records that have any chilren records that have BOTH values:
var results = (from c in db.Customers where
c.Orders.Any(o => o.Status == (int)Status.Ordered) && (o.Status == (int).Shipped))
select c;
Trying something obvious like this doesn't work.
