How to implement SQL "in" in Entity framework 4.0

Question

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

RaYell · Accepted Answer · 2010-06-04 11:47:11Z

10

var users = from e in context.Users where idList.Contains(e.UserId)

answered Jun 4, 2010 at 11:47

RaYell

70.6k20 gold badges127 silver badges154 bronze badges

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

Comments

Matthew Abbott · Accepted Answer · 2010-06-04 11:48:10Z

9

Try this:

var identifiers = new[] { 1, 2, 3, 4 };
var users = from e in context.Users where identifiers.Contains(e.UserId);

answered Jun 4, 2010 at 11:48

Matthew Abbott

61.7k9 gold badges108 silver badges131 bronze badges