SqlBuilder.Where Method

.NET Standard 2.x

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

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Overloads

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