ConnectionManager Members
The ConnectionManager class manages the connection to an instance of SQL Server.
The following tables list the members exposed by the ConnectionManager type.
Public Properties
| Name | Description | |
|---|---|---|
.gif "ms218537.pubproperty(en-US,SQL.90).gif") |
ApplicationName | Gets or sets the name of the application that has established the connection with the server. (inherited from ConnectionSettings) |
|
AutoDisconnectMode | Gets or sets the automatic disconnection mode of the referenced connection to the instance of SQL Server. |
|
CapturedSql | Gets the Transact-SQL statements that are captured when the connection is running in capture mode. |
|
ConnectAsUser | Gets or sets the Boolean property value that specifies whether the connection is established using impersonation. (inherited from ConnectionSettings) |
|
ConnectAsUserName | Gets or sets the name of the user when connecting using impersonation. (inherited from ConnectionSettings) |
|
ConnectAsUserPassword | Gets or sets the password for the user when connecting using impersonation. (inherited from ConnectionSettings) |
|
ConnectionString | Gets or sets the connection string used to establish a connection with a specified data source. (inherited from ConnectionSettings) |
|
ConnectTimeout | Gets or sets the connection time-out period in seconds. (inherited from ConnectionSettings) |
|
DatabaseName | Gets or sets the database required by the connection. (inherited from ConnectionSettings) |
|
EncryptConnection | Gets or sets the Boolean property value that specifies whether the connection is encrypted. (inherited from ConnectionSettings) |
|
InUse | Gets or sets the Boolean property value that specifies whether the connection is being used. |
|
IsOpen | Gets the Boolean property value that specifies whether the connection is currently open. |
|
LockTimeout | Gets or sets the time in seconds required for the connection to time out when the current transaction is locked. |
|
Login | Gets or sets the logon required to establish a connection with the instance of the server. (inherited from ConnectionSettings) |
|
LoginSecure | Gets or sets the Boolean property that specifies whether the connection is established to the server by using Windows Authentication or SQL Server Authentication. (inherited from ConnectionSettings) |
|
MaxPoolSize | Gets or sets the maximum number of connections in a connection pool that the specified connection accepts when establishing a connection with a server. (inherited from ConnectionSettings) |
|
MinPoolSize | Gets or sets the minimum number of connections in a connection pool that the specified connection accepts when establishing a connection with a server. (inherited from ConnectionSettings) |
|
MultipleActiveResultSets | Gets or sets the Boolean property value that specifies whether more than one active result set is permitted. (inherited from ConnectionSettings) |
|
NetworkProtocol | Gets or sets the network protocol used to establish the connection to the server. (inherited from ConnectionSettings) |
|
NonPooledConnection | Gets or sets the Boolean property value that specifies whether the connection may be pooled or nonpooled. (inherited from ConnectionSettings) |
|
PacketSize | Gets or sets the packets of data sent between the client and the server over the network in bytes. (inherited from ConnectionSettings) |
|
Password | Gets or sets the password used with the logon to establish a connection with the server when SQL Server Authentication is used. (inherited from ConnectionSettings) |
|
PooledConnectionLifetime | Gets or sets the lifetime of the pooled connection. (inherited from ConnectionSettings) |
|
SecurePassword | Gets or sets the secure password used with the logon to establish a connection with the server when SQL Server Authentication is used. (inherited from ConnectionSettings) |
|
ServerInstance | Gets or sets the name of the server. (inherited from ConnectionSettings) |
|
ServerVersion | Gets the version of the connected instance of SQL Server. |
|
SqlConnectionObject | Gets the connection object. |
|
WorkstationId | Gets or sets the ID value that uniquely identifies the workstation. (inherited from ConnectionSettings) |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "ms218537.pubmethod(en-US,SQL.90).gif") |
Connect | Connects to the instance of SQL Server. |
|
Disconnect | Disconnects from the instance of SQL Server. |
|
Equals | Overloaded. (inherited from Object ) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
.gif "ms218537.static(en-US,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
ToString | Returns the referenced object name as a string. (inherited from ConnectionSettings) |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms218537.protmethod(en-US,SQL.90).gif") |
CheckServerVersion | |
|
Finalize | (inherited from Object ) |
|
MemberwiseClone | (inherited from Object ) |
|
ThrowIfPropertyNotSet | Overloaded. (inherited from ConnectionSettings ) |
Top
Public Events
| Name | Description | |
|---|---|---|
.gif "ms218537.pubevent(en-US,SQL.90).gif") |
InfoMessage | The event that occurs when the instance of SQL Server generates an informational message. |
|
RemoteLoginFailed | This event occurs when a remote login fails to connect to the instance of SQL Server. |
|
ServerMessage | |
|
StateChange | The event that occurs when the instance of SQL Server changes state. |
|
StatementExecuted | The event that occurs when the instance of SQL Server executes a statement on the current connection. |
Top
See Also
Reference
ConnectionManager Class
Microsoft.SqlServer.Management.Common Namespace