Condividi tramite


Classe ConnectionManager

Provides the information that you must have to connect to a data source. All classes that inherit from the ConnectionManager contain the same properties and methods. The ConnectionManager class isolates the implementation details of the different connection types from the runtime. This enables the runtime to interact with each connection manager in a consistent and predictable manner. Connection managers contain a set of stock properties that all connections have in common, such as the Name, ID, Description, and ConnectionString. However, each connection type has additional properties that are specific to that connection type. These can be accessed through the Properties collection.This class cannot be inherited.

Gerarchia di ereditarietà

System. . :: . .Object
  Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
    Microsoft.SqlServer.Dts.Runtime..::..ConnectionManager

Spazio dei nomi  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Sintassi

'Dichiarazione
Public NotInheritable Class ConnectionManager _
    Inherits DtsObject _
    Implements IDTSObjectHost, IDTSPersist, IDTSName, IComponent,  _
    IDisposable, IDTSPropertiesProvider, IDTSPackagePath
'Utilizzo
Dim instance As ConnectionManager
public sealed class ConnectionManager : DtsObject, 
    IDTSObjectHost, IDTSPersist, IDTSName, IComponent, IDisposable, 
    IDTSPropertiesProvider, IDTSPackagePath
public ref class ConnectionManager sealed : public DtsObject, 
    IDTSObjectHost, IDTSPersist, IDTSName, IComponent, IDisposable, 
    IDTSPropertiesProvider, IDTSPackagePath
[<SealedAttribute>]
type ConnectionManager =  
    class
        inherit DtsObject
        interface IDTSObjectHost
        interface IDTSPersist
        interface IDTSName
        interface IComponent
        interface IDisposable
        interface IDTSPropertiesProvider
        interface IDTSPackagePath
    end
public final class ConnectionManager extends DtsObject implements IDTSObjectHost, IDTSPersist, IDTSName, IComponent, IDisposable, IDTSPropertiesProvider, IDTSPackagePath

Nel tipo ConnectionManager sono esposti i membri seguenti.

Proprietà

  Nome Descrizione
Proprietà pubblica ConnectionString Gets or sets the connection string used to establish a connection to a data source.
Proprietà pubblica CreationName Returns the string that is used by the runtime to create an instance of the ConnectionManager object and to add the object to the Connections collection. This property is read-only.
Proprietà pubblica DelayValidation Gets or sets a Boolean that indicates whether package validation is delayed until the package runs.
Proprietà pubblica Description Gets or sets the description of the ConnectionManager object.
Proprietà pubblica HostType Gets an enumeration that describes the type of host that the connection is being used by. This property is read-only.
Proprietà pubblica ID Gets the ID of the ConnectionManager. This property is read-only.
Proprietà pubblica InnerObject Returns the specific connection type that was created. This property is read-only.
Proprietà pubblica Name Gets or sets the name of the ConnectionManager object.
Proprietà pubblica Properties Gets a collection of property objects for the ConnectionManager. This is the method of accessing the properties of the specific connection that is being hosted by the connection manager. This property is read-only.
Proprietà pubblica ProtectionLevel Gets or sets the level of encryption performed on sensitive data that is contained in the package.
Proprietà pubblica Site Infrastruttura.
Proprietà pubblica SupportsDTCTransactions Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions.

In alto

Metodi

  Nome Descrizione
Metodo pubblico AcquireConnection Creates an instance of the connection type.
Metodo pubblico Dispose Releases the resources used by the ConnectionManager.
Metodo pubblico Equals Determines whether two object instances are equal. Ereditato da DtsObject.
Metodo protetto Finalize Ereditato da Object.
Metodo pubblico GetExpression Returns a String that contains the expression for the specified property. Null means that no expression has been assigned.
Metodo pubblico GetHashCode Returns the hash code for this instance. Ereditato da DtsObject.
Metodo pubblico GetPackagePath Gets or sets the path of the package that the connection applies to.
Metodo pubblico GetType Ereditato da Object.
Metodo pubblico LoadFromXML This method is not callable by your application code. To load a package that has been saved as .xml, use the Application..::..LoadPackage method.
Metodo protetto MemberwiseClone Ereditato da Object.
Metodo pubblico ReleaseConnection Frees the connection established during AcquireConnection. Called at design time and runtime.
Metodo pubblico SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application..::..SaveToXml method.
Metodo pubblico SetExpression Assigns the specified expression to the property. Specify nullNothingnullptrunitriferimento Null (Nothing in Visual Basic). to remove an existing expression from the property.
Metodo pubblico SetQualifier Changes a qualifier on the connection manager after the connection manager has been created but before it is used in a running package.
Metodo pubblico ToString Ereditato da Object.

In alto

Eventi

  Nome Descrizione
Evento pubblico Disposed Adds an event handler to listen to the Disposed event on the ConnectionManager.

In alto

Osservazioni

A connection manager is a logical representation of a connection. At design time, in the graphical user interface, you use a connection manager to describe the physical connection that the runtime creates when the package runs. Integration Services provides different types of connection managers that enable packages to connect to a variety of data sources. For example, there is an ActiveX Data Objects (ADO) connection manager, an ADO.NET connection manager, an ODBC connection manager, and so on. For more information, see Extending Packages with Custom Objects.

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.