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)
{
MySqlConnection myConn = new MySqlConnection(
"User Id=root;Host=localhost;Database=Test;");
MySqlMonitor myMonitor = new MySqlMonitor();
myMonitor.TraceEvent += new MonitorEventHandler(OnEvent);
myMonitor.IsActive = true;
MySqlCommand myCommand = new MySqlCommand("select count(*) from Dept",myConn);
myConn.Open();
Console.WriteLine(myCommand.ExecuteScalar());
myConn.Close();
myMonitor.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 myConn As MySqlConnection = New MySqlConnection( _
"User Id=root;Host=localhost;Database=Test;")
Dim myMonitor As MySqlMonitor = New MySqlMonitor
AddHandler myMonitor.TraceEvent, AddressOf OnEvent
myMonitor.IsActive = True
Dim myCommand As MySqlCommand = New MySqlCommand("select count(*) from Dept", myConn)
myConn.Open()
Console.WriteLine(myCommand.ExecuteScalar())
myConn.Close()
RemoveHandler myMonitor.TraceEvent, AddressOf OnEvent
Console.ReadLine()
End Sub
System.Object
System.EventArgs
Devart.Common.MonitorEventArgs