Partilhar via


Database.ExecuteScalar Method

Include Protected Members
Include Inherited Members

Retired Content

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

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

Retired Content

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.