The following sample shows how to enable and disable monitoring of database activity in your application.
|
|---|
static void OnEvent(object sender, MonitorEventArgs e)
{
if (e.TracePoint==MonitorTracePoint.BeforeEvent)
{
Console.WriteLine("Description: " + e.Description);
Console.WriteLine(" Extra info: " + e.ExtraInfo);
}
}
[MTAThread]
static void Main(string[] args)
{
OracleConnection oracleConn = new OracleConnection(
"User Id=Scott;Password=tiger;Data Source=Ora;");
OracleMonitor oracleMonitor = new OracleMonitor();
oracleMonitor.TraceEvent += new MonitorEventHandler(OnEvent);
oracleMonitor.IsActive = true;
OracleCommand oracleCommand = new OracleCommand("select count(*) from Dept",oracleConn);
oracleConn.Open();
Console.WriteLine(oracleCommand.ExecuteScalar());
oracleConn.Close();
oracleMonitor.TraceEvent -= new MonitorEventHandler(OnEvent);
Console.ReadLine();
} |
|
|---|
Sub OnEvent(ByVal sender As Object, ByVal e As MonitorEventArgs)
If e.TracePoint = MonitorTracePoint.BeforeEvent Then
Console.WriteLine("Description: " & e.Description)
Console.WriteLine(" Extra info: " & e.ExtraInfo)
End If
End Sub
<MTAThread()> _
Sub Main()
Dim oracleConn As OracleConnection = New OracleConnection( _
"User Id=Scott;Password=tiger;Data Source=Ora;")
Dim oracleMonitor As OracleMonitor = New OracleMonitor
AddHandler oracleMonitor.TraceEvent, AddressOf OnEvent
oracleMonitor.IsActive = True
Dim oracleCommand As OracleCommand = New OracleCommand("select count(*) from Dept", oracleConn)
oracleConn.Open()
Console.WriteLine(oracleCommand.ExecuteScalar())
oracleConn.Close()
RemoveHandler oracleMonitor.TraceEvent, AddressOf OnEvent
Console.ReadLine()
End Sub |
System.Object
System.EventArgs
Devart.Common.MonitorEventArgs