How to dynamically generate conditions in Entity Framewrok?

Question

Entity Framework

How can I dynamically generate query conditions?

Answer 1

Yes, just throw them to IQueryable:

IQueryable<Person> query = context.Persons;

if (searchByFirstName)
    query = query.Where(x => x.FirstName == someFirstName);

if (searchByAge)
    query = query.Where(x => x.Age == someAge);

var persons = query.ToList();

When generating an SQL query, all these separate conditions will be collected into one beautiful WHERE.
Another option is to build Linq Expressions. The method is more flexible, but more complex. For example, you can read it here: https://msdn.microsoft.com/en-us/library/mt654267.aspx.