ORDER BY Clause

Query results can be ordered using OrderBy().

var selectStatement = Select
    .All("ID", "Name", "LastModified")
    .From("Customer")
    .OrderBy("LastModified");

SELECT  [ID], [Name], [LastModified]
FROM [Customer]
ORDER BY [LastModified];

Sort direction

Sort direction can be specified on any ordering expression with Asc(), Desc(), Ascending(), or Descending(). Asc() and Desc() are aliases of Ascending() and Descending(). Use whichever you prefer.

var selectStatement = Select
    .All("ID", "Name", "LastModified")
    .From("Customer")
    .OrderBy("LastModified".Descending());

SELECT  [ID], [Name], [LastModified]
FROM [Customer]
ORDER BY [LastModified] DESC;

OFFSET and FETCH

OFFSET and FETCH are not yet supported.