Classe ConnectionSettings
The ConnectionSettings class represents the settings used by a connection to an instance of a server, such as SQL Server. The ServerConnection class inherits ConnectionSettings class.
Gerarchia di ereditarietà
Object
Microsoft.SqlServer.Management.Common.ConnectionSettings
Microsoft.SqlServer.Management.Common.ConnectionManager
Spazio dei nomi Microsoft.SqlServer.Management.Common
Assembly: Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)
Sintassi
'Dichiarazione
Public Class ConnectionSettings
'Utilizzo
Dim instance As ConnectionSettings
public class ConnectionSettings
public ref class ConnectionSettings
type ConnectionSettings = class end
public class ConnectionSettings
Nel tipo ConnectionSettings sono esposti i membri seguenti.
Proprietà
Nome | Descrizione | |
---|---|---|
ApplicationName | Gets or sets the name of the application that has established the connection with the server. | |
ConnectAsUser | Gets or sets the Boolean property value that specifies whether the connection is established using impersonation. | |
ConnectAsUserName | Gets or sets the name of the user when connecting using impersonation. | |
ConnectAsUserPassword | Gets or sets the password for the user when connecting using impersonation. | |
ConnectionString | Gets or sets the connection string used to establish a connection with a specified data source. | |
ConnectTimeout | Gets or sets the connection time-out period in seconds. | |
DatabaseName | Gets or sets the database required by the connection. | |
EncryptConnection | Gets or sets the Boolean property value that specifies whether the connection is encrypted. | |
Login | Gets or sets the logon required to establish a connection with the instance of the server. | |
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. | |
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. | |
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. | |
MultipleActiveResultSets | Gets or sets the Boolean property value that specifies whether more than one active result set is permitted. | |
NetworkProtocol | Gets or sets the network protocol used to establish the connection to the server. | |
NonPooledConnection | Gets or sets the Boolean property value that specifies whether the connection may be pooled or nonpooled. | |
PacketSize | Gets or sets the packets of data sent between the client and the server over the network in bytes. | |
Password | Gets or sets the password used with the logon to establish a connection with the server when SQL Server Authentication is used. | |
PooledConnectionLifetime | Gets or sets the lifetime of the pooled connection. | |
ResetConnectionString | Gets or sets a Boolean value that specifies whether a node in the connection string has been changed. | |
SecureConnectionString | Gets or sets an encrypted version of the connection string. | |
SecurePassword | Gets or sets the secure password used with the logon to establish a connection with the server when SQL Server Authentication is used. | |
ServerInstance | Gets or sets the name of the server. | |
WorkstationId | Gets or sets the ID value that uniquely identifies the workstation. |
Torna all'inizio
Metodi
Nome | Descrizione | |
---|---|---|
Equals | Ereditato da Object. | |
Finalize | Ereditato da Object. | |
GetHashCode | Ereditato da Object. | |
GetType | Ereditato da Object. | |
MemberwiseClone | Ereditato da Object. | |
ThrowIfPropertyNotSet(String, String) | Throws an exception if the specified connection property is null or empty. | |
ThrowIfPropertyNotSet(String, String, Boolean) | Throws an exception if the specified connection property is null or, optionally, empty. | |
ToString | Returns the referenced object name as a string. Esegue l'override di ObjectToString. |
Torna all'inizio
Campi
Nome | Descrizione | |
---|---|---|
NoConnectionTimeout | Gets or sets the Int32 value that specifies the time the connection takes to time out in seconds. |
Torna all'inizio
Osservazioni
Thread Safety
Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.
Protezione dei thread
I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.