Export (0) Print
Expand All

DbConnection Class

Represents a connection to a database.

Namespace:  System.Data.Common
Assembly:  System.Data (in System.Data.dll)

[<AbstractClass>]
type DbConnection =  
    class
        inherit Component
        interface IDbConnection
        interface IDisposable
    end

The DbConnection type exposes the following members.

  NameDescription
Protected methodSupported by the XNA FrameworkDbConnectionInitializes a new instance of the DbConnection class.
Top

  NameDescription
Protected propertyCanRaiseEventsGets a value indicating whether the component can raise an event. (Inherited from Component.)
Public propertySupported by the XNA FrameworkConnectionStringGets or sets the string used to open the connection.
Public propertySupported by the XNA FrameworkConnectionTimeoutGets the time to wait while establishing a connection before terminating the attempt and generating an error.
Public propertyContainerGets the IContainer that contains the Component. (Inherited from Component.)
Public propertySupported by the XNA FrameworkDatabaseGets 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.
Public propertySupported by the XNA FrameworkDataSourceGets the name of the database server to which to connect.
Protected propertyDbProviderFactoryGets the DbProviderFactory for this DbConnection.
Protected propertyDesignModeGets a value that indicates whether the Component is currently in design mode. (Inherited from Component.)
Protected propertySupported by the XNA FrameworkEventsGets the list of event handlers that are attached to this Component. (Inherited from Component.)
Public propertySupported by the XNA FrameworkServerVersionGets a string that represents the version of the server to which the object is connected.
Public propertySupported by the XNA FrameworkSiteGets or sets the ISite of the Component. (Inherited from Component.)
Public propertySupported by the XNA FrameworkStateGets a string that describes the state of the connection.
Top

  NameDescription
Protected methodSupported by the XNA FrameworkBeginDbTransactionStarts a database transaction.
Public methodSupported by the XNA FrameworkBeginTransaction()Starts a database transaction.
Public methodSupported by the XNA FrameworkBeginTransaction(IsolationLevel)Starts a database transaction with the specified isolation level.
Public methodSupported by the XNA FrameworkChangeDatabaseChanges the current database for an open connection.
Public methodSupported by the XNA FrameworkCloseCloses the connection to the database. This is the preferred method of closing any open connection.
Public methodSupported by the XNA FrameworkCreateCommandCreates and returns a DbCommand object associated with the current connection.
Protected methodSupported by the XNA FrameworkCreateDbCommandCreates and returns a DbCommand object associated with the current connection.
Public methodCreateObjRefCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
Public methodSupported by the XNA FrameworkDispose()Releases all resources used by the Component. (Inherited from Component.)
Protected methodSupported by the XNA FrameworkDispose(Boolean)Releases the unmanaged resources used by the Component and optionally releases the managed resources. (Inherited from Component.)
Public methodEnlistTransactionEnlists in the specified transaction.
Public methodSupported by the XNA FrameworkEquals(Object)Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected methodSupported by the XNA FrameworkFinalizeReleases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.)
Public methodSupported by the XNA FrameworkGetHashCodeServes as a hash function for a particular type. (Inherited from Object.)
Public methodGetLifetimeServiceRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public methodSupported by the XNA FrameworkGetSchema()Returns schema information for the data source of this DbConnection.
Public methodSupported by the XNA FrameworkGetSchema(String)Returns schema information for the data source of this DbConnection using the specified string for the schema name.
Public methodSupported by the XNA FrameworkGetSchema(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.
Protected methodGetServiceReturns an object that represents a service provided by the Component or by its Container. (Inherited from Component.)
Public methodSupported by the XNA FrameworkGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodInitializeLifetimeServiceObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected methodSupported by the XNA FrameworkMemberwiseClone()Creates a shallow copy of the current Object. (Inherited from Object.)
Protected methodMemberwiseClone(Boolean)Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.)
Protected methodSupported by the XNA FrameworkOnStateChangeRaises the StateChange event.
Public methodSupported by the XNA FrameworkOpenOpens a database connection with the settings specified by the ConnectionString.
Public methodSupported by the XNA FrameworkToStringReturns 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().
Top

  NameDescription
Public eventSupported by the XNA FrameworkDisposedOccurs when the component is disposed by a call to the Dispose method. (Inherited from Component.)
Public eventSupported by the XNA FrameworkStateChangeOccurs when the state of the event changes.
Top

  NameDescription
Explicit interface implemetationPrivate methodSupported by the XNA FrameworkIDbConnection.BeginTransaction()Begins a database transaction.
Explicit interface implemetationPrivate methodSupported by the XNA FrameworkIDbConnection.BeginTransaction(IsolationLevel)Begins a database transaction with the specified IsolationLevel value.
Explicit interface implemetationPrivate methodSupported by the XNA FrameworkIDbConnection.CreateCommandCreates and returns a DbCommand object that is associated with the current connection.
Top

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.

.NET Framework

Supported in: 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft