Lambda expression "IN" operator Exists?

c# c#-4.0 lambda entity-framework-5

sivaL · Nov 22, 2012 · Viewed 31.8k times · Source

I'm looking for to build the Lambda expression like the below

IQueryable<Object> queryEntity = 
                _db.Projects.Where(Project=>Project.Id.IN(1,2,3,4));

I don't find any IN operator in Lambda expression.

Anybody have suggestions?

Answer

var idList = new[] { 1, 2, 3, 4 };
IQueryable<Object> queryEntity = 
                _db.Projects.Where(Project => idList.Contains(Project.Id));

You could construct the idList inline of course.