[Solved]-need a simple linq-LINQ,C#

from p in Products
where new int [] { 2,6,9 }.Contains(p.ProductID)
select p;

leppie 112192

var q = from p in Products
        where p.productID==2 || p.productID==6 || p.productID==9
        select p;

foreach(var product in q)
{
  //...
}

db.Products.Where(p=> p.productID==2 || p.productID==6 || p.productID==9)

Mark Cidade 96234

Source: stackoverflow.com