Hi,

Currently we are using the adapter.FetchEntityCollection and adapter.FetchProjection with page number and page size for pagination. Is there (in the near future?) also support for the skip-and-take pagination using those methods?

Best, Dick

That's available in Linq and QuerySpec.

Walaa wrote:

That's available in Linq and QuerySpec.

Thanks for the response. We are not using both options thus far, no chance it will be available for the methods we currently use (and not have to rewrite all our queries)?

Dick

You can mix queryspec / linq queries with other queries, you don't have to rewrite all your queries. Normally paging is done per page anyway, so it's not something that's always needed. So when you need to skip x rows and then fetch y rows where x & y don't fit in a fixed page setup, you can write the query as queryspec and use the offset/limit combo (or skip/take in a linq query).

The low level API won't get any facilities for this.

Thanks, we will look into this and see what makes sense for us to do.

Dick