Linq Syntax Any()

Question

I have this pseudo object

list<ListOfCars>{
   list<ListOfParts>
}

I currently have this query

ListOfCars.Where(x => x.ListofParts.Any(y => y.PartIsDeleted == false));

On my investigation, it returns something if atleast 1 item satisfies the condition in the Any(y => y.PartIsDeleted == false).

My question is what is the syntax for something like this

SELECT * FROM ListOfCars cars WHERE  cars.ListOfParts.PartIsDeleted = false

Answer 1

There are 3 easy combinations in using Any and All.

1. Any
2. All
3. None

Be crystal clear which you do want.

---

At least one of ListofParts is not deleted.

ListOfCars.Where(x => x.ListofParts.Any(y => y.PartIsDeleted == false));

All of ListofParts are not deleted

ListOfCars.Where(x => x.ListofParts.All(y => y.PartIsDeleted == false));

None of ListofParts is deleted

ListOfCars.Where(x => x.ListofParts.Any(y => y.PartIsDeleted) == false);