Show / Hide Table of Contents

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

    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.
    Back to top Generated by Appeon