ISqlOrderBuilder Interface

.NET Standard 2.x | Current Version (1.0.1)

0.5.0-alpha 1.0.1 (current)

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.ISqlBuilder

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.