The 'in' predicate in the Entity Framework

Question

In T-SQL we have

where empid in (1, 3, 5)

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

Thank,

Answer 1

try the following:

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