SqlBuilder.On Method

.NET Standard 2.x

Creates an ISqlJoinCondition object which represents a search condition that can be used when building the ON clause. Specifies SQL expressions on both the left and right of the operator.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Overloads

Method	Description
On(string left, string right)	Creates an ISqlJoinCondition object which represents a search condition that can be used when building the ON clause. Specifies SQL expressions on both the left and right of the operator. The operator is '='.
On(string left, SqlBinaryOperator sqlOperator, string right)	Creates an ISqlJoinCondition object which represents a search condition that can be used when building the ON clause. Specifies SQL expressions on both the left and right of the operator.
On(string left, ISqlParameter parameter)	Creates an ISqlJoinCondition object which represents a search condition that can be used when building the ON clause. Specifies a SQL expression on the left of the operator and a SQL parameter on the right of the operator. The operator is '='.
On(string left, SqlBinaryOperator sqlOperator, ISqlParameter parameter)	Creates an ISqlJoinCondition object which represents a search condition that can be used when building the ON clause. Specifies SQL expressions on both the left and right of the operator.
On(string left, ISqlBuilder sqlBuilder)	Creates an ISqlJoinCondition object which represents a search condition that can be used when building the ON clause. Specifies a SQL expression on the left of the operator and a SQL subquery on the right. The operator is '='.
On(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder)	Creates an ISqlJoinCondition object which represents a search condition that can be used when building the ON clause. Specifies a SQL expression on the left of the operator and a SQL subquery on the right.