ExtendedProperties.Contains Method

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

네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

구문

‘선언
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

매개 변수

• index
  The name, identity, ID, or index to locate in the collection.

반환 값

A Boolean that indicates whether the collection can be accessed by name, description, ID, or index. A value of true indicates that the collection can be accessed by using the syntax ExtendedProperties[index]. A value of false indicates that indexing cannot be used to retrieve items from the ExtendedProperties collection; using this property throws an exception.

예

The following code sample uses Contains method to determine if an extended property with the GUID given is in the collection. The method returns a Boolean.

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

namespace ExtendedProperties_Testing
{
    class Program
    {
        static void Main(string[] args)
        {
            // The package is one of the SSIS samples.
            string mySample = @"C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";
            // Create the application, and load the sample.
            Application app = new Application();
            Package pkg = app.LoadPackage(mySample, null);

            // Get the extended properties collection from the package.
            ExtendedProperties myExtProps = pkg.ExtendedProperties;

            // Use the ID.
            Boolean hasGUID = myExtProps.Contains("{F3B7314E-DB1E-4CCA-A856-2E617A1B3265}");
            Console.WriteLine("The extended property contains that GUID? {0}", hasGUID);
            Console.WriteLine();
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace ExtendedProperties_Testing
    Class Program
        Shared  Sub Main(ByVal args() As String)
            ' The package is one of the SSIS samples.
            Dim mySample As String =  "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx" 
            ' Create the application, and load the sample.
            Dim app As Application =  New Application() 
            Dim pkg As Package =  app.LoadPackage(mySample,Nothing) 
 
            ' Get the extended properties collection from the package.
            Dim myExtProps As ExtendedProperties =  pkg.ExtendedProperties 
 
            ' Use the ID.
            Dim hasGUID As Boolean =  myExtProps.Contains("{F3B7314E-DB1E-4CCA-A856-2E617A1B3265}") 
            Console.WriteLine("The extended property contains that GUID? {0}", hasGUID)
            Console.WriteLine()
        End Sub
    End Class
End Namespace

Sample Output:

The extended property contains that GUID? True

스레드 보안

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.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

ExtendedProperties Class
ExtendedProperties Members
Microsoft.SqlServer.Dts.Runtime Namespace