Exportar (0) Imprimir
Expandir Tudo
Expandir Minimizar

Namespace 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 Mecanismo de banco de dados do SQL Server. The most important class in this namespace is the ServerConnection class. The ServerConnection object lets you manage the connection to the instance of the Mecanismo de Banco de Dados. 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.

  ClasseDescrição
Classe públicaCapturedSqlThe 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.
Classe públicaChangePasswordFailureExceptionThe 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.
Classe públicaConnectionCannotBeChangedExceptionThe 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.
Classe públicaConnectionExceptionThe ConnectionException class is an exception that is raised when an error occurs on the connection to the instance of SQL Server.
Classe públicaConnectionFailureExceptionThe ConnectionFailureException class is an exception that is raised when an unsuccessful attempt is made to establish a connection with the instance of SQL Server.
Classe públicaConnectionInfoBaseThe 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.
Classe públicaConnectionManagerThe ConnectionManager class manages the connection to an instance of SQL Server.
Classe públicaConnectionSettingsThe 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.
Classe públicaDataTransferEventArgsThe DataTransferEventArgs class represents the arguments used when a data transfer event is raised.
Classe públicaDataTransferProgressEventArgsThe DataTransferProgressEventArgs class represents the arguments used when a data transfer progress event is raised.
Classe públicaDisconnectedConnectionExceptionThe DisconnectedConnectionException class is an exception that is raised when a connection is closed.
Classe públicaExecutionFailureExceptionThe ExecutionFailureException class is an exception that is raised when an execution failure is encountered on the connection to the server.
Classe públicaInvalidArgumentExceptionA exceção gerada quando um parâmetro que não é válido é passado a um método na conexão referenciada com o servidor.
Classe públicaInvalidPropertyValueExceptionThe exception that is raised when a property is set to a value that is not valid on the referenced connection to the server.
Classe públicaNotInTransactionExceptionThe exception that is raised when an error occurs within a transaction on the referenced connection to the server.
Classe públicaOlapConnectionInfoThis class supports the SMO infrastructure and is not intended to be used directly from your code.
Classe públicaPropertyNotAvailableExceptionThe exception that is raised when an unavailable property is requested on the connection to the server.
Classe públicaPropertyNotSetExceptionThe exception that is raised when a process requests a property that has not been set on the connection to the server.
Classe públicaServerComparerRepresents the comparer class.
Classe públicaServerConnectionThe ServerConnection object represents a connection to a server.
Classe públicaServerMessageEventArgsThe ServerMessageEventArgs class represents the arguments used when a server message event is raised.
Classe públicaServerVersionA classe ServerVersion representa as informações de versão para o servidor.
Classe públicaSqlConnectionInfoThe SqlConnectionInfo object represents information that is required to establish a connection to an instance of SQL Server.
Classe públicaSqlOlapConnectionInfoBaseThe SqlOlapConnectionInfoBase class represents information used to connect to the instance of SQL Server.
Classe públicaSqlServerManagementExceptionThe SqlServerManagementException class is an exception that is raised when a SQL Server management error is encountered on the connection to the server.
Classe públicaStatementEventArgsThe StatementEventArgs class represents the arguments used when a statement event is raised.
Classe públicaTransferExceptionThe TransferException class is an exception that is raised when a SQL Server transfer error is encountered on the connection to the server.

  InterfaceDescrição
Interface públicaIAlterableDefines a method to alter an object on the referenced connection.
Interface públicaICreatableDefines a method to create an object on the referenced connection.
Interface públicaIDataTransferProviderDefines methods and events for data transfers on the referenced connection.
Interface públicaIDroppableDefines a method to Drop an object on the referenced connection.
Interface públicaIMarkForDropDefines a method that marks an object to be dropped.
Interface públicaIRefreshableDefines a method to refresh an object from the server on the referenced connection.
Interface públicaIRenamableDefines the Rename method on the referenced connection.
Interface públicaIRestrictedAccessRepresents an interface that implements single-user access to the server for the referenced connection.
Interface públicaISfcConnectionDefines high-level properties and methods for server connections.
Interface públicaITransferMetadataProviderDefines methods that are required for transferring metadata on the referenced connection.

  DelegadoDescrição
Delegado públicoDataTransferEventHandlerA classe DataTransferEventHandler representa o método que trata o evento gerado pelo processo de transferência de dados.
Delegado públicoDataTransferProgressEventHandlerRepresenta o método que trata eventos gerados pelo processo de relatório de progresso da transferência de dados.
Delegado públicoServerMessageEventHandlerThe ServerMessageEventHandler class represents the method that handles the event raised by a server message.
Delegado públicoStatementEventHandlerThe StatementEventHandler class represents the method that handles the event raised by a statement.

  EnumeraçãoDescrição
Enumeração públicaAutoDisconnectModeContains values that are used to specify the automatic disconnection options for a connection to an instance of SQL Server.
Enumeração protegidaConnectionManager..::..ExecuteTSqlActionExecute a Transact-SQL action.
Enumeração públicaConnectionTypeThe ConnectionType enumeration contains values that are used to specify the type of server with which the connection is established.
Enumeração públicaDatabaseEngineTypeDatabase engine type of stand-alone instance of SQL Server or SQL Azure Database.
Enumeração públicaDataTransferEventTypeThe DataTransferEventType enumeration contains values that are used to specify the type of data transfer event.
Enumeração públicaDataTransferProgressEventTypeThe DataTransferProgressEventType enumeration contains values that are used to specify the type of data transfer progress event.
Enumeração públicaDeferredUseModeThe DeferredUseMode enumeration contains values that specify how that deferred use can be instructed to handle Transact-SQL statements on the server connection. 
Enumeração públicaExecutionTypesThe ExecutionTypes enumeration contains values that are used to specify execution options for the Transact-SQL commands sent to the server using the referenced connection.
Enumeração públicaFixedServerRolesThe FixedServerRoles enumeration contains values that are used to specify fixed server roles that can be assigned to logons.
Enumeração públicaNetworkProtocolContains values that are used to specify network protocols used on the network where the referenced connection is established.
Enumeração públicaQueryParameterizationModeA enumeração QueryParameterizationMode contém valores usados para especificar a maneira como as consultas com parâmetros são tratadas pela conexão de servidor.
Enumeração públicaServerCaseSensitivityContains values that are used to specify whether the server is sensitive to the case (lower or upper) of text.
Enumeração públicaServerTypeA enumeração ServerType contém valores que especificam tipos diferentes de serviços do SQL Server.
Enumeração públicaServerUserProfilesA enumeração ServerUserProfiles contém valores usados para especificar perfis do usuário no servidor.
Enumeração públicaSqlExecutionModesThe 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.

Contribuições da comunidade

ADICIONAR
Mostrar:
© 2014 Microsoft