SqlCommandExtensions Members

Include Protected Members
Include Inherited Members

Retired Content
This content and the technology described is outdated and is no longer being maintained. For more information about Transient Fault Handling, see Transient Fault Handling.

Methods

	Name	Description
	ExecuteNonQueryWithRetry(SqlCommand)	Executes a Transact-SQL statement against the connection and returns the number of rows affected. Uses the default retry policy when executing the command.
	ExecuteNonQueryWithRetry(SqlCommand, RetryPolicy)	Executes a Transact-SQL statement against the connection and returns the number of rows affected. Uses the specified retry policy when executing the command.
	ExecuteNonQueryWithRetry(SqlCommand, RetryPolicy, RetryPolicy)	Executes a Transact-SQL statement against the connection and returns the number of rows affected. Uses the specified retry policy when executing the command. Uses a separate specified retry policy when establishing a connection.
	ExecuteReaderWithRetry(SqlCommand)	Sends the specified command to the connection and builds a SqlDataReader object containing the results. Uses the default retry policy when executing the command.
	ExecuteReaderWithRetry(SqlCommand, RetryPolicy)	Sends the specified command to the connection and builds a SqlDataReader object containing the results. Uses the specified retry policy when executing the command.
	ExecuteReaderWithRetry(SqlCommand, CommandBehavior)	Sends the specified command to the connection and builds a SqlDataReader object using one of the CommandBehavior values. Uses the default retry policy when executing the command.
	ExecuteReaderWithRetry(SqlCommand, RetryPolicy, RetryPolicy)	Sends the specified command to the connection and builds a SqlDataReader object containing the results. Uses the specified retry policy when executing the command. Uses a separate specified retry policy when establishing a connection.
	ExecuteReaderWithRetry(SqlCommand, CommandBehavior, RetryPolicy)	Sends the specified command to the connection and builds a SqlDataReader object using one of the CommandBehavior values. Uses the specified retry policy when executing the command.
	ExecuteReaderWithRetry(SqlCommand, CommandBehavior, RetryPolicy, RetryPolicy)	Sends the specified command to the connection and builds a SqlDataReader object using one of the CommandBehavior values. Uses the specified retry policy when executing the command. Uses a separate specified retry policy when establishing a connection.
	ExecuteScalarWithRetry(SqlCommand)	Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored. Uses the default retry policy when executing the command.
	ExecuteScalarWithRetry(SqlCommand, RetryPolicy)	Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored. Uses the specified retry policy when executing the command.
	ExecuteScalarWithRetry(SqlCommand, RetryPolicy, RetryPolicy)	Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored. Uses the specified retry policy when executing the command. Uses a separate specified retry policy when establishing a connection.
	ExecuteXmlReaderWithRetry(SqlCommand)	Sends the specified command to the connection and builds an XmlReader object containing the results. Uses the default retry policy when executing the command.
	ExecuteXmlReaderWithRetry(SqlCommand, RetryPolicy)	Sends the specified command to the connection and builds an XmlReader object containing the results. Uses the specified retry policy when executing the command.
	ExecuteXmlReaderWithRetry(SqlCommand, RetryPolicy, RetryPolicy)	Sends the specified command to the connection and builds an XmlReader object containing the results. Uses the specified retry policy when executing the command. Uses a separate specified retry policy when establishing a connection.

See Also

SqlCommandExtensions Class

Microsoft.Practices.EnterpriseLibrary.WindowsAzure.TransientFaultHandling.SqlAzure Namespace