navigation property filtering

[Kai]

Hi,

is it possible to filter the loaded navigation properties? I want to to set some entities as deleted and exclude them if I query over the navigation property.


                var product = context.Products.Include(x=>x.OrderDetails.Where(od=>od.IsDeleted)).FirstOrDefault(x => x.ProductID == 1);
               foreach (var orderDetail in product.OrderDetails)
                    {
                        Console.WriteLine(orderDetail.OrderID);
                    }

I can not filter on the foreach loop. it must be filtered before.

[Jan Blessenohl]

Hello Kai,

We do not allow filtering of persistent collections, our change tracking algorithm would be broken in filtered scenarios.

The best way to achieve this is to have a persistent property AllOrderDetails and add a transient property

public IEnumerable<OrderDetails> { get{return AllOrderDetails.Where(x=>x.Deleted == false).ToList();}}



I know that this only works in certain scenarios. If it does not work for you, please describe your use case so that we can find a better solution.



Regards,

Jan Blessenohl
Telerik