Share via


Database.ExecuteScalar Method

Include Protected Members
Include Inherited Members

Overload List

  Name Description
Public method ExecuteScalar(DbCommand)

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

Public method ExecuteScalar(CommandType, String)

Executes the commandText interpreted as specified by the commandType and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

Public method ExecuteScalar(DbCommand, DbTransaction)

Executes the command within a transaction, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

Public method ExecuteScalar(String, array<Object[])

Executes the storedProcedureName with the given parameterValues and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

Public method ExecuteScalar(DbTransaction, CommandType, String)

Executes the commandText interpreted as specified by the commandType within the given transaction and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

Public method ExecuteScalar(DbTransaction, String, array<Object[])

Executes the storedProcedureName with the given parameterValues within a transaction and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

See Also

Database Class

Database Members

Microsoft.Practices.EnterpriseLibrary.Data Namespace