Using "in" operator in where clause of entity framework

Question

i want all products to be available under current category including all child categories. my code is something like this :

int[] toCheck =new int[2];

toCheck[0] = 1;
toCheck[1] = 2;
toCheck[2] = 3;

var products = db.Products.Include(x => x.categoryByProductID).Where(x => x.CategoryID in ?);

here categoryByProductID = all child categories, ? = how can i use toCheck[] array

or any other solution to check CategoryID with predefined values !!!

any help appreciable ...

glenatron · Accepted Answer · 2012-06-08 13:23:16Z

1

You want to look at it slightly the other way up- does the list of categories contain the category of this product?

var products = db.Products.Include(x => x.categoryByProductID).Where(x => toCheck.Contains(x.CategoryID));

answered Jun 8, 2012 at 13:23

glenatron

11.4k14 gold badges68 silver badges122 bronze badges

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

1 Comment

Panagiotis Kanavos Over a year ago

Contains works in .NET 4.0 but not in 3.5 SP1 blogs.msdn.com/b/alexj/archive/2009/03/26/…

Massimiliano Peluso · Accepted Answer · 2012-06-08 13:26:37Z

1

var products = db.Products.Include(x => x.categoryByProductID).Where(x => toCheck.Any(y => y == x.CategoryID));

answered Jun 8, 2012 at 13:26

Massimiliano Peluso

26.8k6 gold badges65 silver badges75 bronze badges

Collectives™ on Stack Overflow

Using "in" operator in where clause of entity framework

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related