Export (0) Print
Expand All

OracleConnectionStringBuilder.ContainsKey Method

Determines whether the OracleConnectionStringBuilder contains a specific key.

Namespace:  System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)

public override bool ContainsKey(
	string keyword
)

Parameters

keyword
Type: System.String
The key to locate in the OracleConnectionStringBuilder.

Return Value

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

ExceptionCondition
ArgumentNullException

keyword is null (Nothing in Visual Basic)

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

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.


// You may need to set a reference to the System.Data.OracleClient
// assembly before you can run this sample.
using System.Data.OracleClient;

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

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

        // Comparison is case insensitive, and synonyms for the 
        // keywords are translated to well-known names.
        // The following returns true because "PWD" is a 
        // synonym for "Password", a valid key.
        Console.WriteLine(builder.ContainsKey("PWD"));

        // 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"));

        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=OracleDemo;Integrated Security=True";
    }
}


.NET Framework

Supported in: 4, 3.5, 3.0, 2.0

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Community Additions

ADD
Show:
© 2014 Microsoft