Partilhar via


ConnectionManager Members

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.

The following tables list the members exposed by the ConnectionManager type.

Public Properties

  Name Description
ms211905.pubproperty(en-US,SQL.90).gif ConnectionString Gets or sets the connection string used to establish a connection to a data source.
ms211905.pubproperty(en-US,SQL.90).gif 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.
ms211905.pubproperty(en-US,SQL.90).gif DelayValidation Gets or sets a Boolean that indicates whether package validation is delayed until the package runs.
ms211905.pubproperty(en-US,SQL.90).gif Description Gets or sets the description of the ConnectionManager object.
ms211905.pubproperty(en-US,SQL.90).gif HostType Gets an enumeration that describes the type of host that the connection is being used by. This property is read-only.
ms211905.pubproperty(en-US,SQL.90).gif ID Gets the ID of the ConnectionManager. This property is read-only.
ms211905.pubproperty(en-US,SQL.90).gif InnerObject Returns the specific connection type that was created. This property is read-only.
ms211905.pubproperty(en-US,SQL.90).gif Name Gets or sets the name of the ConnectionManager object.
ms211905.pubproperty(en-US,SQL.90).gif 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.
ms211905.pubproperty(en-US,SQL.90).gif ProtectionLevel Gets or sets the level of encryption performed on sensitive data that is contained in the package.
ms211905.pubproperty(en-US,SQL.90).gif Site  
ms211905.pubproperty(en-US,SQL.90).gif SupportsDTCTransactions Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms211905.pubmethod(en-US,SQL.90).gif AcquireConnection Creates an instance of the connection type.
ms211905.pubmethod(en-US,SQL.90).gif Dispose Releases the resources used by the ConnectionManager.
ms211905.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms211905.pubmethod(en-US,SQL.90).gif GetExpression Returns a String that contains the expression for the specified property. Null means that no expression has been assigned.
ms211905.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms211905.pubmethod(en-US,SQL.90).gif GetPackagePath Gets or sets the path of the package that the connection applies to.
ms211905.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms211905.pubmethod(en-US,SQL.90).gif 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.
ms211905.pubmethod(en-US,SQL.90).gifms211905.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms211905.pubmethod(en-US,SQL.90).gifms211905.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms211905.pubmethod(en-US,SQL.90).gifms211905.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms211905.pubmethod(en-US,SQL.90).gif ReleaseConnection Frees the connection established during AcquireConnection. Called at design time and runtime.
ms211905.pubmethod(en-US,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms211905.pubmethod(en-US,SQL.90).gif SetExpression Assigns the specified expression to the property. Specify null to remove an existing expression from the property.
ms211905.pubmethod(en-US,SQL.90).gif SetQualifier Changes a qualifier on the connection manager after the connection manager has been created but before it is used in a running package.
ms211905.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms211905.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms211905.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

Public Events

  Name Description
ms211905.pubevent(en-US,SQL.90).gif Disposed Adds an event handler to listen to the Disposed event on the ConnectionManager.

Top

See Also

Reference

ConnectionManager Class
Microsoft.SqlServer.Dts.Runtime Namespace