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
Syntax
public interface ISqlOrderBuilder : ISqlBuilder;
Methods
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. |