Click or drag to resize
SelectCondition Class
Provides the selection where condition for ABC IN (1, 2, 3, 4, 5, ...) for very large number of items.
Inheritance Hierarchy
SystemObject
  CMS.DataEngineSelectCondition

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 12.0.0
Syntax
C#
public class SelectCondition : IDisposable

The SelectCondition type exposes the following members.

Constructors
  NameDescription
Public methodSelectCondition
Constructor, prepares empty condition object.
Public methodSelectCondition(QueryDataParameters)
Constructor, prepares empty condition object bound to specific query parameters.
Top
Fields
  NameDescription
Public fieldStatic memberALL_INLINE
Constant for Inline limit property defining that all items should be processed inline
Public fieldStatic memberALL_TABLE_VALUED_PARAMETER
Constant for Inline limit property defining that all items should be processed as table-valued parameter.
Protected fieldmGroupGUID
Group GUID for the temp table.
Protected fieldmInlineLimit
Limit of the number of items for the inline evaluation.
Protected fieldmParameters
Query parameters.
Protected fieldmWhereCondition
Where condition.
Top
Properties
  NameDescription
Public propertyInlineLimit
Limit of the number of items for the inline evaluation. If there are more items than this limit, the where condition is returned in format: ColumnName IN (SELECT * FROM @List)), where @List is of the following SQL user-defined table types: Type_CMS_IntegerTable, Type_CMS_BigIntTable, Type_CMS_StringTable, Type_CMS_GuidTable Otherwise, inline format is used: ColumnName IN (Value1, Value2, ...) If set to -1, inline format is always used.
Public propertyIsEmpty
Returns true if the selection is empty.
Public propertyWhereCondition
Returns the resulting where condition.
Top
Methods
  NameDescription
Public methodDispose
Disposes the object and removes the selection from the database if it was allocated in the temp table.
Public methodPrepareConditionT
Prepares the select condition for specific value types
Top
See Also