Hi
In our application which is based on wcf data services and Entity Framework, we are using the dataservicedatasource in the mvvm pattern(with the QueryableDataServiceCollectionView object) togeher with the RadDataFilter.
the filter works great in all scenarios but when trying to retrieve data based on the "equal filter" of the property which is the primary key of the table we get this exception:
"Error translating Linq expression to URI: Cannot specify query options (orderby, where, take, skip) on single resource" (which is also the query on the loadingeventargs of the LoadingData event of the QueryableDataServiceCollectionView).
i.e. only when fetching a single data.
the Query.expression which is generated is:
Convert([10000].Where(item => (item.Company_No == 54)).Take(14)).IncludeTotalCount()
Thanks
In our application which is based on wcf data services and Entity Framework, we are using the dataservicedatasource in the mvvm pattern(with the QueryableDataServiceCollectionView object) togeher with the RadDataFilter.
the filter works great in all scenarios but when trying to retrieve data based on the "equal filter" of the property which is the primary key of the table we get this exception:
"Error translating Linq expression to URI: Cannot specify query options (orderby, where, take, skip) on single resource" (which is also the query on the loadingeventargs of the LoadingData event of the QueryableDataServiceCollectionView).
i.e. only when fetching a single data.
the Query.expression which is generated is:
Convert([10000].Where(item => (item.Company_No == 54)).Take(14)).IncludeTotalCount()
Thanks