Show / Hide Table of Contents

    ISqlJoinOnAndOr<TBuilder> Interface

    .NET Standard 2.x

    Represents an object, which uses the AND or OR logical operator and adds a search condition in the ON clause of a SQL statement. The return values of all methods are always the current TBuilder object.

    Namespace: SnapObjects.Data

    Assembly: SnapObjects.Data.dll

    Syntax

      public interface ISqlJoinOnAndOr<TBuilder>;
    

    Property

    Name Return Type Description
    HasOn bool Gets whether any search condition has been added to the ON clause of the current object using the On or OnRaw method and so on.

    Methods

    Name Return Type Description
    AndOn(string left, string right) TBuilder Adds the AND logical operator and a search condition to the ON clause; and specifies SQL expressions on both the left and right of the operator. The operator is '='.
    AndOn(string left, SqlBinaryOperator sqlOperator, string right) TBuilder Adds the AND logical operator and a search condition to the ON clause; and specifies SQL expressions on both the left and right of the operator.
    AndOn(string left, ISqlParameter parameter) TBuilder Adds the AND logical operator and a search condition to the ON clause; and specifies a SQL expression on the left of the operator and a SQL parameter on the right of the operator. The operator is '='.
    AndOn(string left, SqlBinaryOperator sqlOperator, ISqlParameter parameter) TBuilder Adds the AND logical operator and a search condition to the ON clause; and specifies a SQL expression on the left of the operator and a SQL parameter on the right of the operator.
    AndOn(string left, ISqlBuilder sqlBuilder) TBuilder Adds the AND logical operator and a search condition to the ON clause; and specifies a SQL expression on the left of the operator and a SQL subquery on the right. The operator is '='.
    AndOn(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder) TBuilder Adds the AND logical operator and a search condition to the ON clause; and specifies a SQL expression on the left of the operator and a SQL subquery on the right.
    AndOn(ISqlJoinCondition condition) TBuilder Adds the AND logical operator and a search condition (specified by an ISqlJoinCondition object) to the ON clause.
    AndOnRaw(string clause, params ISqlParameter[] parameters) TBuilder Adds the AND logical operator and a raw SQL to the ON clause.
    AndOnValue(string left, object value) TBuilder Adds the AND logical operator and a search condition to the ON clause; and specifies a SQL expression on the left the operator and a specific value on the right of the operator. The operator is '='.
    AndOnValue(string left, SqlBinaryOperator sqlOperator, object value) TBuilder Adds the AND logical operator and a search condition to the ON clause; and specifies a SQL expression on the left the operator and a specific value on the right of the operator.
    OrOn(string left, string right) TBuilder Adds the OR logical operator and a search condition to the ON clause; and specifies SQL expressions on both the left and right of the operator. The operator is '='.
    OrOn(string left, SqlBinaryOperator sqlOperator, string right) TBuilder Adds the OR logical operator and a search condition to the ON clause; and specifies SQL expressions on both the left and right of the operator.
    OrOn(string left, ISqlParameter parameter) TBuilder Adds the OR logical operator and a search condition to the ON clause; and specifies a SQL expression on the left of the operator and a SQL parameter on the right of the operator. The operator is '='.
    OrOn(string left, SqlBinaryOperator sqlOperator, ISqlParameter parameter) TBuilder Adds the OR logical operator and a search condition to the ON clause; and specifies a SQL expression on the left of the operator and a SQL parameter on the right of the operator.
    OrOn(string left, ISqlBuilder sqlBuilder) TBuilder Adds the OR logical operator and a search condition to the ON clause; and specifies a SQL expression on the left of the operator and a SQL subquery on the right. The operator is '='.
    OrOn(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder) TBuilder Adds the OR logical operator and a search condition to the ON clause; and specifies a SQL expression on the left of the operator and a SQL subquery on the right.
    OrOn(ISqlJoinCondition condition) TBuilder Adds the OR logical operator and a search condition (specified by an ISqlJoinCondition object) to the ON clause.
    OrOnRaw(string clause, params ISqlParameter[] parameters) TBuilder Adds the OR logical operator and a raw SQL to the ON clause.
    OrOnValue(string left, object value) TBuilder Adds the OR logical operator and a search condition to the ON clause; and specifies a SQL expression on the left of the operator and a specific value on the right of the operator. The operator is '='.
    OrOnValue(string left, SqlBinaryOperator sqlOperator, object value) TBuilder Adds the OR logical operator and a search condition to the ON clause; and specifies a SQL expression on the left of the operator and a specific value on the right of the operator.

    Remarks

    AND logical operator: Combines two conditions and evaluates to TRUE when both of the conditions are TRUE.

    OR logical operator: Combines two conditions and evaluates to TRUE when either condition is TRUE.

    Back to top Generated by Appeon