WhereBuilder Class

Where condition builder

Inheritance Hierarchy

System.Object
  CMS.DataEngine.WhereBuilder

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 9.0.0

Syntax

public class WhereBuilder

The WhereBuilder type exposes the following members.

Constructors

	Name	Description
Public method	WhereBuilder

Fields

	Name	Description
Public field Static member	EQUAL	SQL "=" operator constant.
Public field Static member	LIKE	SQL "LIKE" operator constant.
Public field Static member	NOT_EQUAL	SQL "<>" operator constant.
Public field Static member	NOT_LIKE	SQL "NOT LIKE" operator constant.

Properties

	Name	Description
Public property Static member	Default	Default where builder
Public property	NULL	Returns the NULL constant
Public property	OperatorAND	Returns the AND operator
Public property	OperatorOR	Returns the OR operator

Methods

	Name	Description
Public method	AddWhereCondition	Adds the where condition to the existing one
Public method	GetBinaryOperator	Gets the binary operator based on the expression type
Public method	GetEqualsOrNull	Gets the equals or empty expression
Public method	GetExists	Gets the EXISTS expression
Public method	GetIn	Gets the IN expression
Public method	GetIsNull	Gets the IS NULL expression
Public method	GetNegation	Gets the negation of the given where condition
Public method	GetNestedWhereCondition	Adds the where condition to the existing one
Public method	GetOperator	Gets the operator string
Public method	GetParameter	Gets a new parameter
Public method	GetWhere(String, QueryUnaryOperator)	Gets the where condition for the given column
Public method	GetWhere(IQueryObjectWithValue, QueryUnaryOperator)	Gets the where condition for the given column
Public method	GetWhere(String, QueryOperator, Object, QueryDataParameters)	Gets the where condition for the given column
Public method	GetWhere(IQueryObjectWithValue, QueryOperator, Object, QueryDataParameters)	Gets the where condition for the given expressions. Note that in this variant string value is always represented as a value. To pass in column name, you need to use new QueryColumn("Name")
Public method Static member	RepresentsNull	Returns true if the given value represents database NULL