Lambda Expression if-else statement in where clauses

Question

I want to change where clauses with paremeter.Example i have 2 string variable.

string searchText="John";
string userField="Name"//it can be ID,UserName or Email

I want to change Users property(a.Name) based on "string userField="Name"/"

var a entities.Users
     where a.Name==searchText    //a.Name(Name) is declared in userField. It can be ID,UserName or Email

My code is shown below:

var users = new
               {
                   total = 10,
                   page = page,
                   record = (entities.Users.Count()),
                   rows = (from user in entities.Users
                           select new
                           {
                               ID = user.ID,
                               Name = user.Name,
                               UserName = user.UserName,
                               UserType = user.Role.Name,
                               Email = user.Email,
                               CreatedDate = user.CreatedDate,
                               UpdatedDate = user.UpdatedDate
                           }).AsEnumerable().Select(m => new { ID = m.ID, Name = m.Name, UserName  = m.UserName, Email = m.Email, UserType = m.UserType, CreatedDate = String.Format("{0:d/M/yyyy  HH:mm:ss}", m.CreatedDate), UpdatedDate = String.Format("{0:d/M/yyyy HH:mm:ss}", m.UpdatedDate) }),
               };

How can i do that with this lambada expression?

So the challenge here is really that you have a string containing "Name", and you want that to link up to the property with the same name on the object being queryed? — Tormod
– Tormod, Commented Jul 28, 2013 at 12:17
Not clear what you're asking. do you want to filter your query by condition? — Sriram Sakthivel
– Sriram Sakthivel, Commented Jul 28, 2013 at 12:17
Thanks for answer. I want to change Users property based on "string userField="Name"/". Question updated. — ftdeveloper
– ftdeveloper, Commented Jul 28, 2013 at 12:19

Giannis Paraskevopoulos · Accepted Answer · 2013-07-28 12:43:09Z

3

You may try the following:

.Where(u => (userField == "ID" && u.Id == searchText)
       || (userField == "Name" && u.Name == searchText)
       || (userField == "Email" && u.Email == searchText)
       )

answered Jul 28, 2013 at 12:43

Giannis Paraskevopoulos

18.5k2 gold badges52 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Slauma · Accepted Answer · 2013-07-28 12:29:04Z

2

I would prefer extension method syntax in this situation and do it like so:

IQueryable<User> query = entities.Users;
switch (userField)
{
    case "ID":
        int searchID;
        if (int.TryParse(searchText, out searchID))
            query = query.Where(u => u.ID == searchID);
        else
            query = query.Where(u => false);
        break;

    case "Name":
        query = query.Where(u => u.Name == searchText);
        break;

    case "Email":
        query = query.Where(u => u.Email == searchText);
        break;
}

var users = new
{
    total = 10,
    page = page,
    record = (entities.Users.Count()),
    rows = (from user in query
            select new
            // etc.
           )
};

answered Jul 28, 2013 at 12:29

Slauma

177k60 gold badges407 silver badges424 bronze badges

Comments

Ehsan · Accepted Answer · 2013-07-28 12:32:37Z

1

as you want to create your where clauses dynamically i would recommend you to use Dynamic LINQ. It allows you to create where clauses dynamically.

answered Jul 28, 2013 at 12:32

Ehsan

32.8k6 gold badges61 silver badges66 bronze badges

Comments

rene · Accepted Answer · 2013-07-28 12:56:00Z

1

Dynamic solution

string searchText="John";
string userField= "Name";

/* I leave it as an exercixe to add the TypeConversion if Id is Int */
ParameterExpression pe = Expression.Parameter(typeof(User),"usr");
Expression left = Expression.Property(pe, typeof(User).GetProperty(userField));
Expression right = Expression.Constant(searchText);
Expression equ = Expression.Equal(left, right);

var whereExpr = Expression.Lambda<Func<User, bool>>(
      equ, 
      new ParameterExpression[] { pe });

var a =  entities.Users.Where(whereExpr);

answered Jul 28, 2013 at 12:56

rene

42.6k78 gold badges122 silver badges166 bronze badges

1 Comment

ftdeveloper Over a year ago

Thank you all. All your answers is worked. I prefered jyparask answer. It is easy.

Collectives™ on Stack Overflow

Lambda Expression if-else statement in where clauses

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related