IQueryWhereBuilder<TModel> Interface

.NET Standard 2.x

Provides methods to add the WHERE clause for a dynamic query, or to check if the WHERE clause already exists or is null.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Syntax

public interface IQueryWhereBuilder<TModel> : ISqlBuilderLoader<TModel>

Methods

Name	Return type	Description
WhereValue(string left, object value)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to the WHERE clause. Specifies a SQL expression on the left of the operator and a specific value on the right of the operator. The operator is '='.
WhereValue(string left, SqlBinaryOperator sqlOperator, object value)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to the WHERE clause. Specifies a SQL expression on the left of the operator and a specific value on the right of the operator.
Where(string left, ISqlParameter parameter)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to 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)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to 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, string right)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to 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)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to the WHERE clause. Specifies SQL expressions on both the left and right of the operator.
Where(string left, ISqlBuilder sqlBuilder)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to 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)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to the WHERE clause. Specifies a SQL expression on the left of the operator and a SQL subquery on the right.
Where(ISqlWhereCondition condition)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to the WHERE clause by an ISqlWhereCondition object.
WhereRaw(string whereClause, params ISqlParameter[] parameters)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a raw SQL to the WHERE clause.
WhereIsNull(string left)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to the WHERE clause. Uses IS NULL operator to search for values that are null.
WhereIsNotNull(string left)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to the WHERE clause. Uses IS NOT NULL operator to search for values that are not null.
WhereExists(ISqlBuilder sqlBuilder)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to the WHERE clause. Uses EXISTS to test for the existence of the record returned from a subquery.
WhereNotExists(ISqlBuilder sqlBuilder)	IQueryAndOrBuilder<TModel>	Creates a WHERE clause, and adds a search condition to the WHERE clause. Uses the NOT EXISTS operator to test if the record returned from a subquery does not exist.