How to use (sql =any) .Any() of linq to entities lambda expressions?

Question

i want something like

var o = db.Persons.Where(x=>x.Id in (1, 2));

or

var o = db.Persons.Where(x=>x.Id =any (1, 2));

to get a list of Persons that the id is in (1, 2).

score 2 · Accepted Answer · answered May 29 '16 at 09:59

2

var o = db.Persons.Where(x=> new[]{1, 2}.Contains(x.Id));

answered May 29 '16 at 09:59

layonez

score 1 · Answer 2 · answered May 29 '16 at 10:02

1

var keys = new List<int>{1,2,3}; //This contains the collection of your Id
var o = db.Persons.Where(x=>keys.Contains(x.Id));

answered May 29 '16 at 10:02

Eldho