MonitorEventFilter Enumeration

In This Topic

Allows subscribing for certain event kinds and not monitoring other events in order to improve performance.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum MonitorEventFilter 
   Inherits System.Enum
   Implements System.IComparable, System.IConvertible, System.IFormattable

public enum MonitorEventFilter : System.Enum, System.IComparable, System.IConvertible, System.IFormattable

Members

Member	Description
ActivateInPool	Application takes a connection from the pool.
All	Enable monitoring for all events.
BeginTransaction	Application begins a transaction (local or distributed) against a data source.
Commit	Application executes COMMIT statement against a data source.
ConnectNonPooled	Application opens a new connection to a data source, and this connection is not taken from the pool.
ConnectPooled	Application opens a new connection to a data source, and this connection is actually taken from the pool.
CreateObject	A SqlConnection or SqlCommand object is created.
CreatePoolGroup	A connection pool group is created. This is the second level of connection pool hierarchy. Connection pool groups contain connection pools.
CreatePoolManager	A connection pool manager is created. This is the highest level of connection pool hierarchy.
Custom	Application executes any user defined statement against a data source.
Disconnect	Application closes connection to a data source.
Error	Data source returns an error message.
Execute	Application executes a statement against a data source.
None	No events are monitored.
OpenConnection	Application opens a connection to a data source.
Prepare	Application prepares an execute statement.
ReturnToPool	Application returns a connection to the pool.
Rollback	Application executes ROLLBACK statement against a data source.

Example

This example shows selecting connection open events and executing SQL statements for monitoring and turning off call stack sending.

csharp

var monitor = new SqlMonitor() { IsActive = true };
monitor.SendCallStack = false;
monitor.Filter = Devart.Common.MonitorEventFilter.OpenConnection | Devart.Common.MonitorEventFilter.Execute;

Visual Basic

Dim monitor = New SqlMonitor() With {
.IsActive = True
}
monitor.SendCallStack = False
monitor.Filter = Devart.Common.MonitorEventFilter.OpenConnection Or Devart.Common.MonitorEventFilter.Execute

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         Devart.Common.MonitorEventFilter

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Devart.Common Namespace
Filter Property

Send Feedback