SqlHelper..::..ExecuteScalarAsync Method (String, CommandType, String)

Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the database specified in the connection string.

Namespace:  Core
Assembly:  Core (in Core.dll)

Syntax


public static Task<Object> ExecuteScalarAsync(
	string connectionString,
	CommandType commandType,
	string commandText
)

Parameters

connectionString
Type: String
A valid connection string for a SqlConnection
commandType
Type: CommandType
The CommandType (stored procedure, text, etc.)
commandText
Type: String
The stored procedure name or T-SQL command

Return Value

An object containing the value in the 1x1 resultset generated by the command

Remarks


e.g.: int orderCount = (int)ExecuteScalarAsync(connString, CommandType.StoredProcedure, "GetOrderCount");