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)
{
PgSqlConnection pgConn = new PgSqlConnection(
"host=server;database=test;user id=postgres;");
PgSqlMonitor pgMonitor = new PgSqlMonitor();
pgMonitor.TraceEvent += new MonitorEventHandler(OnEvent);
pgMonitor.IsActive = true;
PgSqlCommand pgCommand = new PgSqlCommand("select count(*) from Dept",pgConn);
pgConn.Open();
Console.WriteLine(pgCommand.ExecuteScalar());
pgConn.Close();
pgMonitor.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 pgConn As PgSqlConnection = New PgSqlConnection( _
"host=server;database=test;user id=postgres;")
Dim pgMonitor As PgSqlMonitor = New PgSqlMonitor
AddHandler pgMonitor.TraceEvent, AddressOf OnEvent
pgMonitor.IsActive = True
Dim pgCommand As PgSqlCommand = New PgSqlCommand("select count(*) from Dept", pgConn)
pgConn.Open()
Console.WriteLine(pgCommand.ExecuteScalar())
pgConn.Close()
RemoveHandler pgMonitor.TraceEvent, AddressOf OnEvent
Console.ReadLine()
End Sub
System.Object
System.EventArgs
Devart.Common.MonitorEventArgs