This documentation is archived and is not being maintained.

SqlConnection Members

SqlConnection overview

Public Constructors

public constructorSqlConnection Constructor

Supported by the .NET Compact Framework.

Overloaded. Initializes a new instance of the SqlConnection class.

Public Properties

public propertyConnectionString

Supported by the .NET Compact Framework.

Gets or sets the string used to open a SQL Server database.
public propertyConnectionTimeout

Supported by the .NET Compact Framework.

Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error.
public propertyContainer (inherited from Component) Gets the IContainer that contains the Component.
public propertyDatabase

Supported by the .NET Compact Framework.

Gets the name of the current database or the database to be used after a connection is opened.
public propertyDataSource

Supported by the .NET Compact Framework.

Gets the name of the instance of SQL Server to which to connect.
public propertyPacketSize

Supported by the .NET Compact Framework.

Gets the size (in bytes) of network packets used to communicate with an instance of SQL Server.
public propertyServerVersion

Supported by the .NET Compact Framework.

Gets a string containing the version of the instance of SQL Server to which the client is connected.
public propertySite (inherited from Component) Gets or sets the ISite of the Component.
public propertyState

Supported by the .NET Compact Framework.

Gets the current state of the connection.
public propertyWorkstationId

Supported by the .NET Compact Framework.

Gets a string that identifies the database client.

Public Methods

public methodBeginTransaction

Supported by the .NET Compact Framework.

Overloaded. Begins a database transaction.
public methodChangeDatabase

Supported by the .NET Compact Framework.

Changes the current database for an open SqlConnection.
public methodClose

Supported by the .NET Compact Framework.

Closes the connection to the database. This is the preferred method of closing any open connection.
public methodCreateCommand

Supported by the .NET Compact Framework.

Creates and returns a SqlCommand object associated with the SqlConnection.
public methodCreateObjRef (inherited from MarshalByRefObject) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
public methodDispose (inherited from Component) Overloaded. Releases the resources used by the Component.
public methodEnlistDistributedTransaction Enlists in the specified transaction as a distributed transaction.
public methodEquals (inherited from Object)

Supported by the .NET Compact Framework.

Overloaded. Determines whether two Object instances are equal.
public methodGetHashCode (inherited from Object)

Supported by the .NET Compact Framework.

Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table.
public methodGetLifetimeService (inherited from MarshalByRefObject) Retrieves the current lifetime service object that controls the lifetime policy for this instance.
public methodGetType (inherited from Object)

Supported by the .NET Compact Framework.

Gets the Type of the current instance.
public methodInitializeLifetimeService (inherited from MarshalByRefObject) Obtains a lifetime service object to control the lifetime policy for this instance.
public methodOpen

Supported by the .NET Compact Framework.

Opens a database connection with the property settings specified by the ConnectionString.
public methodToString (inherited from Object)

Supported by the .NET Compact Framework.

Returns a String that represents the current Object.

Public Events

public eventDisposed (inherited from Component) Adds an event handler to listen to the Disposed event on the component.
public eventInfoMessage Occurs when SQL Server returns a warning or informational message.
public eventStateChange Occurs when the state of the connection changes.

Protected Properties

protected propertyDesignMode (inherited from Component) Gets a value that indicates whether the Component is currently in design mode.
protected propertyEvents (inherited from Component) Gets the list of event handlers that are attached to this Component.

Protected Methods

protected methodDispose

Supported by the .NET Compact Framework.

Overloaded. Overridden. Releases the resources used by the SqlConnection.
protected methodFinalize (inherited from Component)

Supported by the .NET Compact Framework.

Overridden. Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection.

In C# and C++, finalizers are expressed using destructor syntax.

protected methodGetService (inherited from Component) Returns an object that represents a service provided by the Component or by its Container.
protected methodMemberwiseClone (inherited from Object)

Supported by the .NET Compact Framework.

Creates a shallow copy of the current Object.

See Also

SqlConnection Class | System.Data.SqlClient Namespace

Show: