Connections.Contains Method
Returns a Boolean that indicates whether the ConnectionManager items in the collection can be accessed by using indexing without throwing an exception.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Parameters
- index
- Type: System.Object
The name, description, ID, or index to locate in the collection.
Return Value
Type: System.Booleantrue if the collection can be accessed by using the syntax Connections[index]. If true, the collection can be accessed by name, description, or index. false if indexing cannot be used to retrieve items from the Connections collection.
The following code sample removes a newly-added ADO.NET connection manager from the collection. It then uses the Contains method to make sure that the connection manager is removed.
using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Dts.Runtime; namespace Connections_Collection { class Program { static void Main(string[] args) { // The package is one of the SSIS Samples. string mySample = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"; // Create an application and load the sample. Application app = new Application(); Package pkg = app.LoadPackage(mySample, null); Connections myConns = pkg.Connections; // Show how many connections are in the package. int myConnsCount = myConns.Count; Console.WriteLine("The number of connections is: {0}", myConnsCount); // Add an OLEDB connection manager. ConnectionManager myConn = pkg.Connections.Add("OLEDB"); myConn.Name = "My OLEDB ConnectionManager"; myConn.ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Auto Translate=False;"; // Verify the addition of one connection manager. myConnsCount = myConns.Count; Console.WriteLine("The number of connections now is: {0}", myConnsCount); // Write out the names of the connection managers. foreach (ConnectionManager myCMgrs in myConns) { Console.WriteLine("Name: {0}", myCMgrs.Name); Console.WriteLine("ID: {0}", myCMgrs.ID); Console.WriteLine("--------------------------------------------"); } // Remove the connection manager by name. pkg.Connections.Remove("My OLEDB ConnectionManager"); // Verify the removal of the connection manager. myConnsCount = myConns.Count; Console.WriteLine("The number of connections is finally: {0}", myConnsCount); // Using the Contains method, verify if the connection is in the collection. Boolean connRemoved = myConns.Contains("My OLEDB ConnectionManager"); Console.WriteLine("The connection is still in the collection? {0}", connRemoved); Console.WriteLine(); } } }
Sample Output:
The number of connections is: 3
The number of connections now is: 4
Name: Create_Execute_Process_Dest.sql
ID: {B52C0D78-5402-4544-BFEC-2BE203900C91}
--------------------------------------------
Name: customers
ID: {4F945623-B43F-470F-9D1E-D2A0B09177AE}
--------------------------------------------
Name: localhost.AdventureWorks
ID: {47179DDF-BD08-4E29-87C4-3A3D77105C2B}
--------------------------------------------
Name: My OLEDB ConnectionManager
ID: {90DF568E-ECB1-46D2-8DCB-3E2C67391E64}
--------------------------------------------
The number of connections is finally: 3
The connection is still in the collection? False