DbConnection Class
.NET Framework 4
Represents a connection to a database.
Namespace:
System.Data.Common
Assembly: System.Data (in System.Data.dll)
The DbConnection type exposes the following members.
| 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 the connection. |
|
|
ConnectionTimeout | Gets the time to wait while establishing a connection before terminating the attempt and generating an error. |
|
|
Container | Gets the IContainer that contains the Component. (Inherited from Component.) |
|
|
Database | Gets the name of the current database after a connection is opened, or the database name specified in the connection string before the connection is opened. |
|
|
DataSource | Gets the name of the database server to which to connect. |
|
|
DbProviderFactory | Gets the DbProviderFactory for this 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.) |
|
|
ServerVersion | Gets a string that represents the version of the server to which the object is connected. |
|
|
Site | Gets or sets the ISite of the Component. (Inherited from Component.) |
|
|
State | Gets a string that describes the state of the connection. |
| Name | Description | |
|---|---|---|
|
BeginDbTransaction | Starts a database transaction. |
|
BeginTransaction() | Starts a database transaction. |
|
|
BeginTransaction(IsolationLevel) | Starts a database transaction with the specified isolation level. |
|
|
ChangeDatabase | Changes the current database for an open connection. |
|
|
Close | Closes the connection to the database. This is the preferred method of closing any open connection. |
|
|
CreateCommand | Creates and returns a DbCommand object associated with the current connection. |
|
|
CreateDbCommand | Creates and returns a DbCommand object associated with the current connection. |
|
|
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() | Releases all resources used by the Component. (Inherited from Component.) |
|
|
Dispose(Boolean) | Releases the unmanaged resources used by the Component and optionally releases the managed resources. (Inherited from Component.) |
|
|
EnlistTransaction | Enlists in the specified transaction. |
|
|
Equals(Object) | 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() | Returns schema information for the data source of this DbConnection. |
|
|
GetSchema(String) | Returns schema information for the data source of this DbConnection using the specified string for the schema name. |
|
|
GetSchema(String, String[]) | Returns schema information for the data source of this DbConnection using the specified string for the schema name and the specified string array for the restriction values. |
|
|
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() | Creates a shallow copy of the current Object. (Inherited from Object.) |
|
|
MemberwiseClone(Boolean) | Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.) |
|
|
OnStateChange | Raises the StateChange event. |
|
|
Open | Opens a database connection with the settings specified by the ConnectionString. |
|
|
ToString |
Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from Component.) In XNA Framework 3.0, this member is inherited from Object.ToString(). |
| Name | Description | |
|---|---|---|
|
Disposed | Occurs when the component is disposed by a call to the Dispose method. (Inherited from Component.) |
|
|
StateChange | Occurs when the state of the event changes. |
| Name | Description | |
|---|---|---|
|
IDbConnection.BeginTransaction() | Begins a database transaction. |
|
|
IDbConnection.BeginTransaction(IsolationLevel) | Begins a database transaction with the specified IsolationLevel value. |
|
|
IDbConnection.CreateCommand | Creates and returns a DbCommand object that is associated with the current connection. |
Notes to Inheritors
When you inherit from DbConnection, you must override the following members: Close, BeginDbTransaction, ChangeDatabase, CreateDbCommand, Open, and StateChange. You must also provide the following properties: ConnectionString, Database, DataSource, ServerVersion, and State.
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
