SqlPaging
A dialect's rendering of LIMIT/OFFSET: a prefix placed after SELECT (such as
SQL Server's TOP n) and trailing clause lines. Implements [LQL-SUBQUERY-LAYOUT].
public sealed record SqlPaging : IEquatable<SqlPaging>
Constructors
SqlPaging
public SqlPaging(string SelectPrefix, ImmutableArray<string> TailLines)
A dialect's rendering of LIMIT/OFFSET: a prefix placed after SELECT (such as
SQL Server's TOP n) and trailing clause lines. Implements [LQL-SUBQUERY-LAYOUT].
| Parameter | Type | Description |
|---|---|---|
SelectPrefix |
String |
Text inserted after SELECT, or empty. |
TailLines |
String> |
Clause lines appended after ORDER BY. |
Properties
SelectPrefix
public string SelectPrefix { get; init; }
Text inserted after SELECT, or empty.
TailLines
public ImmutableArray<string> TailLines { get; init; }
Clause lines appended after ORDER BY.
Methods
LimitOffset(string?, string?)
public static SqlPaging LimitOffset(string? limit, string? offset)
LIMIT/OFFSET lines used by SQLite and PostgreSQL.
Parameters:
| Name | Type | Description |
|---|---|---|
limit |
String |
The row limit, if any. |
offset |
String |
The row offset, if any. |
Returns: SqlPaging - The paging rendering.