ConnectionHelper.ExecuteScalar Method (String, QueryDataParameters, QueryTypeEnum, Boolean)

ConnectionHelperExecuteScalar Method (String, QueryDataParameters, QueryTypeEnum, Boolean)

Executes the query and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

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

Syntax

public static Object ExecuteScalar(
	string queryText,
	QueryDataParameters parameters,
	QueryTypeEnum queryType,
	bool transaction = false
)

queryText: Type: SystemString
Query text.
parameters: Type: CMS.DataEngineQueryDataParameters
Query parameters.
queryType: Type: CMS.DataEngineQueryTypeEnum
Query type.
transaction (Optional): Type: SystemBoolean
If true, connection uses transaction for the query.

Type: Object