QueryDataParameters Members

Kentico 8.1 API Reference

The QueryDataParameters type exposes the following members.

Constructors

	Name	Description
	QueryDataParameters	Constructor

Methods

	Name	Description
	Add(DataParameter)	Adds the parameter into the list.
	Add(DataParameter, Boolean)	Adds the parameter into the list.
	Add(String, Object, Boolean)	Adds the parameter into the list.
	Add(String, Object, Type)	Adds the parameter into the list.
	AddDateTime	Adds the date time parameter into the list (if the date time is DateTime.MinValue, adds DBNull.Value).
	AddGuid	Adds the guid parameter into the list (if the guid id Guid.Empty, adds DBNull.Value).
	AddId	Adds the ID parameter into the list (if the ID is not larger than 0, adds DBNull.Value).
	AddMacro	Adds the macro to the query data parameters
	AddUnique	Adds the parameter into the list, if the parameter already exists, defines a unique name for it.
	Equals	Returns true if the object equals another object (Overrides Object Equals(Object).)
	Expand	Expands the expression by replacing parameters with their values
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	GetEnumerator	Gets the enumerator.
	GetHashCode	Provides a hashcode for the object (Overrides Object GetHashCode .)
	GetMacroEnumerator	Gets the enumerator.
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	GetUpdateQueryColumns	Gets the columns representation for the update query in the form of Column1 = @Column1, Column2 = @Column2, etc.
	IncludeDataParameters	Adds the data parameters to the current query parameters
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	ResolveMacros	Resolves macros within the given query text
	ToArray	Converts the data parameters to an array of parameters [[name, value, type], ...].
	ToString	Converts the data parameter to string (Overrides Object ToString .)

Extension Methods

	Name	Description
	AsValue	Converts object to a query value which can be used as a query parameter (Defined by QueryExtensions.)
	Batch DataParameter	Returns input in batches of batchSize size. (Defined by BaseExtensions.)
	GetAPIString	Gets the string by the specified resource key (Defined by CoreExtensions.)
	GetString	Gets the string by the specified resource key (Defined by CoreExtensions.)
	ToBoolean	Returns the boolean representation of an object or default value if not. (Defined by CoreExtensions.)
	ToDateTime	Returns the DateTime representation of an object or default value if not. (Defined by CoreExtensions.)
	ToDouble	Returns the double representation of an object or default value if not. (Defined by CoreExtensions.)
	ToGuid	Returns the Guid representation of an object or default value if not. (Defined by CoreExtensions.)
	ToInteger	Returns the integer representation of an object or default value if not. (Defined by CoreExtensions.)
	ToJSON	Returns JSON representation of current instance of IEnumerable. (Defined by DataExtensions.)
	ToList DataParameter, TTo	Converts the given collection to a list of values (Defined by BaseExtensions.)
	ToString	Returns the string representation of an object or default value if not. (Defined by CoreExtensions.)
	ToXML	Returns XML representation of current instance of IEnumerable. (Defined by DataExtensions.)

Properties

	Name	Description
	Count	Number of the registered parameters
	ExistingLocalParameters	Table of existing parameters [name -> DataParameter]
	ExtraLocalMacros	Extra query macros
	FillDataSet	DataSet to be filled by the query. If not given, new DataSet is created
	Item Int32	Returns the parameter on specified index.
	Item String	Returns the parameter of the specified name.
	LocalParameters	List of parameters defined locally in this instance
	MacroCount	Number of macros in the data parameters
	ParentParameters	Parent query parameters
	QueryAfter	Text included after the query
	QueryBefore	Text included before the query
	Source	Source of the data