Edit

Share via

OracleConnectionStringBuilder.ContainsKey(String) Method

  • Reference

Definition

Namespace:
System.Data.OracleClient
Assembly:
System.Data.OracleClient.dll

Determines whether the OracleConnectionStringBuilder contains a specific key.

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

Parameters

keyword
String

The key to locate in the OracleConnectionStringBuilder.

Returns

Boolean

true if the OracleConnectionStringBuilder contains an element that has the specified key; otherwise, false.

Exceptions

ArgumentNullException

keyword is null (Nothing in Visual Basic)

Examples

The following example creates an OracleConnectionStringBuilder instance, sets some of its properties, and then tries to determine whether various keys exist within the object by calling the ContainsKey method.

OracleConnectionStringBuilder builder =
    new(GetConnectionString());
Console.WriteLine($"Connection string = '{builder.ConnectionString}'");

// Keys you've provided return true.
Console.WriteLine(builder.ContainsKey("Integrated Security"));

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

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

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

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

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

    ' Keys that don't 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=OracleDemo;Integrated Security=True"
End Function

Remarks

Because the OracleConnectionStringBuilder contains a fixed-size collection of key/value pairs, the ContainsKey method determines only if a particular key name is valid.

Applies to

See also