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 |
System.Object
System.EventArgs
Devart.Common.MonitorEventArgs