LINQ to Entities - Where IN clause in query [duplicate]

This question already has answers here: 开发者_如何学C Closed 12 years ago.

Possible Duplicates:

Linq to Entities - Sql “IN” clause

How to implement SQL “in” in Entity framework 4.0

how can I add WHERE IN statement like...

SELECT * FROM myTable WHERE ID IN (1,2,3,4,5)

in entity framework

---

Use Contains:

int[] ids = { 1, 2, 3, 4, 5};

var query = db.myTable.Where(item => ids.Contains(item.ID));

or in query syntax:

int[] ids = { 1, 2, 3, 4, 5};

var query = from item in db.myTable
            where ids.Contains(item.ID)
            select item;

---

I think answer lies somewhere along these lines...

Array a = {1,2,3,4,5}

...WHERE a.Contains(ID)