Элементы ConnectionManager
The ConnectionManager class manages the connection to an instance of SQL Server.
Тип ConnectionManager предоставляет доступ к следующим элементам.
Методы
| Имя | Описание | |
|---|---|---|
.gif "Защищенный метод") |
CheckServerVersion | Checks the version of the target instance of SQL Server. |
.gif "Открытый метод") |
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.) |
В начало
Свойства
| Имя | Описание | |
|---|---|---|
.gif "Открытое свойство") |
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.) |
В начало
События
| Имя | Описание | |
|---|---|---|
.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 | 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. |
В начало
См. также