ISqlOrderBuilder Interface
.NET Standard 2.x
Represents an object which is used to build an ORDER BY clause in a 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 ISqlOrderBuilder : ISqlBuilder, ISqlBuilderBase, ICloneable<ISqlBuilder>;
Method
| Name | Return Type | Description |
|---|---|---|
| OrderByAscending(params string[] orderExpressions) | ISqlOrderThenBuilder | Creates an ORDER BY clause and specifies one or more sort criteria in ascending order. |
| OrderByDescending(params string[] orderExpressions) | ISqlOrderThenBuilder | Creates an ORDER BY clause and specifies one or more sort criteria in descending order. |
| OrderByRaw(string orderClause) | ISqlOrderThenBuilder | Creates an ORDER BY clause and specifies one or more sort criteria using a raw SQL. |
| OrderByRaw(string orderClause, string alias) | ISqlOrderThenBuilder | Creates an ORDER BY clause; and specifies one or more sort criteria using a raw SQL and specifies an alias for the raw SQL. |