OracleConnectionStringBuilder.Remove(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.
Removes the entry with the specified key from the OracleConnectionStringBuilder instance.
public:
override bool Remove(System::String ^ keyword);
public override bool Remove (string keyword);
override this.Remove : string -> bool
Public Overrides Function Remove (keyword As String) As Boolean
Parameters
- keyword
- String
The key of the key/value pair to be removed from the connection string in this OracleConnectionStringBuilder.
Returns
true
if the key existed within the connection string and was removed, false
if the key did not exist.
Exceptions
keyword
is null (Nothing
in Visual Basic).
Examples
The following example converts an existing connection string from using Windows Authentication to using integrated security. The example works by removing the user name and password from the connection string, and then setting the IntegratedSecurity property of the OracleConnectionStringBuilder object.
Note
This example includes a password to demonstrate how OracleConnectionStringBuilder works with connection strings. In your applications, we recommend that you use Windows Authentication. If you must use a password, do not include a hard-coded password in your application.
// 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()
{
try
{
string connectString =
"Data Source=OracleDemo;User ID=Mary;Password=*****";
OracleConnectionStringBuilder builder = new OracleConnectionStringBuilder(connectString);
Console.WriteLine("Original: " + builder.ConnectionString);
// Use the Remove method
// in order to reset the user ID and password back to their
// default (empty string) values.
builder.Remove("User ID");
builder.Remove("Password");
// Turn on integrated security.
builder.IntegratedSecurity = true;
Console.WriteLine("Modified: " + builder.ConnectionString);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.WriteLine("Press any key to finish.");
Console.ReadLine();
}
}
' 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()
Try
Dim connectString As String = _
"Data Source=OracleDemo;User ID=Mary;Password=*****;"
Dim builder As New OracleConnectionStringBuilder(connectString)
Console.WriteLine("Original: " & builder.ConnectionString)
' Use the Remove method
' in order to reset the user ID and password back to their
' default (empty string) values.
builder.Remove("User ID")
builder.Remove("Password")
' Turn on integrated security.
builder.IntegratedSecurity = True
Console.WriteLine("Modified: " & builder.ConnectionString)
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
Console.WriteLine("Press any key to finish.")
Console.ReadLine()
End Sub
End Module
Remarks
Because the Remove method returns a value that indicates its success, it is not necessary to look for the existence of a key before trying to remove the key/value pair from the OracleConnectionStringBuilder instance. Because the OracleConnectionStringBuilder maintains a fixed-size collection of key/value pairs, calling the Remove method just resets the value of the key/value pair back to its default value.
Because the collection of keys supported by the OracleConnectionStringBuilder is fixed, every item within the collection has a known default value.
The following table lists the keys, and the value for each when the OracleConnectionStringBuilder is first initialized, or after the Remove method has been called:
Key | Default value |
---|---|
Data Source | Empty string |
Persist Security Info | False |
Integrated Security | False |
User ID | Empty string |
Password | Empty string |
Enlist | True |
Pooling | True |
Min Pool Size | 0 |
Max Pool Size | 100 |
Unicode | False |
Load Balance Timeout | 0 |
Omit Oracle Connection Name | False |