QuerySource Class

Data query source which gets the data from specific SQL expression. That can be table name, view name, or more complex SQL expression.

Inheritance Hierarchy

System.Object
  CMS.Base.DisposableObject
    CMS.DataEngine.AbstractQueryObject
      CMS.DataEngine.QueryParametersBase<QuerySource>
        CMS.DataEngine.QuerySourceBase<QuerySource>
          CMS.DataEngine.QuerySource

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

Syntax

public class QuerySource : QuerySourceBase<QuerySource>

The QuerySource type exposes the following members.

Constructors

	Name	Description
Public method	QuerySource()	Constructor
Public method	QuerySource(String)	Constructor

Methods

	Name	Description
Public method	ApplyParametersTo	Applies this where condition to the target object (Inherited from QueryParametersBase<TParent>.)
Public method	CallOnDispose	Adds the given action to the list of actions called when the handler object is disposed (Inherited from DisposableObject.)
Public method	Clone	Creates the clone of the object. (Inherited from QueryParametersBase<TParent>.)
Public method	CloneObject	Creates the clone of the object. (Inherited from QueryParametersBase<TParent>.)
Public method	CopyPropertiesTo	Copies all the object properties to the given target class (Inherited from QueryParametersBase<TParent>.)
Public method	Dispose	Make sure the objects get disposed (Inherited from DisposableObject.)
Public method	EnsureParameters	Ensures data parameters for the given query (Inherited from QueryParametersBase<TParent>.)
Public method	Expand	Expands the expression by replacing parameters with their values (Inherited from QueryParametersBase<TParent>.)
Public method	Changed	Marks the object as changed (Inherited from AbstractQueryObject.)
Public method	Immutable	Makes this object instance is immutable, and next subsequent modification starts with a clone of the object. (Inherited from QueryParametersBase<TParent>.)
Public method	IncludeDataParameters	Adds the data parameters to the current query parameters (Inherited from QueryParametersBase<TParent>.)
Public method	InnerJoin(String, IWhereCondition)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	InnerJoin(String, String)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	InnerJoin(String, String, String)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	InnerJoin<TObject>(String, String, IWhereCondition)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	Join(String, IWhereCondition, JoinTypeEnum)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	Join(String, String, JoinTypeEnum)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	Join(String, String, String, IWhereCondition, JoinTypeEnum)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	Join<TObject>(String, String, JoinTypeEnum, IWhereCondition)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	LeftJoin(String, IWhereCondition)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	LeftJoin(String, String)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	LeftJoin(String, String, String, IWhereCondition)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	LeftJoin<TObject>(String, String, IWhereCondition)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	Lock	Locks the event on the given lock object. The context stays locked until the handler is disposed. (Inherited from DisposableObject.)
Protected method	NewResult	Returns properly typed this (Inherited from QueryParametersBase<TParent>.)
Public method	Reset	Flushes the results but leaves the generated query text unchanged. After the reset, query can be executed again to obtain new data. (Inherited from AbstractQueryObject.)
Public method	RightJoin(String, IWhereCondition)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	RightJoin(String, String)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	RightJoin(String, String, String, IWhereCondition)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	RightJoin<TObject>(String, String, IWhereCondition)	Joins the given source with another (Inherited from QuerySourceBase<TSource>.)
Public method	Snapshot	Creates an immutable snapshot of the current query as a base for further evaluation. Doesn't modify the original query in any way. (Inherited from QueryParametersBase<TParent>.)
Public method	ToString()	Returns the string representation of the expression (Inherited from QueryParametersBase<TParent>.)
Public method	ToString(Boolean)	Returns the string representation of the expression, with possibility of expanding parameters (Inherited from QuerySourceBase<TSource>.)
Protected method	TranslateSource	Translates the source to the final query expression (Inherited from QuerySourceBase<TSource>.)
Public method	Using	Adds the given object to the list of the allocated objects to dispose (Inherited from DisposableObject.)

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
Protected field	mParameters	Query data parameters (Inherited from QueryParametersBase<TParent>.)

Properties

	Name	Description
Protected property	IsImmutable	If true, this object instance is immutable, and next subsequent modification starts with a clone of the object. (Inherited from QueryParametersBase<TParent>.)
Protected property	LeftSourceName	Left source name (Inherited from QuerySourceBase<TSource>.)
Public property	Name	Object name, empty by default (Inherited from AbstractQueryObject.)
Public property	Parameters	Query data parameters (Inherited from QueryParametersBase<TParent>.)
Protected property	RightSourceName	Left source name (Inherited from QuerySourceBase<TSource>.)
Public property	SourceExpression	Source expression (Inherited from QuerySourceBase<TSource>.)