SqlPaging

Classes > Nimblesite.Lql.Core > 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.