Loading

if statement in LINQ?

if statement in LINQ?

osyris zosar

5y1.2kLearn iOS Programming

i have a couple of list but sometimes they are empty

var matching = from name in indexnames
from surname in indexsurname
from age in agesurname
from height in indexheight
where name.Equals(surname) &&
name.Equals(age) && name.Equals(height)
orderby name
select name;

How can i make sure it only does name.Equals(value) if it actualy contains anything ?

1 Reply

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

Ronika Jency5y ago
Hi,

What you want to avoid is actually executing the query until you are ready:
var matching = from name in indexnames
                           from surname in indexsurname
                           from age in agesurname
                           from height in indexheight
                           orderby name
                           select name;

if(!string.isnullorEmpty(surname))
{
matching = matching.where(x=>x.name.Equals(surname));
}
if(!string.isnullorEmpty(age))
{
matching = matching.where(x=>x.name.Equals(age));
}
if(!string.isnullorEmpty(height))
{
matching = matching.where(x=>x.name.Equals(height));
}
once all condition set, you can execute finally using toList().

var matchingList = matching.toList();