SqlConnection Members
.NET Framework 3.5
Represents an open connection to a SQL Server database. This class cannot be inherited.
The SqlConnection type exposes the following members.
| Name | Description | |
|---|---|---|
|
SqlConnection | Overloaded. Initializes a new instance of the SqlConnection class. |
| Name | Description | |
|---|---|---|
|
|
BeginDbTransaction | Starts a database transaction. (Inherited from DbConnection.) |
|
|
BeginTransaction | Overloaded. Starts a database transaction. |
|
|
ChangeDatabase | Changes the current database for an open SqlConnection. (Overrides DbConnection.ChangeDatabase(String).) |
|
|
ChangePassword | Changes the SQL Server password for the user indicated in the connection string to the supplied new password. |
|
|
ClearAllPools | Empties the connection pool. |
|
|
ClearPool | Empties the connection pool associated with the specified connection. |
|
|
Close | Closes the connection to the database. This is the preferred method of closing any open connection. (Overrides DbConnection.Close().) |
|
|
CreateCommand | Creates and returns a SqlCommand object associated with the SqlConnection. |
|
|
CreateDbCommand | Creates and returns a DbCommand object associated with the current connection. (Inherited from DbConnection.) |
|
|
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.) |
|
|
Dispose | Overloaded. Releases the resources used by the Component. |
|
|
EnlistDistributedTransaction | Enlists in the specified transaction as a distributed transaction. |
|
|
EnlistTransaction | Enlists in the specified transaction as a distributed transaction. (Overrides DbConnection.EnlistTransaction(Transaction).) |
|
|
Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
|
|
Finalize | Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.) |
|
|
GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
|
|
GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.) |
|
|
GetSchema | Overloaded. Returns schema information for the data source of this SqlConnection. |
|
|
GetService | Returns an object that represents a service provided by the Component or by its Container. (Inherited from Component.) |
|
|
GetType | Gets the type of the current instance. (Inherited from Object.) |
|
|
InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.) |
|
|
MemberwiseClone | Overloaded. |
|
|
OnStateChange | Raises the StateChange event. (Inherited from DbConnection.) |
|
|
Open | Opens a database connection with the property settings specified by the ConnectionString. (Overrides DbConnection.Open().) |
|
|
ResetStatistics | If statistics gathering is enabled, all values are reset to zero. |
|
|
RetrieveStatistics | Returns a name value pair collection of statistics at the point in time the method is called. |
|
|
ToString | Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from Component.) |
| Name | Description | |
|---|---|---|
|
|
CanRaiseEvents | Gets a value indicating whether the component can raise an event. (Inherited from Component.) |
|
|
ConnectionString | Gets or sets the string used to open a SQL Server database. (Overrides DbConnection.ConnectionString.) |
|
|
ConnectionTimeout | Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error. (Overrides DbConnection.ConnectionTimeout.) |
|
|
Container | Gets the IContainer that contains the Component. (Inherited from Component.) |
|
|
Database | Gets the name of the current database or the database to be used after a connection is opened. (Overrides DbConnection.Database.) |
|
|
DataSource | Gets the name of the instance of SQL Server to which to connect. (Overrides DbConnection.DataSource.) |
|
|
DbProviderFactory | Gets the DbProviderFactory for this DbConnection. (Inherited from DbConnection.) |
|
|
DesignMode | Gets a value that indicates whether the Component is currently in design mode. (Inherited from Component.) |
|
|
Events | Gets the list of event handlers that are attached to this Component. (Inherited from Component.) |
|
|
FireInfoMessageEventOnUserErrors | Gets or sets the FireInfoMessageEventOnUserErrors property. |
|
|
PacketSize | Gets the size (in bytes) of network packets used to communicate with an instance of SQL Server. |
|
|
ServerVersion | Gets a string that contains the version of the instance of SQL Server to which the client is connected. (Overrides DbConnection.ServerVersion.) |
|
|
Site | Gets or sets the ISite of the Component. (Inherited from Component.) |
|
|
State | Indicates the state of the SqlConnection. (Overrides DbConnection.State.) |
|
|
StatisticsEnabled | When set to true, enables statistics gathering for the current connection. |
|
|
WorkstationId | Gets a string that identifies the database client. |
| Name | Description | |
|---|---|---|
|
|
Disposed | Occurs when the component is disposed by a call to the Dispose method. (Inherited from Component.) |
|
|
InfoMessage | Occurs when SQL Server returns a warning or informational message. |
|
|
StateChange |
Occurs when the state of the event changes. (Inherited from DbConnection.) In .NET Compact Framework 3.5, this member is StateChange. |
| Name | Description | |
|---|---|---|
|
|
BeginTransaction | Overloaded. |
|
|
ICloneable.Clone | |
|
|
CreateCommand | Overloaded. |
|
|
IDisposable.Dispose |
