Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
204 views
in Technique[技术] by (71.8m points)

c# - 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

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
var users = from e in context.Users where idList.Contains(e.UserId)

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...