dotConnect for SQLite Documentation
Devart.Common Namespace / MonitorEventArgs Class
Members Example

On this page
    MonitorEventArgs Class
    On this page
    Provides data for the TraceEvent event of the DbMonitor class.
    Syntax
    'Declaration
     
    Public Class MonitorEventArgs 
       Inherits System.EventArgs
    public class MonitorEventArgs : System.EventArgs 
    Remarks
    The TraceEvent event occurs when DbMonitor object is active and the monitoring application performs any SQL activity.
    Example
    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)
    {
      SQLiteConnection sqLiteConn = new SQLiteConnection(
          "DataSource=mydatabase.db;");
      SQLiteMonitor sqLiteMonitor = new SQLiteMonitor();
      sqLiteMonitor.TraceEvent += new MonitorEventHandler(OnEvent);
      sqLiteMonitor.IsActive = true;
      SQLiteCommand sqLiteCommand = new SQLiteCommand("select count(*) from Dept",sqLiteConn);
      sqLiteConn.Open();
      Console.WriteLine(sqLiteCommand.ExecuteScalar());
      sqLiteConn.Close();
      sqLiteMonitor.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 sqLiteConn As SQLiteConnection = New SQLiteConnection( _
          "DataSource=mydatabase.db;")
      Dim sqLiteMonitor As SQLiteMonitor = New SQLiteMonitor
      AddHandler sqLiteMonitor.TraceEvent, AddressOf OnEvent
      sqLiteMonitor.IsActive = True
      Dim sqLiteCommand As SQLiteCommand = New SQLiteCommand("select count(*) from Dept", sqLiteConn)
      sqLiteConn.Open()
      Console.WriteLine(sqLiteCommand.ExecuteScalar())
      sqLiteConn.Close()
      RemoveHandler sqLiteMonitor.TraceEvent, AddressOf OnEvent
      Console.ReadLine()
    End Sub
    Inheritance Hierarchy

    System.Object
       System.EventArgs
          Devart.Common.MonitorEventArgs

    See Also