linq to entity - include with lambda expression

Question

I have a lite problem i don't really know how to fix. In my example below i would like to select a list of ProductCategories with ProductItems that are active.

public IEnumerable<ProductCategory> ListProductCategories()
        {
            return _entities.ProductCategorySet.Include("ProductItems").Where(x => x.ProductItems.Active == true).ToList();               
        }

The problem is that i can't access productItem property Active in my lambda expression, what is the problem? Do I think totaly wrong when im trying to write a linq query like the one above?

Mark Byers · Accepted Answer · 2010-02-14 12:16:31Z

6

There could be more than one item. You probably want to select the categories where all items are active:

return _entities.ProductCategorySet
                .Include("ProductItems")
                .Where(x => x.ProductItems.All(item => item.Active))
                .ToList();

edited Feb 14, 2010 at 12:16

answered Feb 14, 2010 at 1:42

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

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

1 Comment

Webking Over a year ago

the solution didn't really solve the problem. Your solution only return productcategories with any productitems. It dosn't matter if they are active or not. What i want to return is all productcategories and productitems only where productitems is active == true.

Collectives™ on Stack Overflow

linq to entity - include with lambda expression

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related