Condividi tramite


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à

System. . :: . .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
Proprietà pubblica ApplicationName Gets or sets the name of the application that has established the connection with the server.
Proprietà pubblica ConnectAsUser Gets or sets the Boolean property value that specifies whether the connection is established using impersonation.
Proprietà pubblica ConnectAsUserName Gets or sets the name of the user when connecting using impersonation.
Proprietà pubblica ConnectAsUserPassword Gets or sets the password for the user when connecting using impersonation.
Proprietà pubblica ConnectionString Gets or sets the connection string used to establish a connection with a specified data source.
Proprietà pubblica ConnectTimeout Gets or sets the connection time-out period in seconds.
Proprietà pubblica DatabaseName Gets or sets the database required by the connection.
Proprietà pubblica EncryptConnection Gets or sets the Boolean property value that specifies whether the connection is encrypted.
Proprietà pubblica Login Gets or sets the logon required to establish a connection with the instance of the server.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica MultipleActiveResultSets Gets or sets the Boolean property value that specifies whether more than one active result set is permitted.
Proprietà pubblica NetworkProtocol Gets or sets the network protocol used to establish the connection to the server.
Proprietà pubblica NonPooledConnection Gets or sets the Boolean property value that specifies whether the connection may be pooled or nonpooled.
Proprietà pubblica PacketSize Gets or sets the packets of data sent between the client and the server over the network in bytes.
Proprietà pubblica Password Gets or sets the password used with the logon to establish a connection with the server when SQL Server Authentication is used.
Proprietà pubblica PooledConnectionLifetime Gets or sets the lifetime of the pooled connection.
Proprietà protetta ResetConnectionString Gets or sets a Boolean value that specifies whether a node in the connection string has been changed.
Proprietà pubblica SecureConnectionString Gets or sets an encrypted version of the connection string.
Proprietà pubblica SecurePassword Gets or sets the secure password used with the logon to establish a connection with the server when SQL Server Authentication is used.
Proprietà pubblica ServerInstance Gets or sets the name of the server.
Proprietà pubblica WorkstationId Gets or sets the ID value that uniquely identifies the workstation.

In alto

Metodi

  Nome Descrizione
Metodo pubblico Equals Ereditato da Object.
Metodo protetto Finalize Ereditato da Object.
Metodo pubblico GetHashCode Ereditato da Object.
Metodo pubblico GetType Ereditato da Object.
Metodo protetto MemberwiseClone Ereditato da Object.
Metodo protetto ThrowIfPropertyNotSet(String, String) Throws an exception if the specified connection property is null or empty.
Metodo protetto ThrowIfPropertyNotSet(String, String, Boolean) Throws an exception if the specified connection property is null or, optionally, empty.
Metodo pubblico ToString Returns the referenced object name as a string. Esegue l'override di Object. . :: . .ToString() () () ().

In alto

Campi

  Nome Descrizione
Campo pubblicoMembro statico NoConnectionTimeout Gets or sets the Int32 value that specifies the time the connection takes to time out in seconds.

In alto

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.