Define WHERE "value" IN(1,2,3) in ASP.NET Entity framework

Question

I have this part of code:

ViewBag.myFeedbacks = db.feedbacks.Where(f => f.project_id ?)

what should I replace char ? , when I want define something like this :

project_id IN (1,2,3)

so, select all feedback, which have project_id from list of values?

score 3 · Answer 1 · answered Nov 03 '15 at 18:53

3

ViewBag.myFeedbacks = db.feedbacks.Where(f => new[]{1,2,3}.Contains(f.project_id));

IQueryable.Contains is specialized to emit ... in ... SQL code.

answered Nov 03 '15 at 18:53

Blindy

score 2 · Accepted Answer · answered Nov 03 '15 at 18:51

2

var projectIds = new[]{1, 2, 3};

ViewBag.myFeedbacks = db.feedbacks.Where(f => projectIds.Any(p => p == f.project_id))

answered Nov 03 '15 at 18:51

vidalsasoon

score 1 · Answer 3 · answered Nov 03 '15 at 18:50

1

Something like this:

db.feedbacks.Where(f => yourArray.Contains(f.project_id))

answered Nov 03 '15 at 18:50

xZ6a33YaYEfmv

http://stackoverflow.com/questions/7897630/why-does-the-contains-operator-degrade-entity-frameworks-performance-so-drama – vidalsasoon Nov 03 '15 at 18:55
please specify your question or comment to my answer. if it's connected to bad performance of `Contains` expression I must assure you that since EF6 this was successfully fixed and works relatively fast now. – xZ6a33YaYEfmv Nov 03 '15 at 18:58
just in case he wasn't using EF6+ which is quite possible. – vidalsasoon Nov 03 '15 at 20:05

3 Answers3