SqlConnectionStringBuilder.ContainsKey(String) 메서드

  • 참조

정의

네임스페이스:
System.Data.SqlClient
어셈블리:
System.Data.SqlClient.dll
어셈블리:
System.Data.dll
패키지:
System.Data.SqlClient v4.8.6

SqlConnectionStringBuilder에 특정 키가 들어 있는지 여부를 확인합니다.

public:
 override bool ContainsKey(System::String ^ keyword);
public override bool ContainsKey (string keyword);
override this.ContainsKey : string -> bool
Public Overrides Function ContainsKey (keyword As String) As Boolean

매개 변수

keyword
String

SqlConnectionStringBuilder에서 찾을 수 있는 키입니다.

반환

Boolean

SqlConnectionStringBuilder에 지정된 키가 있는 요소가 포함되어 있으면 true이고, 그렇지 않으면 false입니다.

예외

ArgumentNullException

keyword가 null(Visual Basic에서는 Nothing)입니다.

예제

다음 예제에서는 instance 만들고 SqlConnectionStringBuilder 일부 속성을 설정한 다음 ContainsKey 메서드를 호출하여 개체 내에 다양한 키가 있는지 여부를 확인합니다.

using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        SqlConnectionStringBuilder builder =
            new SqlConnectionStringBuilder(GetConnectionString());
        Console.WriteLine("Connection string = " + builder.ConnectionString);

        // Keys you have provided return true.
        Console.WriteLine(builder.ContainsKey("Server"));

        // Comparison is case insensitive, and synonyms
        // are automatically converted to their "well-known"
        // names.
        Console.WriteLine(builder.ContainsKey("Database"));

        // Keys that are valid but have not been set return true.
        Console.WriteLine(builder.ContainsKey("Max Pool Size"));

        // Keys that do not exist return false.
        Console.WriteLine(builder.ContainsKey("MyKey"));

        Console.WriteLine("Press Enter to continue.");
        Console.ReadLine();
    }

    private static string GetConnectionString()
    {
        // To avoid storing the connection string in your code,
        // you can retrieve it from a configuration file.
        return "Server=(local);Integrated Security=SSPI;" +
            "Initial Catalog=AdventureWorks";
    }
}

Imports System.Data.SqlClient

Module Module1
    Sub Main()
        Dim builder As _
         New SqlConnectionStringBuilder(GetConnectionString())
        Console.WriteLine("Connection string = " & builder.ConnectionString)

        ' Keys you have provided return true.
        Console.WriteLine(builder.ContainsKey("Server"))

        ' Comparison is case insensitive, and synonyms
        ' are automatically converted to their "well-known"
        ' names.
        Console.WriteLine(builder.ContainsKey("Database"))

        ' Keys that are valid but have not been set return true.
        Console.WriteLine(builder.ContainsKey("Max Pool Size"))

        ' Keys that do not exist return false.
        Console.WriteLine(builder.ContainsKey("MyKey"))

        Console.WriteLine("Press Enter to continue.")
        Console.ReadLine()
    End Sub

    Private Function GetConnectionString() As String
        ' To avoid storing the connection string in your code,
        ' you can retrieve it from a configuration file. 
        Return "Server=(local);Integrated Security=SSPI;" & _
          "Initial Catalog=AdventureWorks"
    End Function
End Module

이 예제에서는 콘솔 창에 다음 출력을 표시합니다.

Connection string = Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=True
True
True
True
False

설명

SqlConnectionStringBuilder에는 고정 크기의 키/값 쌍 컬렉션이 포함되어 있기 때문에 ContainsKey 메서드는 특정 키 이름이 올바른지 여부만 확인합니다.

적용 대상

추가 정보