How to use this LINQ with multiple "Where"?

Question

Say I have this structure:

public class Car
{
   public string Name;
   public IList<Tire> Tires;
}

public class Tire
{
   public string Name;
   public int Size;
}

I want a query to return all Cars that have Tires with size 40.

I am thinking this way, what am I missing?

Cars.Where(x => x.Tires.Where(y => y.Size == 40));

This code throws this error: "Cannot convert lambda expression to delegate type 'System.Func' because some of the return types in the block are not implicitly convertible to the delegate return type"

Is it actually an acceptable scenario that a car would have multiple tires of different sizes? If not, you might want to consider changing your model to not allow that — Ben Aaronson
– Ben Aaronson, Commented May 12, 2014 at 14:48

Ben Aaronson · Accepted Answer · 2014-05-12 15:39:12Z

8

You want

Cars.Where(x => x.Tires.Any(y => y.Size == 40));

or

Cars.Where(x => x.Tires.All(y => y.Size == 40));

Depending on the requirement.

Your version won't work because the outer lambda is actually returning an IEnumerable<Tire>, whereas it needs to be a bool.

edited May 12, 2014 at 15:39

answered May 12, 2014 at 14:43

Ben Aaronson

6,9752 gold badges27 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ventsyslav Raikov · Accepted Answer · 2014-05-12 14:43:37Z

2

You should use Any instead.

Cars.Where(x => x.Tires.Any(y => y.Size == 40));

answered May 12, 2014 at 14:43

Ventsyslav Raikov

7,2521 gold badge27 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to use this LINQ with multiple "Where"?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related