Edit

Share via


OracleConnectionStringBuilder.Clear Method

Definition

Clears the contents of the OracleConnectionStringBuilder instance.

public:
 override void Clear();
public override void Clear ();
override this.Clear : unit -> unit
Public Overrides Sub Clear ()

Examples

The following example demonstrates the effect of calling the Clear method. This example populates the OracleConnectionStringBuilder with some key/value pairs, and then calls the Clear method and shows the results.

// You may need to set a reference to the System.Data.OracleClient
// assembly before running this example.
using System.Data.OracleClient;

class Program
{
    static void Main()
    {
        OracleConnectionStringBuilder builder =
            new OracleConnectionStringBuilder();
        builder.DataSource = "OracleSample";
        builder.IntegratedSecurity = true;
        Console.WriteLine("Initial connection string: " +
            builder.ConnectionString);

        Console.WriteLine("Before call to Clear, count = " + builder.Count);
        builder.Clear();
        Console.WriteLine("After call to Clear, count = " + builder.Count);
        Console.WriteLine("Cleared connection string: " +
            builder.ConnectionString);
        Console.WriteLine();

        Console.WriteLine("Press Enter to continue.");
        Console.ReadLine();
    }
}
' You may need to set a reference to the System.Data.OracleClient
' assembly before running this example.
Imports System.Data.OracleClient

Module Module1
  Sub Main()
    Dim builder As New OracleConnectionStringBuilder
    builder.DataSource = "OracleSample"
    builder.IntegratedSecurity = True
    Console.WriteLine("Initial connection string: " & builder.ConnectionString)

    Console.WriteLine("Before call to Clear, count = " & builder.Count)
    builder.Clear()
    Console.WriteLine("After call to Clear, count = " & builder.Count)
    Console.WriteLine("Cleared connection string: " & builder.ConnectionString)
    Console.WriteLine()

    Console.WriteLine("Press Enter to continue.")
    Console.ReadLine()
  End Sub
End Module

Remarks

The Clear method removes all key/value pairs from the OracleConnectionStringBuilder, and resets all corresponding properties. This includes resetting the connection string to an empty string.

Applies to

See also