Click or drag to resize
WhereBuilder Class
Where condition builder
Inheritance Hierarchy
SystemObject
  CMS.DataEngineWhereBuilder

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 9.0.0
Syntax
C#
public class WhereBuilder

The WhereBuilder type exposes the following members.

Constructors
  NameDescription
Public methodWhereBuilder
Top
Fields
  NameDescription
Public fieldStatic memberEQUAL
SQL "=" operator constant.
Public fieldStatic memberLIKE
SQL "LIKE" operator constant.
Public fieldStatic memberNOT_EQUAL
SQL "<>" operator constant.
Public fieldStatic memberNOT_LIKE
SQL "NOT LIKE" operator constant.
Top
Properties
  NameDescription
Public propertyStatic memberDefault
Default where builder
Public propertyNULL
Returns the NULL constant
Public propertyOperatorAND
Returns the AND operator
Public propertyOperatorOR
Returns the OR operator
Top
Methods
  NameDescription
Public methodAddWhereCondition
Adds the where condition to the existing one
Public methodGetBinaryOperator
Gets the binary operator based on the expression type
Public methodGetEqualsOrNull
Gets the equals or empty expression
Public methodGetExists
Gets the EXISTS expression
Public methodGetIn
Gets the IN expression
Public methodGetIsNull
Gets the IS NULL expression
Public methodGetNegation
Gets the negation of the given where condition
Public methodGetNestedWhereCondition
Adds the where condition to the existing one
Public methodGetOperator
Gets the operator string
Public methodGetParameter
Gets a new parameter
Public methodGetWhere(String, QueryUnaryOperator)
Gets the where condition for the given column
Public methodGetWhere(IQueryObjectWithValue, QueryUnaryOperator)
Gets the where condition for the given column
Public methodGetWhere(String, QueryOperator, Object, QueryDataParameters)
Gets the where condition for the given column
Public methodGetWhere(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 methodStatic memberRepresentsNull
Returns true if the given value represents database NULL
Top
See Also