Share via


SqlCeDatabase.ExecuteScalar Method

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.

The latest Enterprise Library information can be found at the Enterprise Library site.

Overload List

  Name Description
Ee776811.pubmethod(en-us,PandP.10).gif 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.

(Inherited from Database.)
Ee776811.pubmethod(en-us,PandP.10).gif 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.

(Inherited from Database.)
Ee776811.pubmethod(en-us,PandP.10).gif 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.

(Inherited from Database.)
Ee776811.pubmethod(en-us,PandP.10).gif ExecuteScalar(String, array<Object[])
Stored procedures are not support on SQL Server CE.
(Overrides DatabaseExecuteScalar(String, array<Object[]).)
Ee776811.pubmethod(en-us,PandP.10).gif 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.

(Inherited from Database.)
Ee776811.pubmethod(en-us,PandP.10).gif 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.

(Inherited from Database.)

See Also

SqlCeDatabase Class

SqlCeDatabase Members

Microsoft.Practices.EnterpriseLibrary.Data.SqlCe Namespace