score:1

Accepted answer

The time your statement hits the db is when .ToList() is called. Hence what you do before that wouldn't create much difference in practice.

However from the perspective of pure mathematical performance, there should be some difference related with the translation process going behind those. Which can be understood by an experiment as @sujith karivelil suggests, or by some deep reading.

score:0

I think that using '&&' and '||' operators instead of multiple clauses essentially results in 1 enumeration over the full collection once. Multiple 'Where' clauses means you will enumerate over the full collection, then the results, which could be the full collection again.

score:0

I would suggest the use operator "&&" .. Because its filter the records at a single moment even used multiple condition. But if you use multiple where statements it definitely impact the performance because how many times you used where statement it hit the result query for filtering.


Related Articles