Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to implement SQL "in" in Entity framework 4.0

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

like image 667
Ashwani K Avatar asked Jun 04 '10 11:06

Ashwani K


1 Answers

var users = from e in context.Users where idList.Contains(e.UserId)
like image 150
RaYell Avatar answered Oct 19 '22 01:10

RaYell