in queries from sql to linq

try this:

List Ids = new List;
Ids.Add(1);
Ids.Add(2);
Ids.Add(3);

var t = from n in productList
where Ids.Contains(n.Id)
select n;

this is like:

select * from productList where Id in (1, 2, 3)