OracleConnectionStringBuilder.ContainsKey(String) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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
true
if the OracleConnectionStringBuilder contains an element that has the specified key; otherwise, false
.
Exceptions
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.
// 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";
}
}
' 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
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.