共用方式為


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.

繼承階層

System. . :: . .Object
  Microsoft.SqlServer.Management.Common..::..ConnectionSettings
    Microsoft.SqlServer.Management.Common. . :: . .ConnectionManager

命名空間:  Microsoft.SqlServer.Management.Common
組件:  Microsoft.SqlServer.ConnectionInfo (在 Microsoft.SqlServer.ConnectionInfo.dll 中)

語法

'宣告
Public Class ConnectionSettings
'用途
Dim instance As ConnectionSettings
public class ConnectionSettings
public ref class ConnectionSettings
type ConnectionSettings =  class end
public class ConnectionSettings

ConnectionSettings 型別公開下列成員。

屬性

  名稱 說明
公用屬性 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.

上層

方法

  名稱 說明
公用方法 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.
受保護的方法 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. (覆寫 Object. . :: . .ToString() () () ()。)

上層

欄位

  名稱 說明
公用欄位靜態成員 NoConnectionTimeout Gets or sets the Int32 value that specifies the time the connection takes to time out in seconds.

上層

備註

Thread Safety

此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。不保證所有執行個體成員都是安全執行緒。

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。