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.