dotConnect for SQL Server Documentation
Devart.Common Namespace / MonitorEventFilter Enumeration
Example Example

In This Topic
    MonitorEventFilter Enumeration
    In This Topic
    Allows subscribing for certain event kinds and not monitoring other events in order to improve performance.
    Syntax
    'Declaration
     
    Public Enum MonitorEventFilter 
       Inherits System.Enum
       Implements System.IComparableSystem.IConvertibleSystem.IFormattable 
    public enum MonitorEventFilter : System.Enum, System.IComparableSystem.IConvertibleSystem.IFormattable  
    Members
    MemberDescription
    ActivateInPoolApplication takes a connection from the pool.
    AllEnable monitoring for all events.
    BeginTransactionApplication begins a transaction (local or distributed) against a data source.
    CommitApplication executes COMMIT statement against a data source.
    ConnectNonPooledApplication opens a new connection to a data source, and this connection is not taken from the pool.
    ConnectPooledApplication opens a new connection to a data source, and this connection is actually taken from the pool.
    CreateObjectA SqlConnection or SqlCommand object is created.
    CreatePoolGroupA connection pool group is created. This is the second level of connection pool hierarchy. Connection pool groups contain connection pools.
    CreatePoolManagerA connection pool manager is created. This is the highest level of connection pool hierarchy.
    CustomApplication executes any user defined statement against a data source.
    DisconnectApplication closes connection to a data source.
    ErrorData source returns an error message.
    ExecuteApplication executes a statement against a data source.
    NoneNo events are monitored.
    OpenConnectionApplication opens a connection to a data source.
    PrepareApplication prepares an execute statement.
    ReturnToPoolApplication returns a connection to the pool.
    RollbackApplication 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.
    var monitor = new SqlMonitor() { IsActive = true };
    monitor.SendCallStack = false;
    monitor.Filter = Devart.Common.MonitorEventFilter.OpenConnection | Devart.Common.MonitorEventFilter.Execute;
    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

    See Also