Implement SQL Server 2012 Paging with OFFSET and FETCH
Add and option to use "SQL Server 2012" features/dialect and use OFFSET and FETCH for paging.
The new SQL Server 2012 paging feature will offer better performance and generated sql will be easier to understand.
Add new `SqlServer2012Dialect.Provider` with support for 2012’s new OFFSET/ROWS paging support in this commit: https://github.com/ServiceStack/ServiceStack.OrmLite/commit/f27901b4d5e1fdef4a3eadaeff8cc78cd34ba54e
This change is available from v4.0.43+ that’s now available on MyGet: https://github.com/ServiceStack/ServiceStack/wiki/MyGet
-
Marco commented
Any progress on this feature request? When creating version specific dialect next step is support for hierarchyid column and/or spatial data.
-
Johann Klemmack commented
This is very DB-centric, and for a specific version. At first glance, it looks like your best bet may be to inherit SqlServerOrmLiteDialectProvider and re-implement the ToSelectStatement method.