Single linq Statement

Neethu pradeep

7y976LINQ

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();
}
}
}
}

4 Replies

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

Hi,

please refer this link:

https://stackoverflow.com/questions/7548783/net-linq-query-returning-a-single-object

Hi Pradeep,

Please try below query

if (Filter != " ")
{
if (details.Count <= 0)
{
details = (from e in Country_Details where e.Country.ToLower().StartsWith(Filter.ToLower()
&& e.Capital.ToLower().StartsWith(Filter.ToLower()
&& e.Region.ToLower().StartsWith(Filter.ToLower()
&& e.S_region.ToLower().StartsWith(Filter.ToLower())
select e).ToList();
}

// Something like this?
details = (
from e in Country_Details where
e.Country.ToLower().StartsWith(Filter.ToLower()) && e.Capital.ToLower().StartsWith(Filter.ToLower()) &&
e.Region.ToLower().StartsWith(Filter.ToLower()) && e.S_region.ToLower().StartsWith(Filter.ToLower())
select e
).ToList();