Thanks for the quick response. I had implemented your first suggestion "ondatacontextchanged" which solved some of my problems and then got stuck again with viewing large lists of data e.g. a Customer has 30000 assets for instance.

 

I still had no luck with the boolean filter but I will definately look into the EntityQueryPager as I think this will solve my issue. Especially as I need to page across both the server side and cached entities at the same time which I know the objectdatasource doesnt handle.

 

I will let you know how I get on...

 

Thanks for all your help

 

Mark

 

Regarding your concerns:

 

1 - You could set the query in code instead:

 

 

 

2 - Unfortunatelly this is not yet possible. I will add a feature request for it.

 

3 - I was able to filter on a boolean property without any problems: (tested with NorthwindIB.Products.Discontinued property)

 

 

Have you considered using a EntityQueryPager or EntityQueryPagedCollectionView instead? They are more robust and provide more functionality. You can find EntityQueryPager Samples and EntityQueryPagedCollectionView Samples in the DRC.

 

 

I really hope someone can help with this issue I am having. It seems to me that the objectdatasource is very limited.

 

I am trying what I think to be very simple, I have a customer details page, in the page is a datagrid of related contacts Customer.Customers_Contacts and I wanted to use the objectdatasource to view only the 'active' contacts for that customer.

 

Firstly I cannot assign my own query that is independant of the entitymanager ie Customer_Contacts.where(x => x.Inactive = false && x.CustomerID = customerid) I wanted to extend the customer entity and add a "FilteredContacts" query and bind this to the query parameter

 

 

Secondly failing step one I decided to try and use filterdescriptors on the objectdatasource to specify;