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

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

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

Syntax

public static Task<int> ExecuteNonQueryAsync(
	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 int representing the number of rows affected by the command

Remarks

e.g.: int result = ExecuteNonQueryAsync(connString, CommandType.StoredProcedure, "PublishOrders");

See Also

SqlHelper Class

ExecuteNonQueryAsync Overload