DBProviderInfos.Contains(Object) Method

Definition

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Returns a Boolean that indicates if the items in the collection can be accessed using indexing without throwing an exception.

public:
 bool Contains(System::Object ^ index);

public bool Contains (object index);

member this.Contains : obj -> bool

Public Function Contains (index As Object) As Boolean

Parameters

index

Object

An object containing the name, description, or index of the object.

Returns

Boolean

A Boolean that indicates if the collection can be accessed by name, description, or index passed as the index parameter. A value of true indicates that the collection can be accessed using the syntax DBProviderInfos[index]. A value of false indicates that indexing cannot be used to retrieve items from the DBProviderInfos collection.

Examples

The following code sample uses Contains method to print the name of the first item in the collection. The method returns a Boolean.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace DBProvInfos_GetEnum  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Application app = new Application();  
            DBProviderInfos dbprovInfos = app.DBProviderInfos;  

            // Search for the MediaCatalogDB provider in the collection  
            if (dbprovInfos.Contains(0))  
                Console.WriteLine("The collection contains {0} provider", dbprovInfos[0].Name);  
            else  
                Console.WriteLine("The collection does not contain {0} provider", dbprovInfos[0].Name);  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace DBProvInfos_GetEnum  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim app As Application =  New Application()   
            Dim dbprovInfos As DBProviderInfos =  app.DBProviderInfos   

            ' Search for the MediaCatalogDB provider in the collection  
            If dbprovInfos.Contains(0) Then  
                Console.WriteLine("The collection contains {0} provider", dbprovInfos(0).Name)  
            Else   
                Console.WriteLine("The collection does not contain {0} provider", dbprovInfos(0).Name)  
            End If  
        End Sub  
    End Class  
End Namespace  

Sample Output:

The collection contains MediaCatalogDB OLE DB Provider provider