Sql.Net Class Library Documentation

SqlOmRenderer.RenderPage Method

Renders a SELECT statement which a result-set page

public virtual string RenderPage(
   int pageIndex,
   int pageSize,
   int totalRowCount,
   SelectQuery query
);

Parameters

pageIndex: The zero based index of the page to be returned
pageSize: The size of a page
totalRowCount: Total number of rows the query would yeild if not paged
query: Query definition to apply paging on

Return Value

Generated SQL statement

Implements

ISqlOmRenderer.RenderPage

Remarks

To generate pagination SQL you must supply totalRowCount. To aquire the total number of rows use the RenderRowCount method.

See Also

SqlOmRenderer Class | Reeb.SqlOM.Render Namespace