AbstractDataConnection.ExecuteScalar Method

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: 12.0.0

Syntax

public virtual Object ExecuteScalar(
	string queryText,
	QueryDataParameters queryParams,
	QueryTypeEnum queryType,
	bool requiresTransaction
)

Parameters

queryText

Type: System.String
Query or stored procedure to be run.

queryParams

Type: CMS.DataEngine.QueryDataParameters
Query parameters.

queryType

Type: CMS.DataEngine.QueryTypeEnum
Indicates if query is a SQL query or stored procedure.

requiresTransaction

Type: System.Boolean
If true, the query should run within transaction.

Return Value

Type: Object

Implements

IDataConnection.ExecuteScalar(String, QueryDataParameters, QueryTypeEnum, Boolean)