Struct Paging
Limit/offset pair describing a single page request.
public struct Paging
- Inherited Members
- Extension Methods
Remarks
Was a struct with public mutable fields; the fields are now validated properties so the
invariants (non-negative limit/offset) hold. See docs/specs/design/API-NAMING-REVIEW.md
findings P1-17 and P2-19.
Properties
HasWithTies
When true, the page request keeps every row tied with the last row by the ORDER BY
(FETCH ... WITH TIES / TOP(n) WITH TIES). Requires a dialect that supports it (see
SupportsWithTies) and a non-zero Limit.
public bool HasWithTies { readonly get; set; }
Property Value
IsEmpty
true when neither a limit nor an offset is set, so no paging clause is emitted.
public readonly bool IsEmpty { get; }
Property Value
IsTop
true when only a positive limit is set (offset is zero), so the provider can emit a simple
TOP/LIMIT without an OFFSET.
public readonly bool IsTop { get; }
Property Value
Limit
Maximum number of rows to return; zero means "no limit".
public int Limit { readonly get; set; }
Property Value
Offset
Number of leading rows to skip; zero means "from the start".
public int Offset { readonly get; set; }