Classe ConnectionManager
The ConnectionManager class manages the connection to an instance of SQL Server.
Hierarquia de herança
System. . :: . .Object
Microsoft.SqlServer.Management.Common. . :: . .ConnectionSettings
Microsoft.SqlServer.Management.Common..::..ConnectionManager
Microsoft.SqlServer.Management.Common. . :: . .ServerConnection
Namespace: Microsoft.SqlServer.Management.Common
Assembly: Microsoft.SqlServer.ConnectionInfo (em Microsoft.SqlServer.ConnectionInfo.dll)
Sintaxe
'Declaração
Public MustInherit Class ConnectionManager _
Inherits ConnectionSettings
'Uso
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
O tipo ConnectionManager expõe os membros a seguir.
Propriedades
Nome | Descrição | |
---|---|---|
ApplicationName | Gets or sets the name of the application that has established the connection with the server. (Herdado de 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. (Herdado de ConnectionSettings.) | |
ConnectAsUserName | Gets or sets the name of the user when connecting using impersonation. (Herdado de ConnectionSettings.) | |
ConnectAsUserPassword | Gets or sets the password for the user when connecting using impersonation. (Herdado de ConnectionSettings.) | |
ConnectionString | Gets or sets the connection string used to establish a connection with a specified data source. (Herdado de ConnectionSettings.) | |
ConnectTimeout | Gets or sets the connection time-out period in seconds. (Herdado de ConnectionSettings.) | |
DatabaseEngineType | Gets the database engine type. | |
DatabaseName | Gets or sets the database required by the connection. (Herdado de ConnectionSettings.) | |
EncryptConnection | Gets or sets the Boolean property value that specifies whether the connection is encrypted. (Herdado de ConnectionSettings.) | |
InUse | Gets or sets the Boolean property value that specifies whether the connection is being used. | |
IsForceDisconnected | Gets a Boolean value that specifies whether the connection was forcibly disconnected. | |
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. (Herdado de 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. (Herdado de 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. (Herdado de 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. (Herdado de ConnectionSettings.) | |
MultipleActiveResultSets | Gets or sets the Boolean property value that specifies whether more than one active result set is permitted. (Herdado de ConnectionSettings.) | |
NetworkProtocol | Gets or sets the network protocol used to establish the connection to the server. (Herdado de ConnectionSettings.) | |
NonPooledConnection | Gets or sets the Boolean property value that specifies whether the connection may be pooled or nonpooled. (Herdado de ConnectionSettings.) | |
PacketSize | Gets or sets the packets of data sent between the client and the server over the network in bytes. (Herdado de ConnectionSettings.) | |
Password | Gets or sets the password used with the logon to establish a connection with the server when SQL Server Authentication is used. (Herdado de ConnectionSettings.) | |
PooledConnectionLifetime | Gets or sets the lifetime of the pooled connection. (Herdado de ConnectionSettings.) | |
ResetConnectionString | Gets or sets a Boolean value that specifies whether a node in the connection string has been changed. (Herdado de ConnectionSettings.) | |
SecureConnectionString | Gets or sets an encrypted version of the connection string. (Herdado de 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. (Herdado de ConnectionSettings.) | |
ServerInstance | Gets or sets the name of the server. (Herdado de 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. (Herdado de ConnectionSettings.) |
Início
Métodos
Nome | Descrição | |
---|---|---|
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 | (Herdado de Object.) | |
ExecuteTSql | Executes a Transact-SQL command. | |
Finalize | (Herdado de Object.) | |
ForceDisconnected | Forces a disconnect from the instance of SQL Server. | |
GetHashCode | (Herdado de Object.) | |
GetType | (Herdado de Object.) | |
MemberwiseClone | (Herdado de Object.) | |
ThrowIfPropertyNotSet(String, String) | Throws an exception if the specified connection property is null or empty. (Herdado de ConnectionSettings.) | |
ThrowIfPropertyNotSet(String, String, Boolean) | Throws an exception if the specified connection property is null or, optionally, empty. (Herdado de ConnectionSettings.) | |
ToString | Returns the referenced object name as a string. (Herdado de ConnectionSettings.) |
Início
Eventos
Nome | Descrição | |
---|---|---|
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. |
Início
Segurança de thread
Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.