DBProviderInfos.Contains Method
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
'Usage
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
Parameters
- index
Type: System.Object
An object containing the name, description, or index of the object.
Return Value
Type: 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.
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