Server paging functionaly

[Krzysztof Szulc]

hello

I have question is openaccess suport server side paging - for example Postgers limit ?
At now I`m using linq Take Skip but this works on application side not server.

If not support is this palned in future ?


Best regards
Szulc Krzysztof

[Ralph Waldenmaier]

Hello Krzysztof,

The scenario you described is already supported with Telerik OpenAccess ORM.
Let me show you an example on a really simple model where I try to page over addresses.

using (EntitiesModel ctx = new EntitiesModel())
{
    var qry = (from some in ctx.Addressses select some).Skip(2).Take(2).ToList();
}

The resulting SQL query of this LINQ statement is as follows:

SELECT a."addresss_id" AS COL1, a."street" AS COL2, a."voa_version" AS COL3 FROM "addresss" AS a  LIMIT :TAKE OFFSET :SKIP  [:TAKE=2 :SKIP=2]

I hope this information is helpful for you. Feel free to ask if you have any other question.

All the best,
Ralph
the Telerik team