Fluent Api Include Where Clause

Question

I need to get products with cover picture. But when i add pic => pic.IsCover it's throw exception.Otherwise there is no problem. How can i fixed it?

Error:

The Include path expression must refer to a navigation property defined on the type. Use dotted paths for reference navigation properties and the Select operator for collection navigation properties. Parametre adı: path

Thanks to all

_db.ProdSmartSorts
    .Where(x => catIds.Contains((int)x.Product.CategoryId))
    .OrderBy(x => x.ProdSmartId)
    .Select(x => x.Product)
    .Include(p => p.Pictures.Where(pic => pic.IsCover))
    .Skip(prodCount * (pageNumber - 1))
    .Take(prodCount)
    .ToList();

Try to use SelectMany instead of Select – Shachaf.Gortler Nov 16 '16 at 18:14 — Shachaf.Gortler, Nov 16 '16 at 18:14

score 2 · Answer 1 · answered Nov 16 '16 at 18:37

2

Entity Framework does not support filtering with the Include method. You can vote for it here, though: https://entityframework.codeplex.com/workitem/47

answered Nov 16 '16 at 18:37

Jason Boyd

6,839
4
29
47

score 0 · Answer 2 · answered Nov 16 '16 at 18:58

Does placing the .Include() method call directly after the DbSet work? i.e.

_db.ProdSmartSorts
 .Include(p => p.Pictures)
 .Where(x => catIds.Contains((int)x.Product.CategoryId))
 .OrderBy(x => x.ProdSmartId)
 .Select(x => x.Product)
 .Skip(prodCount * (pageNumber - 1))
 .Take(prodCount)
 .ToList();

I think the Include method is only available on the DbSet objects within the dbContext. If you try and put it further down the chain you only have methods that are available to IQueryable or IEnumerable objects dependant on the circumstances.

Also, to my knowledge you can't use the Include function to filter, as you attempted. So you will have to load all images related Picture entities.

EDIT: Sorry - just realised that this question is specifically asking for filtering on the Include() method. Please disregard.

Fluent Api Include Where Clause

2 Answers2