WhereBuilder Class

Where condition builder

Inheritance Hierarchy

System.Object
  CMS.DataEngine.WhereBuilder

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

Syntax

public class WhereBuilder

The WhereBuilder type exposes the following members.

Constructors

	Name	Description
Public method	WhereBuilder

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

Extension Methods

	Name	Description
Public Extension Method	AsValue	Converts object to a query value which can be used as a query parameter (Defined by QueryExtensions.)
Public Extension Method	GetAPIString	Gets the string by the specified resource key (Defined by CoreExtensions.)
Public Extension Method	GetString	Gets the string by the specified resource key (Defined by CoreExtensions.)
Public Extension Method	ToBoolean	Returns the boolean representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToDateTime	Returns the DateTime representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToDouble	Returns the double representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToGuid	Returns the Guid representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToInteger	Returns the integer representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToString	Returns the string representation of an object or default value if not. (Defined by CoreExtensions.)

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