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)
{
DynamicsConnection dynamicsConn = new DynamicsConnection(
"Server=https://your_company.crm4.dynamics.com;User Id=Test@Test.onmicrosoft.com;Password=A123456789;");
DynamicsMonitor dynamicsMonitor = new DynamicsMonitor();
dynamicsMonitor.TraceEvent += new MonitorEventHandler(OnEvent);
dynamicsMonitor.IsActive = true;
DynamicsCommand dynamicsCommand = new DynamicsCommand("select count(*) from contact",dynamicsConn);
dynamicsConn.Open();
Console.WriteLine(dynamicsCommand.ExecuteScalar());
dynamicsConn.Close();
dynamicsMonitor.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 dynamicsConn As DynamicsConnection = New DynamicsConnection( _
"Server=https://your_company.crm4.dynamics.com;User Id=Test@Test.onmicrosoft.com;Password=A123456789;")
Dim dynamicsMonitor As DynamicsMonitor = New DynamicsMonitor
AddHandler dynamicsMonitor.TraceEvent, AddressOf OnEvent
dynamicsMonitor.IsActive = True
Dim dynamicsCommand As DynamicsCommand = New DynamicsCommand("select count(*) from contact", dynamicsConn)
dynamicsConn.Open()
Console.WriteLine(dynamicsCommand.ExecuteScalar())
dynamicsConn.Close()
RemoveHandler dynamicsMonitor.TraceEvent, AddressOf OnEvent
Console.ReadLine()
End Sub
System.Object
System.EventArgs
Devart.Common.MonitorEventArgs