IQueryable .Where to filter by properties on child objects

  • Thread starter Thread starter powpowqueen
  • Start date Start date
P

powpowqueen

Hi I have just started using IQueryable and have a question that is a
little more complicated than any examples i can find

Can anyone answer my problem?

I have a 2 classess

Product and Colour

A product has a stock count.
a product has one colour
a colour has many products.

I have a IQueryable<Colour> object and would like to write the Where
criteria on this to get
All colours that have a product with stock >= 50.

Any ideas?

I know that if i was doing this in reverse using IQueryable<Product> i
would write
..Where(e => e.Stock >= stock)
and then get the colour property.

But i really want to be able to do this from the iqueryable collection
of Colours

Thanks in advance
 
Hi I have just started using IQueryable and have a question that is a
little more complicated than any examples i can find

Can anyone answer my problem?

I have a 2 classess

Product and Colour

A product has a stock count.
a product has one colour
a colour has many products.

I have a IQueryable<Colour> object and would like to write the Where
criteria on this to get
All colours that have a product with stock >= 50.

Any ideas?

I know that if i was doing this in reverse using IQueryable<Product> i
would write
.Where(e => e.Stock >= stock)
and then get the colour property.

But i really want to be able to do this from the iqueryable collection
of Colours
Click to expand...

Keep in mind that all those LINQ queries (and lambdas in general) can
be nested. So:

colors.Where(c => c.Products.Any(p => p.Stock >= 50));
 
Keep in mind that all those LINQ queries (and lambdas in general) can
be nested. So:

  colors.Where(c => c.Products.Any(p => p.Stock >= 50));- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks very much, this is exactly what i needed, - i think i was
almost there, i had
colours.where(c => c.Products.Where(p => p.Stock >= 50));

I needed to use Any :)
 
Back
Top