QueryMacros Class

Query expressions

Inheritance Hierarchy

System.Object
  CMS.DataEngine.QueryMacros

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

Syntax

public class QueryMacros

The QueryMacros type exposes the following members.

Constructors

	Name	Description
Public method	QueryMacros

Methods

	Name	Description
Public method	ResolveMacros	Resolves the given macros within a query
Public method	ToString	Gets the string representation of the where condition (Overrides Object.ToString().)

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	COLUMNS	Columns query macro
Public field Static member	DISTINCT	Distinct query macro
Public field Static member	GROUPBY	Group by query macro
Public field Static member	HAVING	Having query macro
Public field Static member	ORDERBY	Order by query macro
Public field Static member	SOURCE	Source query macro
Public field Static member	TOPN	Top N query macro
Public field Static member	VALUES	Values query macro
Public field Static member	WHERE	Where query macro

Properties

	Name	Description
Public property	Columns	List of columns to select
Public property	DefaultSource	Default query source
Public property	Distinct	If set to true, returns only distinct (different) values.
Public property	GroupBy	List of columns to group by
Public property	Having	Where condition for the GroupBy clause
Public property	OrderBy	Order by
Public property	Source	Query source
Public property	TopN	Top N records
Public property	Values	List of values for the update / insert query
Public property	Where	Where condition