Export (0) Print
Expand All

OracleConnectionStringBuilder.ContainsKey Method

Note: This method is new in the .NET Framework version 2.0.

Determines whether the OracleConnectionStringBuilder contains a specific key.

Namespace: System.Data.OracleClient
Assembly: System.Data.OracleClient (in system.data.oracleclient.dll)

'Declaration
Public Overrides Function ContainsKey ( _
	keyword As String _
) As Boolean
'Usage
Dim instance As OracleConnectionStringBuilder
Dim keyword As String
Dim returnValue As Boolean

returnValue = instance.ContainsKey(keyword)
public boolean ContainsKey (
	String keyword
)
public override function ContainsKey (
	keyword : String
) : boolean

Parameters

keyword

The key to locate in the

Return Value

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

Exception typeCondition

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.
Imports System.Data.OracleClient

Module Module1
  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"))

    ' 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 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
End Module

Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

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

.NET Framework

Supported in: 2.0

Community Additions

ADD
Show:
© 2014 Microsoft