This event is triggered upon the OracleConnection.Open()
method.
Declaration
// C# public event OracleConnectionOpenEventHandler ConnectionOpen;
Event Data
The event handler receives a OracleConnectionOpenEventArgs
object which exposes the following property containing information about the ConnectionOpen
event.
Connection
OracleConnection
object on which Open()
is called.
Exceptions
InvalidOperationException()
- if CPVersion=1.0
and the ConnectionOpen
event is used. Applies to unmanaged ODP.NET only.
InvalidOperationException()
- if the ConnectionOpen
event is set after opening a connection.
Remarks
This feature requires CPVersion=2.0
to be used.
In order to configure the connection before it is dispensed, the application should register the callback to the ConnectionOpen
event before Open()
is called.
Only supported for .NET Framework 4 and higher.
Example
// C# // NOTE: The sample below requires CPVersion=2.0 to be configured in the .NET configuration using System; using Oracle.ManagedDataAccess.Client; class ConOpenEventSample { public static void ConOpenCallback(OracleConnectionOpenEventArgs eventArgs) { OracleCommand cmd = new OracleCommand("ALTER SESSION SET NLS_LANGUAGE='GERMAN'", eventArgs.Connection); cmd.ExecuteNonQuery(); cmd.Dispose(); } static void Main(string[] args) { // Establish a connection string constr = "user id=hr;password=hr;data source=oracle"; OracleConnection con = new OracleConnection(constr); con.ConnectionOpen += ConOpenCallback; con.Open(); con.Dispose(); } }