Support filtered Include in Projection (Filter the entity graph)

[JakobWl]

var products = _context.Project<Product, ProductDto>(_context.Products
          .Include(x => x.Customers.Where(x => x.CustomerId == parameters.CustomerId)));

I wonder if there is a way to do what i want to do. Because due to its nature Project will load the entire graph, but I only want the ones where my condition matches.

Even if it already exists and i dont see it this would be a very nice feature.

[leonardoporro]

Hello @JakobWl
Sorry for the long delay, I've been away from dev due to personal problems!
Project will just add a .Select() to the given IQueriable where the selection projection is built using library configuration.
So I guess your sample just works, do you have any issues running it?

[JakobWl]

@leonardoporro sadly as i mentined the code i attached with project will always load all navigation properties and not eager load only what i include by condition.

I will try again and come back due to not beeing home right now.

[leonardoporro]

mm.. I understand... the x.Customers.ToList(c => ...) created by the projection overrides the one that you defined in the include
it doesn't seem to be easy as I would have to walk the expression tree looking for filters and add them to the projection expression (and put that in a kind of cache to avoid assassinating the CPU)
will keep you posted in this thread