Show / Hide Table of Contents

    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 Constructor

    SnapObjects.Data.ISqlBuilder

    Syntax

    public interface ISqlOrderThenBuilder : ISqlBuilder;
    

    Methods

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