I wrote multiple linq statement ... and how it make as single linq statement.. and my code is given below
- if (Filter != " ")
- {
- details = (from e in Country_Details where e.Country.ToLower().StartsWith(Filter.ToLower()) select e).ToList();
- if (details.Count <= 0)
- {
- details = (from e in Country_Details where e.Capital.ToLower().StartsWith(Filter.ToLower()) select e).ToList();
- if (details.Count <= 0)
- {
- details = (from e in Country_Details where e.Region.ToLower().StartsWith(Filter.ToLower()) select e).ToList();
- if (details.Count <= 0)
- {
- details = (from e in Country_Details where e.S_region.ToLower().StartsWith(Filter.ToLower()) select e).ToList();
- }
- }
- }
- }