Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Add Support for SQL Server 2012 Query Paging

Description

I dont' know if this is the way to report this requirement:
I read that SQL Server 2012 will support paging in this way:

SELECT BusinessEntityID, FirstName, LastName
FROM Person.Person
ORDER BY BusinessEntityID
OFFSET 10 ROWS
FETCH NEXT 10 ROWS ONLY;

Is it possible to take adventage of this new sintax in order to get result paged?

Thank you in advance and sorry if this is not the media to report this request.

Environment

None

Activity

Show:

Alex Zaytsev 
September 30, 2012 at 8:20 PM

Fix commited to master 171ae483a3a0052806da42655991a34b4b56b8da

CSharper2010 
February 16, 2012 at 9:03 PM

I've created a pull request for this: https://github.com/nhibernate/nhibernate-core/pull/78

Oskar Berggren 
January 27, 2012 at 9:31 PM

You are absolutely in the correct place.

Just to note it down, there has been some discussion in the mailing list also:
https://groups.google.com/d/topic/nhibernate-development/L5_BE95I5Wk/discussion

Fixed

Details

Assignee

Reporter

Labels

Components

Fix versions

Affects versions

Priority

Parent

Who's Looking?

Open Who's Looking?
Created January 27, 2012 at 7:33 PM
Updated September 21, 2014 at 12:42 PM
Resolved September 30, 2012 at 8:20 PM
Who's Looking?