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?

Solution 1

Yes, it is possible.

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

Solution 2

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

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

Comments

[Magnus]

Does this work in EF now? See: social.msdn.microsoft.com/forums/en-US/adodotnetentityframew‌​ork/…

[Haris Hasan]

That post is 3 years old. I believe it does now

[JSideris]

@HarisHasan Hey, could you comment on the performance of this type of query versus creating a stored procedure that does an inner join against a table valued parameter?