ReliableSqlConnection 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. |
The ReliableSqlConnection type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
.gif "Public method") |
ReliableSqlConnection(String) |
Initializes a new instance of the ReliableSqlConnection class with a given connection string. Uses the default retry policy for connections and commands unless retry settings are provided in the connection string.
|
|
ReliableSqlConnection(String, RetryPolicy) |
Initializes a new instance of the ReliableSqlConnection class with a given connection string and a policy defining whether to retry a request if the connection fails to be opened or a command fails to be successfully executed.
|
|
ReliableSqlConnection(String, RetryPolicy, RetryPolicy) |
Initializes a new instance of the ReliableSqlConnection class. Initializes a new instance of the SqlAzureConnection class with a given connection string and a policy defining whether to retry a request if the connection fails to be opened or a command fails to be successfully executed.
|
Methods
| Name | Description | |
|---|---|---|
|
BeginTransaction() |
Begins a database transaction.
|
|
BeginTransaction(IsolationLevel) |
Begins a database transaction with the specified System.Data.IsolationLevel value.
|
|
ChangeDatabase |
Changes the current database for an open Connection object.
|
.gif "Static member") |
ClearConnectionStringCache |
Clears the connection string cache.
|
|
Close |
Closes the connection to the database.
|
|
CreateCommand |
Creates and returns a SqlCommand object associated with the underlying SqlConnection.
|
|
Dispose |
Performs application-defined tasks associated with freeing, releasing, or resetting managed and unmanaged resources.
|
|
Equals | (Inherited from Object.) |
|
ExecuteCommand(IDbCommand) |
Executes a SQL command and returns the number of rows affected.
|
|
ExecuteCommand(IDbCommand, RetryPolicy) |
Executes a SQL command and returns the number of rows affected.
|
|
ExecuteCommand<T>(IDbCommand) |
Executes a SQL command and returns a result defined by the specified type T. This method uses the retry policy specified when instantiating the SqlAzureConnection class (or the default retry policy if no policy was set at construction time).
|
|
ExecuteCommand<T>(IDbCommand, RetryPolicy) |
Executes a SQL command using the specified retry policy and returns a result defined by the specified type T
|
|
ExecuteCommand<T>(IDbCommand, CommandBehavior) |
Executes a SQL command and returns a result defined by the specified type T. This method uses the retry policy specified when instantiating the SqlAzureConnection class (or the default retry policy if no policy was set at construction time).
|
|
ExecuteCommand<T>(IDbCommand, RetryPolicy, CommandBehavior) |
Executes a SQL command using the specified retry policy and returns a result defined by the specified type T
|
.gif "Protected method") |
Finalize |
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.) |
|
GetDnsSafeConnectionString |
Modifies the specified connection string to potentially improve reliability of a connection to SQL Azure database. If asynchronous mode is requested, modifications are performed in background and may not be reflected immediately.
|
|
GetHashCode |
Serves as a hash function for a particular type.
(Inherited from Object.) |
|
GetType |
Gets the Type of the current instance.
(Inherited from Object.) |
|
MemberwiseClone |
Creates a shallow copy of the current Object.
(Inherited from Object.) |
|
Open() |
Opens a database connection with the settings specified by the ConnectionString and ConnectionRetryPolicy properties.
|
|
Open(RetryPolicy) |
Opens a database connection with the settings specified by the ConnectionString and specified retry policy.
|
|
ToString | (Inherited from Object.) |
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
CommandRetryPolicy |
Gets the policy which decides whether to retry a command, based on how many times the request has been made and the reason for the last failure.
|
|
ConnectionRetryPolicy |
Gets the policy which decides whether to retry a connection request, based on how many times the request has been made and the reason for the last failure.
|
|
ConnectionString |
Gets or sets the connection string for opening a connection to the SQL Azure database.
|
|
ConnectionTimeout |
Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error.
|
|
Current |
Gets an instance of the SqlConnection object that represents the connection to an instance of SQL Azure database.
|
|
Database |
Gets the name of the current database or the database to be used after a connection is opened.
|
|
SessionTracingId |
Gets the CONTEXT_INFO value that was set for the current session. This value can be used for tracing the query execution problems.
|
|
State |
Gets the current state of the connection.
|
See Also
Microsoft.Practices.EnterpriseLibrary.WindowsAzure.TransientFaultHandling.SqlAzure Namespace