Difference between Select and Where in Entity Framework
Select
is a projection, so what you get is the expression x=> x.FirstName == "John"
evaluated for each element in ContextSet()
on the server. i.e. lots of true/false values (the same number as your original list). If you look the select will return something like IEnumerable<bool>
(because the type of x=> x.FirstName == "John"
is a bool).
Where
filters the results, returning an enumerable of the original type (no projection).
So, use Select
when you want to keep all results, but change their type (project them).
Use Where
when you want to filter your results, keeping the original type
Where()
is a filter.
Select()
selects a different piece of data.
Your Select()
example will return a collection of booleans.