IQueryAndOrBuilder<TModel> Interface

.NET Standard 2.x

Adds query conditions to the WHERE clause of a SQL statement using the AND or OR operator.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Syntax

public interface IQueryAndOrBuilder<TModel> : ISqlBuilderLoader<TModel>

Methods

Name	Return type	Description
AndWhereValue(string left, object value)	IQueryAndOrBuilder<TModel>	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 specific value on the right of the operator. The operator is '='.
AndWhereValue(string left, SqlBinaryOperator sqlOperator, object value)	IQueryAndOrBuilder<TModel>	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 specific value on the right of the operator.
AndWhere(string left, ISqlParameter parameter)	IQueryAndOrBuilder<TModel>	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)	IQueryAndOrBuilder<TModel>	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)	IQueryAndOrBuilder<TModel>	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)	IQueryAndOrBuilder<TModel>	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)	IQueryAndOrBuilder<TModel>	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)	IQueryAndOrBuilder<TModel>	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)	IQueryAndOrBuilder<TModel>	Adds the AND logical operator and a search condition (specified by an ISqlWhereCondition object) to the WHERE clause.
AndWhereRaw(string clause, params ISqlParameter[] parameters)	IQueryAndOrBuilder<TModel>	Adds the AND logical operator and a raw SQL to the WHERE clause.
AndWhereIsNull(string left)	IQueryAndOrBuilder<TModel>	Adds the AND logical operator and a search condition to the WHERE clause; and uses IS NULL operator to search for values that are null.
AndWhereIsNotNull(string left)	IQueryAndOrBuilder<TModel>	Adds the AND logical operator and a search condition to the WHERE clause; and uses IS NOT NULL operator to search for values that are not null.
AndWhereExists(ISqlBuilder sqlBuilder)	IQueryAndOrBuilder<TModel>	Adds the AND logic operator and a search condition to the WHERE clause; and uses EXISTS to test for the existence of the record returned from a subquery.
AndWhereNotExists(ISqlBuilder sqlBuilder)	IQueryAndOrBuilder<TModel>	Adds the AND logical operator and a search condition to the WHERE clause; and uses the NOT EXISTS operator to test if the record returned from a subquery does not exist.
OrWhereValue(string left, object value)	IQueryAndOrBuilder<TModel>	Adds the OR logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left the operator and a specific value on the right of the operator. The operator is '='.
OrWhereValue(string left, SqlBinaryOperator sqlOperator, object value)	IQueryAndOrBuilder<TModel>	Adds the OR logical operator and a search condition to the WHERE clause; and specifies a SQL expression on the left the operator and a specific value on the right of the operator.
OrWhere(string left, ISqlParameter parameter)	IQueryAndOrBuilder<TModel>	Adds the OR 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. The operator is '='.
OrWhere(string left, SqlBinaryOperator sqlOperator, ISqlParameter parameter)	IQueryAndOrBuilder<TModel>	Adds the OR 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.
OrWhere(string left, string right)	IQueryAndOrBuilder<TModel>	Adds the OR 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 '='.
OrWhere(string left, SqlBinaryOperator sqlOperator, string right)	IQueryAndOrBuilder<TModel>	Adds the OR logical operator and a search condition to the WHERE clause; and specifies SQL expressions on both the left and right of the operator.
OrWhere(string left, ISqlBuilder sqlBuilder)	IQueryAndOrBuilder<TModel>	Adds the OR 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 '='.
OrWhere(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder)	IQueryAndOrBuilder<TModel>	Adds the OR 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.
OrWhere(ISqlWhereCondition condition)	IQueryAndOrBuilder<TModel>	Adds the OR logical operator and a search condition (specified by an ISqlWhereCondition object) to the WHERE clause.
OrWhereRaw(string clause, params ISqlParameter[] parameters)	IQueryAndOrBuilder<TModel>	Adds the OR logical operator and a raw SQL to the WHERE clause.
OrWhereIsNull(string left)	IQueryAndOrBuilder<TModel>	Adds the OR logical operator and a search condition to the WHERE clause; and uses IS NULL operator to search for values that are null.
OrWhereIsNotNull(string left)	IQueryAndOrBuilder<TModel>	Adds the OR logical operator and a search condition to the WHERE clause; and uses the IS NOT NULL operator to search for values that are not null.
OrWhereExists(ISqlBuilder sqlBuilder)	IQueryAndOrBuilder<TModel>	Adds the OR logical operator and a search condition to the WHERE clause; and uses EXISTS to test for the existence of the record returned from a subquery.
OrWhereNotExists(ISqlBuilder sqlBuilder)	IQueryAndOrBuilder<TModel>	Adds the OR logical operator and a search condition to the WHERE clause; and uses the NOT EXISTS operator to test if the record returned from a subquery does not exist.