共用方式為


Microsoft.SqlServer.Management.Common 命名空間

The [Microsoft.SqlServer.Management.Common] namespace contains classes that provide connection functionality to the other SQL Server management namespaces.

The Microsoft.SqlServer.Management.Common namespace contains the classes that are used to establish a connection to an instance of SQL Server Database Engine. The most important class in this namespace is the ServerConnection class. The ServerConnection object lets you manage the connection to the instance of the Database Engine. It is referenced by various classes in the other manageability namespaces.

The Microsoft.SqlServer.Management.Common namespace resides in the Microsoft.SqlServer.ConnectionInfo.dll assembly file.

By using the Microsoft.SqlServer.Management.Common namespace, you can do the following:

  • Connect to an instance of SQL Server.

  • Control the connection settings.

  • Run Transact-SQL statements directly.

  • Capture the Transact-SQL statements that are generated by the SMO program.

  • Manage transactions.

類別

  類別 說明
公用類別 CapturedSql The CapturedSql class represents the Transact-SQL commands that are sent to the instance of SQL Server by way of the referenced connection. However, they are then redirected to a buffer instead of running immediately on the instance of SQL Server.
公用類別 ChangePasswordFailureException The ChangePasswordFailureException class is an exception that is raised when an unsuccessful attempt is made to change the password of the login that establishes a connection with the instance of SQL Server by using SQL Server Authentication.
公用類別 ConnectionCannotBeChangedException The ConnectionCannotBeChangedException class is an exception that is raised when an unsuccessful attempt is made to change the connection to the instance of Microsoft SQL Server.
公用類別 ConnectionException The ConnectionException class is an exception that is raised when an error occurs on the connection to the instance of SQL Server.
公用類別 ConnectionFailureException The ConnectionFailureException class is an exception that is raised when an unsuccessful attempt is made to establish a connection with the instance of SQL Server.
公用類別 ConnectionInfoBase The ConnectionInfoBase object is a base class that is used in the construction of the SqlOlapConnectionInfoBase class and it represents information used to connect to an instance of SQL Server.
公用類別 ConnectionManager The ConnectionManager class manages the connection to an instance of SQL Server.
公用類別 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.
公用類別 DataTransferEventArgs The DataTransferEventArgs class represents the arguments used when a data transfer event is raised.
公用類別 DataTransferProgressEventArgs The DataTransferProgressEventArgs class represents the arguments used when a data transfer progress event is raised.
公用類別 DisconnectedConnectionException The DisconnectedConnectionException class is an exception that is raised when a connection is closed.
公用類別 ExecutionFailureException The ExecutionFailureException class is an exception that is raised when an execution failure is encountered on the connection to the server.
公用類別 InvalidArgumentException 將無效的參數傳遞至參考的伺服器連接上的方法時所引發的例外狀況。
公用類別 InvalidPropertyValueException The exception that is raised when a property is set to a value that is not valid on the referenced connection to the server.
公用類別 NotInTransactionException The exception that is raised when an error occurs within a transaction on the referenced connection to the server.
公用類別 OlapConnectionInfo This class supports the SMO infrastructure and is not intended to be used directly from your code.
公用類別 PropertyNotAvailableException The exception that is raised when an unavailable property is requested on the connection to the server.
公用類別 PropertyNotSetException The exception that is raised when a process requests a property that has not been set on the connection to the server.
公用類別 ServerComparer Represents the comparer class.
公用類別 ServerConnection The ServerConnection object represents a connection to a server.
公用類別 ServerMessageEventArgs The ServerMessageEventArgs class represents the arguments used when a server message event is raised.
公用類別 ServerVersion ServerVersion 類別代表伺服器的版本資訊。
公用類別 SqlConnectionInfo The SqlConnectionInfo object represents information that is required to establish a connection to an instance of SQL Server.
公用類別 SqlOlapConnectionInfoBase The SqlOlapConnectionInfoBase class represents information used to connect to the instance of SQL Server.
公用類別 SqlServerManagementException The SqlServerManagementException class is an exception that is raised when a SQL Server management error is encountered on the connection to the server.
公用類別 StatementEventArgs The StatementEventArgs class represents the arguments used when a statement event is raised.
公用類別 TransferException The TransferException class is an exception that is raised when a SQL Server transfer error is encountered on the connection to the server.

介面

  介面 說明
公用介面 IAlterable Defines a method to alter an object on the referenced connection.
公用介面 ICreatable Defines a method to create an object on the referenced connection.
公用介面 IDataTransferProvider Defines methods and events for data transfers on the referenced connection.
公用介面 IDroppable Defines a method to Drop an object on the referenced connection.
公用介面 IMarkForDrop Defines a method that marks an object to be dropped.
公用介面 IRefreshable Defines a method to refresh an object from the server on the referenced connection.
公用介面 IRenamable Defines the Rename method on the referenced connection.
公用介面 IRestrictedAccess Represents an interface that implements single-user access to the server for the referenced connection.
公用介面 ISfcConnection Defines high-level properties and methods for server connections.
公用介面 ITransferMetadataProvider Defines methods that are required for transferring metadata on the referenced connection.

委派

  委派 說明
公用委派 DataTransferEventHandler DataTransferEventHandler 類別代表負責處理資料傳輸程序引發之事件的方法。
公用委派 DataTransferProgressEventHandler 代表負責處理資料傳輸進度報告程序引發之事件的方法。
公用委派 ServerMessageEventHandler The ServerMessageEventHandler class represents the method that handles the event raised by a server message.
公用委派 StatementEventHandler The StatementEventHandler class represents the method that handles the event raised by a statement.

列舉

  列舉 說明
公用列舉 AutoDisconnectMode Contains values that are used to specify the automatic disconnection options for a connection to an instance of SQL Server.
受保護的列舉型別 ConnectionManager. . :: . .ExecuteTSqlAction Execute a Transact-SQL action.
公用列舉 ConnectionType The ConnectionType enumeration contains values that are used to specify the type of server with which the connection is established.
公用列舉 DatabaseEngineType Database engine type of stand-alone instance of SQL Server or SQL Azure Database.
公用列舉 DataTransferEventType The DataTransferEventType enumeration contains values that are used to specify the type of data transfer event.
公用列舉 DataTransferProgressEventType The DataTransferProgressEventType enumeration contains values that are used to specify the type of data transfer progress event.
公用列舉 DeferredUseMode The DeferredUseMode enumeration contains values that specify how that deferred use can be instructed to handle Transact-SQL statements on the server connection. 
公用列舉 ExecutionTypes The ExecutionTypes enumeration contains values that are used to specify execution options for the Transact-SQL commands sent to the server using the referenced connection.
公用列舉 FixedServerRoles The FixedServerRoles enumeration contains values that are used to specify fixed server roles that can be assigned to logons.
公用列舉 NetworkProtocol Contains values that are used to specify network protocols used on the network where the referenced connection is established.
公用列舉 QueryParameterizationMode QueryParameterizationMode 列舉包含值,這些值可用來指定伺服器連接處理具有參數之查詢的方式。
公用列舉 ServerCaseSensitivity Contains values that are used to specify whether the server is sensitive to the case (lower or upper) of text.
公用列舉 ServerType ServerType 列舉包含指定不同 SQL Server 服務類型的值。
公用列舉 ServerUserProfiles ServerUserProfiles 列舉包含用來指定伺服器上使用者設定檔的值。
公用列舉 SqlExecutionModes The SqlExecutionModes enumeration contains values that are used to specify whether the commands sent to the referenced connection to the server are executed immediately or saved in a buffer.