Table of Contents

Class WhereCondition

Namespace
CMS.DataEngine
Assembly
CMS.DataEngine.dll

Where condition builder

public class WhereCondition : WhereConditionBase<WhereCondition>, IWhereCondition<WhereCondition>, IWhereCondition, IQueryParameters<WhereCondition>, IQueryParameters, IQueryObject
Inheritance
object
WhereCondition
Implements
Inherited Members
Extension Methods

Constructors

WhereCondition()

Default constructor

public WhereCondition()

Remarks

Conditions created using the constructor don't contain a data source identifier. Source identifiers are used to determine whether sub queries (WhereIn(string, IDataQuery)) are materialized or inserted directly into the parent query. For example, a sub query selecting objects from a separated online marketing database needs to be materialized when the parent query is executed against the main database.

If you know the data type that the new condition works with, create the condition using the CreateWhereCondition() method. You can also set the data source manually through the DataSourceName property.

WhereCondition(params IWhereCondition[])

Constructor

public WhereCondition(params IWhereCondition[] conditions)

Parameters

conditions IWhereCondition[]

Creates a where condition from the given where conditions

Remarks

Conditions created using the constructor don't contain a data source identifier. Source identifiers are used to determine whether sub queries (WhereIn(string, IDataQuery)) are materialized or inserted directly into the parent query. For example, a sub query selecting objects from a separated online marketing database needs to be materialized when the parent query is executed against the main database.

If you know the data type that the new condition works with, create the condition using the CreateWhereCondition() method. You can also set the data source manually through the DataSourceName property.

WhereCondition(string)

Constructor

public WhereCondition(string whereCondition)

Parameters

whereCondition string

Where condition

Remarks

Conditions created using the constructor don't contain a data source identifier. Source identifiers are used to determine whether sub queries (WhereIn(string, IDataQuery)) are materialized or inserted directly into the parent query. For example, a sub query selecting objects from a separated online marketing database needs to be materialized when the parent query is executed against the main database.

If you know the data type that the new condition works with, create the condition using the CreateWhereCondition() method. You can also set the data source manually through the DataSourceName property.

WhereCondition(string, QueryOperator, object)

Constructor

public WhereCondition(string columnName, QueryOperator op, object value)

Parameters

columnName string

Column name

op QueryOperator

Operator

value object

Value

Remarks

Conditions created using the constructor don't contain a data source identifier. Source identifiers are used to determine whether sub queries (WhereIn(string, IDataQuery)) are materialized or inserted directly into the parent query. For example, a sub query selecting objects from a separated online marketing database needs to be materialized when the parent query is executed against the main database.

If you know the data type that the new condition works with, create the condition using the CreateWhereCondition() method. You can also set the data source manually through the DataSourceName property.

WhereCondition(string, QueryUnaryOperator)

Constructor

public WhereCondition(string columnName, QueryUnaryOperator op)

Parameters

columnName string

Column name

op QueryUnaryOperator

Operator

Remarks

Conditions created using the constructor don't contain a data source identifier. Source identifiers are used to determine whether sub queries (WhereIn(string, IDataQuery)) are materialized or inserted directly into the parent query. For example, a sub query selecting objects from a separated online marketing database needs to be materialized when the parent query is executed against the main database.

If you know the data type that the new condition works with, create the condition using the CreateWhereCondition() method. You can also set the data source manually through the DataSourceName property.