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

Question

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

Rajanikant Hawaldar · Answer

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

Vishvjit Shinde · Answer

Hi Rajesh, have a look at this https://stackoverflow.com/questions/679644/multiple-where-clause-in-linq

rajesh yadav · Answer

well, that means it does not follow left to right execution if two where clause is applied?

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

Answers (3)