DBProviderInfos.Contains Method

Artikel
12/15/2008

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 (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public Function Contains ( _
    index As Object _
) As Boolean

public bool Contains (
    Object index
)

public:
bool Contains (
    Object^ index
)

public boolean Contains (
    Object index
)

public function Contains (
    index : Object
) : boolean

Parameter

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

Rückgabewert

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.

Beispiel

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

Threadsicherheit

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme