LINQ to check if ID exists in List

Question

I am using LINQ Entity framework. I have a SQL table and I want to get all the items in the table that have an ID that exist in a List

Is this possible with LINQ?

Answer 1

Yes, it is possible.

(from item in yourContext.YourTable where yourList.Contains(item.ID) select item).ToList();

Answer 2

You can do this with Contains its translated into sql IN:

context.SomeTable.Where(r => someListOfId.Contains(r.ID));