Devart Forums

Code: Select all

    static void OnEvent(object sender, MonitorEventArgs e) {
        if (e.TracePoint == MonitorTracePoint.AfterEvent) {
            Console.WriteLine("Description: " + e.Description);
            Console.WriteLine("Duration: " + e.Duration);
        }
    }
    [MTAThread]
    static void Main(string[] args) {
        OracleConnection myConn = new OracleConnection("User Id=Scott;Password=tiger;Data Source=orcl1120");
        OracleMonitor myMonitor = new OracleMonitor();
        myMonitor.TraceEvent += new MonitorEventHandler(OnEvent);
        myMonitor.IsActive = true;
        OracleCommand myCommand = new OracleCommand("select count(*) from dept", myConn);
        myConn.Open();
        Console.WriteLine(myCommand.ExecuteScalar());
        myConn.Close();
        myMonitor.TraceEvent -= new MonitorEventHandler(OnEvent);
        Console.ReadLine();
    }

Code: Select all

#region Assembly Devart.Data.dll, v2.0.50727
// C:\Program Files\Devart\dotConnect\Oracle\Devart.Data.dll
#endregion

using System;

namespace Devart.Common
{
    // Summary:
    //     Provides data for the Devart.Common.DbMonitor.TraceEvent event of the Devart.Common.DbMonitor
    //     class.
    public class MonitorEventArgs : EventArgs
    {
        // Summary:
        //     Gets the call stack of the monitor event.
        public string[] CallStack { get; }
        //
        // Summary:
        //     Gets the description of a Devart.Common.DbMonitor event.
        public string Description { get; }
        //
        // Summary:
        //     Gets Devart.Common.DbMonitor event type.
        public MonitorEventType EventType { get; }
        //
        // Summary:
        //     Gets the additional information for a Devart.Common.DbMonitor event.
        public string ExtraInfo { get; }
        //
        // Summary:
        //     Determines whether Devart.Common.DbMonitor.TraceEvent event occurs before
        //     or after the operation takes place.
        public MonitorTracePoint TracePoint { get; }
    }
}