SQL 'IN' operator in LINQ to Entities

Question

I'm having trouble with creating a LINQ query with IN parameters.
Corresponding SQL Query is

SELECT * FROM TABLEDEMO WHERE ID IN(SELECT ID FROM TABLE2)

How do I achieve the same using LINQ?
I can also take a list variable to store multiple IDs.

 (from x in objEntity.TABLEDEMO
 where x.TABLEDEMO (here should be the in parameter)
 select x);

Daniel Hilgarth · Accepted Answer · 2011-06-10 12:13:00Z

3

You need to use Contains:

from x in objEntity.TABLEDEMO
where objEntity.Table2.Contains(y => y.ID == x.ID)
select x;

You can't write this any other, i.e. there is no query style operator you can use.

answered Jun 10, 2011 at 12:13

Daniel Hilgarth

175k41 gold badges346 silver badges450 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Doga · Accepted Answer · 2011-06-10 12:13:53Z

3

from x in objEntity.Tabledemo
where (from y in objEntity.table2
       select ID).contains(x.ID)
select x

answered Jun 10, 2011 at 12:13

Doga

2812 silver badges11 bronze badges

Femaref · Accepted Answer · 2011-06-10 17:47:32Z

1

Use the Any operator:

from x in objEntity.TABLEDEMO
where otherQuery.Any(oq => oq == x.ID)
select x

answered Jun 10, 2011 at 12:12

Femaref

61.5k8 gold badges145 silver badges176 bronze badges