Dynamic SQL Query Entity Framework

Question

I searched though many posts on stack overflow to get me an answer but I am not clear yet. I am just looking for some simple way to build dynamic queries. I was able to do simple queries involving single expression in where clause but I am not able to find any easy way to handle multiple expressions. I have experience of working with NHibernate criteria API which is very handy for rapid and compile time safe query constructions. I though something similar will be available on EntityFramework but so far no luck. Is there any easy way beside manually building string queries? Have a look at following code I thought it should work but it doesn't. Actually it doesn't builds query upon multiple lambda expressions. I was expecting that each where call will add one AND expression to where clause. Am I missing something ?

var query = Entities.Current.Jobs.AsQueryable<Job>();

            if (!string.IsNullOrEmpty(keywords))
            {
                query.Where(j => j.Title.Contains(keywords) || j.Description.Contains(keywords));
            }

            if (industryId > 0)
            {
                query.Where(j => j.IndustryId == industryId);
            }

            if (countyId > 0)
            {
                query.Where(j => j.CountyId == countyId);
            }

            return query.ToList<Job>();

SLaks · Accepted Answer · 2011-10-16 16:52:48Z

6

IQueryable is immutable; you cannot (directly) modify the query of an existing IQueryable. query.Where returns a new IQueryable with an additional where clause.

You aren't doing anything with these new IQueryables.

You need to write

query = query.Where(...)

answered Oct 16, 2011 at 16:52

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

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

Collectives™ on Stack Overflow

Dynamic SQL Query Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related