Sometimes you may want to put "where" conditions in your LINQ query based on some criteria. You want to add dynamically filters in your query based on some conditions.
For ex. I have a table named tbl_Listings which has lots of columns like city, address, postal code, state, listing price, bathroom, bedroom, etc.
Now i want to query all the records if user has not specified any filter. I want to filter city column only if the user has specified city name in the search filter.