ISqlJoinOnBuilder.On Method

.NET Standard 2.x

Creates an ON clause and adds a search condition to it.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Overloads

Method	Description
On(string left, string right)	Creates an ON clause and adds a search condition to it. Specifies SQL expressions on both the left and right of the operator. The operator is '='.
On(string left, SqlBinaryOperator sqlOperator, string right)	Creates an ON clause and adds a search condition to it. Specifies SQL expressions on both the left and right of the operator.
On(string left, ISqlParameter parameter)	Creates an ON clause and adds a search condition to it. 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 ON clause and adds a search condition to it. Specifies a SQL expression on the left of the operator and a SQL parameter on the right of the operator.
On(string left, ISqlBuilder sqlBuilder)	Creates an ON clause and adds a search condition to it. Specifies the SQL expression on the left of the operator and the SQL subquery on the right. The operator is '='.
On(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder)	Creates an ON clause and adds a search condition to it. Specifies a SQL expression on the left of the operator and a SQL subquery on the right.
On(ISqlJoinCondition condition)	Creates an ON clause and adds a search condition to it using an ISqlJoinCondition object.