/// <summary> /// Return the specified result set page. Beware of the fact that page indexes are 1-based. /// </summary> /// <param name="page">The page number to fetch. Use a value of 1 to obtain the first page.</param> /// <returns>A new SqlResult instance with any matching rows</returns> public SqlResult Page( int page ) { Check.Verify( rowLimit > 0, Error.DeveloperError, "The paging methods are only available for statements with a row limit." ); SqlBuilder sb = new SqlBuilder( broker ); cmd.CommandText = sb.GetPagedSql( page, Sql, rowLimit, ref rowOffset ); return Execute(); }