where clause can be put twoice, isthere any reason behind it

rajesh yadav

hi,

in linq, where clause can be put twoice , pls give an example where two where clause is required.

one more thing in method based syntex , if i put two where clauses then is the execution follows any order. like

left to first or it can execute anywhere clause in any order.

yours sincerley

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishvjit Shinde6y ago
Hi Rajesh,
have a look at this

https://stackoverflow.com/questions/679644/multiple-where-clause-in-linq
rajesh yadav6y ago
well, that means it does not follow left to right execution if two where clause is applied?
Rajanikant Hawaldar6y ago
Hello Rajesh, Have look at this sample.results = results.Where(o => (o.OrderStatus == OrderStatus.Open)).Where(o => (o.CustomerID == customerID)); it's worth profiling the SQL server to check the query execution and see which one performs better for your data (if there's any difference at all).A note about chaining the .Where() methods: You can chain together all the LINQ methods you want. Methods like .Where() don't actually execute against the database (yet). They defer execution until the actual results are calculated (such as with a .Count() or a .ToList()). So, as you chain together multiple methods (more calls to .Where(), maybe an .OrderBy() or something to that effect, etc.) they build up what's called an expression tree. This entire tree is what gets executed against the data source when the time comes to evaluate it.Refer below article too https://www.c-sharpcorner.com/blogs/how-to-use-multiple-where-condition-in-linq