6

How to implement following query of SQL in entity framework. SELECT * FROM Users WHERE UserID in (1,2,3,4).

I am trying to do 

var users = from e in context.Users where e.UserId in (list of user ids)

Thanks Ashwani

Ashwani K
  • 7,692
  • 18
  • 60
  • 100
  • possible duplicate of [Linq to Entities - Sql "IN" clause](http://stackoverflow.com/questions/857973/linq-to-entities-sql-in-clause) –  Mar 24 '14 at 08:20

2 Answers2

10
var users = from e in context.Users where idList.Contains(e.UserId)
RaYell
  • 68,096
  • 20
  • 124
  • 150
9

Try this:

var identifiers = new[] { 1, 2, 3, 4 };
var users = from e in context.Users where identifiers.Contains(e.UserId);
Matthew Abbott
  • 59,075
  • 9
  • 102
  • 128