Show / Hide Table of Contents

    ISqlWhereAndOr<TBuilder> Interface

    .NET Standard 2.x

    Represents an object which uses the AND or OR logical operator and adds a search condition in the WHERE 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 ISqlWhereAndOr<TBuilder>;
    

    Methods

    Name Return Type Description
    AndWhere(string left, ISqlParameter parameter) TBuilder Adds the AND logical operator and a search condition to the WHERE 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 '='.
    AndWhere(string left, SqlBinaryOperator sqlOperator, ISqlParameter parameter) TBuilder Adds the AND logical operator and a search condition to the WHERE clause; and specifies a SQL expression to the left of the operator and a SQL parameter to the right of the operator.
    AndWhere(string left, string right) TBuilder Adds the AND logical operator and a search condition to the WHERE clause; and specifies SQL expressions on both the left and right of the operator. The operator is '='.
    AndWhere(string left, SqlBinaryOperator sqlOperator, string right) TBuilder Adds the AND logical operator and a search condition to the WHERE clause; and specifies SQL expressions on both the left and right of the operator.
    AndWhere(string left, ISqlBuilder sqlBuilder) TBuilder Adds the AND logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left of the operator and a SQL subquery on the right. The operator is '='.
    AndWhere(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder) TBuilder Adds the AND logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left of the operator and a SQL subquery on the right.
    AndWhere(ISqlWhereCondition condition) TBuilder Adds the AND logical operator and a search condition (specified by an ISqlWhereCondition object) to the WHERE clause.
    AndWhereExists(ISqlBuilder sqlBuilder) TBuilder Adds the AND logic operator and a search condition to the WHERE clause; and uses EXISTS to test for the existence of the record returned from a subquery.
    AndWhereIsNotNull(string left) TBuilder Adds the AND logical operator and a search condition to the WHERE clause; and uses IS NOT NULL operator to search for values that are not null.
    AndWhereIsNull(string left) TBuilder Adds the AND logical operator and a search condition to the WHERE clause; and uses IS NULL operator to search for values that are null.
    AndWhereNotExists(ISqlBuilder sqlBuilder) TBuilder Adds the AND logical operator and a search condition to the WHERE clause; and uses the NOT EXISTS operator to test if the record returned from a subquery does not exist.
    AndWhereRaw(string clause, params ISqlParameter[] parameters) TBuilder Adds the AND logical operator and a raw SQL to the WHERE clause.
    AndWhereValue(string left, object value) TBuilder Adds the AND logical operator and a search condition to the WHERE 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 '='.
    AndWhereValue(string left, SqlBinaryOperator sqlOperator, object value) TBuilder Adds the AND logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left of the operator and a specific value on the right of the operator.
    OrWhere(string left, ISqlParameter parameter) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and specifies a SQL expression to the left of the operator and a SQL parameter to the right of the operator. The operator is '='.
    OrWhere(string left, SqlBinaryOperator sqlOperator, ISqlParameter parameter) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left of the operator and a SQL parameter on the right of the operator.
    OrWhere(string left, string right) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and specifies SQL expressions on both the left and right of the operator. The operator is '='.
    OrWhere(string left, SqlBinaryOperator sqlOperator, string right) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and specifies SQL expressions on both the left and right of the operator.
    OrWhere(string left, ISqlBuilder sqlBuilder) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left of the operator and a SQL subquery on the right. The operator is '='.
    OrWhere(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left of the operator and a SQL subquery on the right.
    OrWhere(ISqlWhereCondition condition) TBuilder Adds the OR logical operator and a search condition (specified by an ISqlWhereCondition object) to the WHERE clause.
    OrWhereExists(ISqlBuilder sqlBuilder) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and uses EXISTS to test for the existence of the record returned from a subquery.
    OrWhereIsNotNull(string left) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and uses the IS NOT NULL operator to search for values that are not null.
    OrWhereIsNull(string left) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and uses IS NULL operator to search for values that are null.
    OrWhereNotExists(ISqlBuilder sqlBuilder) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and uses the NOT EXISTS operator to test if the record returned from a subquery does not exist.
    OrWhereRaw(string clause, params ISqlParameter[] parameters) TBuilder Adds the OR logical operator and a raw SQL to the WHERE clause.
    OrWhereValue(string left, object value) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left the operator and a specific value on the right of the operator. The operator is '='.
    OrWhereValue(string left, SqlBinaryOperator sqlOperator, object value) TBuilder Adds the OR logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left 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