Server paging functionaly

2 posts, 0 answers
  1. Krzysztof Szulc
    Krzysztof Szulc avatar
    5 posts
    Member since:
    Jan 2010

    Posted 23 Jan 2012 Link to this post


    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
  2. Ralph Waldenmaier
    Ralph Waldenmaier avatar
    202 posts

    Posted 24 Jan 2012 Link to this post

    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,
    the Telerik team

    SP1 for Q3’11 of Telerik OpenAccess ORM is available for download

Back to Top