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.