Export (0) Print
Expand All

SqlConnection Methods

The SqlConnection type exposes the following members.

  NameDescription
Protected method BeginDbTransaction Starts a database transaction. (Inherited from DbConnection.)
Public method Supported by the .NET Compact Framework BeginTransaction Overloaded. Starts a database transaction.
Public method Supported by the .NET Compact Framework ChangeDatabase Changes the current database for an open SqlConnection. (Overrides DbConnection.ChangeDatabase(String).)
Public method Static member ChangePassword Changes the SQL Server password for the user indicated in the connection string to the supplied new password.
Public method Static member ClearAllPools Empties the connection pool.
Public method Static member ClearPool Empties the connection pool associated with the specified connection.
Public method Supported by the .NET Compact Framework Close Closes the connection to the database. This is the preferred method of closing any open connection. (Overrides DbConnection.Close().)
Public method Supported by the .NET Compact Framework CreateCommand Creates and returns a SqlCommand object associated with the SqlConnection.
Protected method CreateDbCommand Creates and returns a DbCommand object associated with the current connection. (Inherited from DbConnection.)
Public method CreateObjRef Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
Public method Supported by the .NET Compact Framework Dispose Overloaded. Releases the resources used by the Component.
Public method EnlistDistributedTransaction Enlists in the specified transaction as a distributed transaction.
Public method EnlistTransaction Enlists in the specified transaction as a distributed transaction. (Overrides DbConnection.EnlistTransaction(Transaction).)
Public method Supported by the .NET Compact Framework Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Supported by the .NET Compact Framework Finalize Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.)
Public method Supported by the .NET Compact Framework GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetLifetimeService Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public method GetSchema Overloaded. Returns schema information for the data source of this SqlConnection.
Protected method GetService Returns an object that represents a service provided by the Component or by its Container. (Inherited from Component.)
Public method Supported by the .NET Compact Framework GetType Gets the type of the current instance. (Inherited from Object.)
Public method InitializeLifetimeService Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected method Supported by the .NET Compact Framework MemberwiseClone Overloaded.
Protected method OnStateChange Raises the StateChange event. (Inherited from DbConnection.)
Public method Supported by the .NET Compact Framework Open Opens a database connection with the property settings specified by the ConnectionString. (Overrides DbConnection.Open().)
Public method ResetStatistics If statistics gathering is enabled, all values are reset to zero.
Public method RetrieveStatistics Returns a name value pair collection of statistics at the point in time the method is called.
Public method ToString Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from Component.)
Top

Community Additions

ADD
Show:
© 2014 Microsoft