ISqlOrderThenBuilder Interface
.NET Standard 2.x
Represents an object that is used to add sorting criteria to the ORDER BY clause of the SQL statement.
The ORDER BY clause sorts the data returned by the query.
Namespace: SnapObjects.Data
Assembly: SnapObjects.Data.dll
Inherited Constructors
SnapObjects.Data.ISqlBuilderBase
System.ICloneable<ISqlBuilder>
Syntax
public interface ISqlOrderThenBuilder : ISqlBuilder, ISqlBuilderBase, ICloneable<ISqlBuilder>;
Method
| Name | Return Type | Description |
|---|---|---|
| ThenByAscending(params string[] orderExpressions) | ISqlOrderThenBuilder | Adds one or more sort criteria (in ascending order) to the ORDER BY clause. |
| ThenByDescending(params string[] orderExpressions) | ISqlOrderThenBuilder | Adds one or more sort criteria (in descending order) to the ORDER BY clause. |
| ThenByRaw(string orderClause) | ISqlOrderThenBuilder | Adds one or more sort criteria specified by raw SQL to the ORDER BY clause. |
| ThenByRaw(string orderClause, string alias) | ISqlOrderThenBuilder | Adds one or more sort criteria specified by raw SQL to the ORDER BY clause, and specifies an alias for the raw SQL. |