ConnectionManager 类
The ConnectionManager class manages the connection to an instance of SQL Server.
继承层次结构
System. . :: . .Object
  Microsoft.SqlServer.Management.Common. . :: . .ConnectionSettings
    Microsoft.SqlServer.Management.Common..::..ConnectionManager
      Microsoft.SqlServer.Management.Common. . :: . .ServerConnection
命名空间:  Microsoft.SqlServer.Management.Common
程序集:  Microsoft.SqlServer.ConnectionInfo(在 Microsoft.SqlServer.ConnectionInfo.dll 中)
语法
声明
Public MustInherit Class ConnectionManager _
    Inherits ConnectionSettings
用法
Dim instance As ConnectionManager
public abstract class ConnectionManager : ConnectionSettings
public ref class ConnectionManager abstract : public ConnectionSettings
[<AbstractClassAttribute>]
type ConnectionManager =  
    class
        inherit ConnectionSettings
    end
public abstract class ConnectionManager extends ConnectionSettings
ConnectionManager 类型公开以下成员。
属性
| 名称 | 说明 | |
|---|---|---|
![]()  | 
ApplicationName | Gets or sets the name of the application that has established the connection with the server. (从 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. (从 ConnectionSettings 继承。) | 
![]()  | 
ConnectAsUserName | Gets or sets the name of the user when connecting using impersonation. (从 ConnectionSettings 继承。) | 
![]()  | 
ConnectAsUserPassword | Gets or sets the password for the user when connecting using impersonation. (从 ConnectionSettings 继承。) | 
![]()  | 
ConnectionString | Gets or sets the connection string used to establish a connection with a specified data source. (从 ConnectionSettings 继承。) | 
![]()  | 
ConnectTimeout | Gets or sets the connection time-out period in seconds. (从 ConnectionSettings 继承。) | 
![]()  | 
DatabaseName | Gets or sets the database required by the connection. (从 ConnectionSettings 继承。) | 
![]()  | 
EncryptConnection | Gets or sets the Boolean property value that specifies whether the connection is encrypted. (从 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. (从 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. (从 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. (从 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. (从 ConnectionSettings 继承。) | 
![]()  | 
MultipleActiveResultSets | Gets or sets the Boolean property value that specifies whether more than one active result set is permitted. (从 ConnectionSettings 继承。) | 
![]()  | 
NetworkProtocol | Gets or sets the network protocol used to establish the connection to the server. (从 ConnectionSettings 继承。) | 
![]()  | 
NonPooledConnection | Gets or sets the Boolean property value that specifies whether the connection may be pooled or nonpooled. (从 ConnectionSettings 继承。) | 
![]()  | 
PacketSize | Gets or sets the packets of data sent between the client and the server over the network in bytes. (从 ConnectionSettings 继承。) | 
![]()  | 
Password | Gets or sets the password used with the logon to establish a connection with the server when SQL Server Authentication is used. (从 ConnectionSettings 继承。) | 
![]()  | 
PooledConnectionLifetime | Gets or sets the lifetime of the pooled connection. (从 ConnectionSettings 继承。) | 
![]()  | 
SecureConnectionString | Gets or sets an encrypted version of the connection string. (从 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. (从 ConnectionSettings 继承。) | 
![]()  | 
ServerInstance | Gets or sets the name of the server. (从 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. (从 ConnectionSettings 继承。) | 
页首
方法
| 名称 | 说明 | |
|---|---|---|
![]()  | 
CheckServerVersion | Checks the version of the target instance of SQL Server. | 
![]()  | 
Connect | Connects to the instance of SQL Server. | 
![]()  | 
Disconnect | Disconnects from the instance of SQL Server. | 
![]()  | 
Equals | (从 Object 继承。) | 
![]()  | 
Finalize | (从 Object 继承。) | 
![]()  | 
GetHashCode | (从 Object 继承。) | 
![]()  | 
GetType | (从 Object 继承。) | 
![]()  | 
MemberwiseClone | (从 Object 继承。) | 
![]()  | 
ThrowIfPropertyNotSet(String, String) | Throws an exception if the specified connection property is null or empty. (从 ConnectionSettings 继承。) | 
![]()  | 
ThrowIfPropertyNotSet(String, String, Boolean) | Throws an exception if the specified connection property is null or, optionally, empty. (从 ConnectionSettings 继承。) | 
![]()  | 
ToString | Returns the referenced object name as a string. (从 ConnectionSettings 继承。) | 
页首
事件
| 名称 | 说明 | |
|---|---|---|
![]()  | 
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 | The event that occurs when SQL Server returns a warning or informational message on the current connection. | 
![]()  | 
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. | 
页首
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。
.gif)
.gif)
.gif)
.gif)