SelectCondition Class

Provides the selection where condition for ABC IN (1, 2, 3, 4, 5, ...) for very large number of items.

Inheritance Hierarchy

System.Object
  CMS.DataEngine.SelectCondition

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

Syntax

public class SelectCondition : IDisposable

The SelectCondition type exposes the following members.

Constructors

	Name	Description
Public method	SelectCondition()	Constructor, prepares empty condition object.
Public method	SelectCondition(QueryDataParameters)	Constructor, prepares empty condition object bound to specific query parameters.
Public method	SelectCondition(String, IList<Int32>, Boolean)	Constructor, prepares the condition over IDs.
Public method	SelectCondition(String, IList<String>, Boolean)	Constructor, prepares the condition over names (strings).

Methods

	Name	Description
Public method	Dispose	Disposes the object and removes the selection from the database if it was allocated in the temp table.
Public method	Prepare(String, IList<Int32>, Boolean)	Prepares the condition over IDs.
Public method	Prepare(String, IList<String>, Boolean, Boolean)	Prepares the condition over names (strings).
Public method	PrepareIDs	Prepares the condition over IDs.
Protected method	PrepareWhereCondition	Prepares the where condition for the given list.

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	ALL_INLINE	Constant for Inline limit property defining that all items should be processed inline
Protected field	mGroupGUID	Group GUID for the temp table.
Protected field	mInlineLimit	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 ItemName FROM Func_Selection_ParseNames(@List_949939be_1bf7_48d9_bbd6_57facb5c8001)) Otherwise, inline format is used: ColumnName IN (Value1, Value2, ...) If set to -1, inline format is always used.
Protected field	mParameters	Query parameters.
Protected field	mWhereCondition	Where condition.

Properties

	Name	Description
Public property	InlineLimit	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 ItemName FROM Func_Selection_ParseNames(@List_949939be_1bf7_48d9_bbd6_57facb5c8001)) Otherwise, inline format is used: ColumnName IN (Value1, Value2, ...) If set to -1, inline format is always used.
Public property	IsEmpty	Returns true if the selection is empty.
Public property	WhereCondition	Returns the resulting where condition.