ExpressionBuilder.Expression(filters) in Kendo MVC grid not working for navigation collection

[Pavan]

We are using Kendo MVC Grid in our application. We are using LINQ to EF to query the tables.

Following is a query in our application:

query.Where(ExpressionBuilder.Expression<ParentTable>(command.Request.Filters))

This works fine as long as the filters are any columns from the "ParentTable". However, the ParentTable has a navigation collection ICollection<ChildTable> and the ChildTable has a property ChildProperty and the method ExpressionBuilder.Expression fails when we use this ChildProperty for filtering.

Any solution for this problem?

Thanks

[T. Tsonev]

Hi,

I'm copying my reply to your support ticket here for customer reference.

I'm afraid the Where extension does not support filtering by collection.
This is not a design goal of the data engine.

Regards,
T. Tsonev
Telerik