Home / Community & Support / Developer Productivity Tools Forums / OpenAccess ORM > General Discussions > Server paging functionaly

• Krzysztof Szulc

  Posted on Jan 23, 2012 (permalink)

  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

  Reply

• Ralph Ralph

  Posted on Jan 24, 2012 (permalink)

  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

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

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / OpenAccess ORM > General Discussions > Server paging functionaly