ISqlJoinOnAndOr<TBuilder>.AndOn Method
.NET Standard 2.x
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.
Namespace: SnapObjects.Data
Assembly: SnapObjects.Data.dll
Overloads
| Method | Description |
|---|---|
| AndOn(string left, string right) | 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) | 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) | 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) | 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) | 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) | 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) | Adds the AND logical operator and a search condition (specified by an ISqlJoinCondition object) to the ON clause. |