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