Keyset Pagination

[Grauenwolf]

.WithPaging(int pageSize, object? skipPast, params SortExpression[] sortExpressions)

• pageSize: maximum number of rows to return
• skipPast: Last item in the previous page. If null, start over from the beginning.
• sortExpressions: List of columns to be used for sorting. Required.

ref:

• https://grauenwolf.github.io/DotNet-ORM-Cookbook/Pagination.htm
• https://use-the-index-luke.com/no-offset

[Grauenwolf]

Auto-append the primary column to the list of sort expressions. This ensures that there is always at least one unique key.

[Grauenwolf]

If a unique column appears anywhere other than the last slot in the sorting expressions, then everything beyond that point could be ignored.

We aren't actually going to check for this. Is someone wants to use ORDER BY UniqueColumn, AnotherColumn then we'll let them. The database can figure it out.