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,880
  • 19
  • 63
  • 102
  • 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
  • 69,610
  • 20
  • 126
  • 152
9

Try this:

var identifiers = new[] { 1, 2, 3, 4 };
var users = from e in context.Users where identifiers.Contains(e.UserId);
Matthew Abbott
  • 60,571
  • 9
  • 104
  • 129