ISqlJoinOnBuilder Interface

.NET Standard 2.x

Represents an object which can be used to create the condition on which the join is based in the JOIN clause.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Inherited Constructor

SnapObjects.Data.ISqlJoinOnAndOr

Syntax

public interface ISqlJoinOnBuilder : ISqlJoinOnAndOr;

Methods

Name	Return Type	Description
On(string left, string right)	ISqlJoinOnAndOr	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)	ISqlJoinOnAndOr	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)	ISqlJoinOnAndOr	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)	ISqlJoinOnAndOr	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)	ISqlJoinOnAndOr	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)	ISqlJoinOnAndOr	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)	ISqlJoinOnAndOr	Creates an ON clause and adds a search condition to it using an ISqlJoinCondition object.
OnRaw(string clause, params ISqlParameter[] parameters)	ISqlJoinOnAndOr	Creates an ON clause and adds a raw SQL to it.
OnValue(string left, object value)	ISqlJoinOnAndOr	Creates an ON clause and adds a search condition to it. Specifies the SQL expression on the left of the operator and a specific value on the right of the operator. The operator is '='.
OnValue(string left, SqlBinaryOperator sqlOperator, object value)	ISqlJoinOnAndOr	Creates an ON clause and adds a search condition to it. Specifies a SQL expression on the left of the operator and a specific value on the right of the operator.