Compartilhar via


Método DBProviderInfos.Contains

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

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (em Microsoft.SqlServer.ManagedDTS.dll)

Sintaxe

'Declaração
Public Function Contains ( _
    index As Object _
) As Boolean
'Uso
Dim instance As DBProviderInfos 
Dim index As Object 
Dim returnValue As Boolean 

returnValue = instance.Contains(index)
public bool Contains(
    Object index
)
public:
bool Contains(
    Object^ index
)
member Contains : 
        index:Object -> bool
public function Contains(
    index : Object
) : boolean

Parâmetros

  • index
    Tipo: System.Object
    An object containing the name, description, or index of the object.

Valor de retorno

Tipo: System.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.

Exemplos

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

Consulte também

Referência

DBProviderInfos Classe

Namespace Microsoft.SqlServer.Dts.Runtime