The 'in' predicate in Entity Framework

Question

In T-SQL, we have

where empid in (1, 3, 5)

Now suppose I have a List<int>, how do I write a LINQ to Entities query, namely a predicate for Where() to get the equivalent of the above SQL query? Or this is not supported at all?

Thanks,

this might help you out http://stackoverflow.com/questions/959752/where-in-clause-in-linq — ashutosh raina, Oct 27 '11 at 10:04

score 4 · Answer 1 · answered Oct 27 '11 at 10:05

4

try this:

var Products = from product in dbctx.Products
            where itemQuery.Contains(product.ProductID)
            select product;

answered Oct 27 '11 at 10:05

wnascimento

1,929
1
19
16

Cool, 'Contains' will be translated and is what I want. Thanks. – Dodd Oct 27 '11 at 10:08

The 'in' predicate in Entity Framework

1 Answers1