The event handler receives an argument of type MonitorEventArgs containing data related to this event. The following MonitorEventArgs properties provide information specific to this event.
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)
{
BigQueryConnection bigQueryConn = new BigQueryConnection(
@"Authentication Type=ServiceAccount;ServiceAccount Json=C:\keys\service-account.json;Project Id=your_project;DataSet Id=your_dataset;License Key=**********");
BigQueryMonitor bigQueryMonitor = new BigQueryMonitor();
bigQueryMonitor.TraceEvent += new MonitorEventHandler(OnEvent);
bigQueryMonitor.IsActive = true;
BigQueryCommand bigQueryCommand = new BigQueryCommand("select count(*) from your_project.your_dataset.employees",bigQueryConn);
bigQueryConn.Open();
Console.WriteLine(bigQueryCommand.ExecuteScalar());
bigQueryConn.Close();
bigQueryMonitor.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 bigQueryConn As BigQueryConnection = New BigQueryConnection( _
"Authentication Type=ServiceAccount;ServiceAccount Json=C:\keys\service-account.json;Project Id=your_project;DataSet Id=your_dataset;License Key=**********")
Dim bigQueryMonitor As BigQueryMonitor = New BigQueryMonitor
AddHandler bigQueryMonitor.TraceEvent, AddressOf OnEvent
bigQueryMonitor.IsActive = True
Dim bigQueryCommand As BigQueryCommand = New BigQueryCommand("select count(*) from your_project.your_dataset.employees", bigQueryConn)
bigQueryConn.Open()
Console.WriteLine(bigQueryCommand.ExecuteScalar())
bigQueryConn.Close()
RemoveHandler bigQueryMonitor.TraceEvent, AddressOf OnEvent
Console.ReadLine()
End Sub |
