Linq query for dynamically value

Question

I have an IQueryable collection of Employee objects which has FirstName, LastName, Department in it. I'm passing a string of LastName separated by comma. I want to use where clause to filter data which has LastName selected as "Sharma,Gupta". Can someone help me out?

Employee class

public class Employee
{
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public string Department { get; set; }
    public string EmpID { get; set; }
}

public IQueryable<Employee> GetEmpData(String filterExpression)
{
    IQueryable<Employee> data = GetEmployeeData();
    data = from da in data
           where (da.LastName == "Sharma")
           select da;
    return data;

}

In the above method I can query a single value. filterExpression contains list of LastName separated by a comma. Can someone guide me how to use filterExpression in where clause?

Gilad Green · Accepted Answer · 2017-02-08 21:03:37Z

2

Split your string and use .Contains:

names = filterExpression.Split(",");
IQueryable<Employee> data = GetEmployeeData();
data = from da in data
       where names.Contains(da.LastName)
       select da;

As you return the entire object and do not project only parts of it using the method syntax might be more readable:

return GetEmployeeData().Where(item => names.Contains(item.LastName));

edited Feb 8, 2017 at 21:03

answered Feb 8, 2017 at 20:51

Gilad Green

37.3k7 gold badges67 silver badges99 bronze badges

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

1 Comment

Gilad Green Over a year ago

@Nilesh - you are welcome :) please consider marking question as solved and upvoting :)

Darendal · Accepted Answer · 2017-02-08 20:53:51Z

0

If your filterExpression is a string, with the names separated by commas, then you'd want to change your query to check if the last name is in the list of names in filterExpression like this:

public IQueryable<Employee> GetEmpData(String filterExpression)
{
    List<string> names = filterExpression.Split(",");
    return GetEmployeeData().Where(names.Contains(da.LastName));
}

answered Feb 8, 2017 at 20:53

Darendal

8831 gold badge9 silver badges30 bronze badges

1 Comment

Gilad Green Over a year ago

Have you checked that it compiles?

Collectives™ on Stack Overflow

Linq query for dynamically value

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related