ISqlWhereAndOr<TBuilder>.AndWhere Method

.NET Standard 2.x

Adds the AND logical operator and a search condition to the WHERE clause.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Overloads

Method	Description
AndWhere(string left, ISqlParameter parameter)	Adds the AND logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left of the operator and a SQL parameter on the right of the operator. The operator is '='.
AndWhere(string left, SqlBinaryOperator sqlOperator, ISqlParameter parameter)	Adds the AND logical operator and a search condition to the WHERE clause; and specifies a SQL expression to the left of the operator and a SQL parameter to the right of the operator.
AndWhere(string left, string right)	Adds the AND logical operator and a search condition to the WHERE clause; and specifies SQL expressions on both the left and right of the operator. The operator is '='.
AndWhere(string left, SqlBinaryOperator sqlOperator, string right)	Adds the AND logical operator and a search condition to the WHERE clause; and specifies SQL expressions on both the left and right of the operator.
AndWhere(string left, ISqlBuilder sqlBuilder)	Adds the AND logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left of the operator and a SQL subquery on the right. The operator is '='.
AndWhere(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder)	Adds the AND logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left of the operator and a SQL subquery on the right.
AndWhere(ISqlWhereCondition condition)	Adds the AND logical operator and a search condition (specified by an ISqlWhereCondition object) to the WHERE clause.