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

SnapObjects.Data.ISqlJoinOnAndOr<ISqlJoinOnAndOr>

SnapObjects.Data.ISqlWhereBuilder

SnapObjects.Data.ISqlGroupBuilder

SnapObjects.Data.ISqlHavingBuilder

SnapObjects.Data.ISqlOrderBuilder

SnapObjects.Data.ISqlBuilder

SnapObjects.Data.ISqlBuilderBase

System.ICloneable<ISqlBuilder>

Syntax

 public interface ISqlJoinOnBuilder : ISqlJoinOnAndOr, ISqlJoinOnAndOr<ISqlJoinOnAndOr>, ISqlWhereBuilder, ISqlGroupBuilder, ISqlHavingBuilder, ISqlOrderBuilder, ISqlBuilder, ISqlBuilderBase, ICloneable<ISqlBuilder>;

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.