Filtering on a .Include().IncludeNext() field

[Craig]

Hi - I'm trying to filter a grid that is bound to child tables using .Include() and .IncludeNext() and having no luck. I keep getting the error below - any help would be appreciated, I tried just about everything including gathering up all the SerialNumbers at a higher level but that was flakey code and causing a performance degradation.

Message"Invalid property or field - 'SerialNumber' for type: Invoice"string

Here's my data load statement:

invoices = from inv in _context.Invoices.Include(i => i.ShippingAddress).Include(i => i.InvoiceLines).ThenInclude(s => s.SerialNumbers)    
                       where orgIds.Contains(inv.OwnedBy_Id) select inv;

And my filters:

$("#Grid").data("kendoGrid").dataSource.filter({
            logic: "or",
            filters: [
                {
                    field: "SerialNumber",
                    operator: "contains",
                    value: searchValue
                },

Thanks!
Craig

[Konstantin Dikov]

Hello Craig,

You need to ensure that you are passing a collection with type containing all of the properties that are bound to the Grid, before calling the ToDataSourceResult method over it. With that in mind, you could try to call the ToList method before calling the ToDataSourceResult, but once again, ensure that you map all properties bound to the grid.

You might also want to take a look at the following forum thread for a discussion about ThenInclude in ASP.NET Core:

• https://stackoverflow.com/questions/30072360/include-several-references-on-the-second-level

Regards,
Konstantin Dikov
Progress Telerik