Filtering entity by collection of IDs LINQ

Question

I need to filter entity with LINQ by collection of IDs. What I am trying to do better explains following sql query:

 select * from Person where PersonID in (1,2,3)

I have List collection which contain collection of IDs and need to retrieve all persons with same ID like in collection.

Thanks

score 2 · Accepted Answer · answered Sep 18 '14 at 19:27

2

myList.Where(item => ids.Contains(item)).ToList()

answered Sep 18 '14 at 19:27

Valentin P.

1 Answers1