Currently it's not possible to overrule number of pages to be shown in page navigation, if EntityDataSource is used. There is the problem that always all rows from data source get queried, when GridGroupByExpression has been defined for RadGrid - and this is really a problem, if data source has hundreds of thousands of records (as in our case). The performance is really bad.

To overcome this issue I would like to control myself, which data gets returned by adapting query in OnQueryCreated event of EntityDataSource, basically by "injecting" skip / take expression to entity query. I am responsible myself about sorting and grouping should be done on page level only (so there is no need to query always ALL data).

In same event I want to set VirtualItemCount, which should control number of pages to be shown in page navigation (in combination with AllowCustomPaging). But unfortunately this setting is not taken into account by RadGrid for displaying pages in page navigation.

Is it possible to overrule this behavior that VirtualitemCount is always taken into account when AllowCustomPaging has been enabled? I would like to control myself.

Thanks,
Roger