IDashboardControl.CustomDBCommandInterceptor Property

Specifies the IDBCommandInterceptor object for the Dashboard control.

Namespace: DevExpress.DashboardWin

Assembly: DevExpress.Dashboard.v23.2.Win.dll

NuGet Package: DevExpress.Win.Dashboard

Declaration

C#

IDBCommandInterceptor CustomDBCommandInterceptor { get; set; }

VB.NET

Property CustomDBCommandInterceptor As IDBCommandInterceptor

Property Value

Type	Description
IDBCommandInterceptor	An IDBCommandInterceptor object.

Remarks

Dashboard controls execute a variety of SQL statements against the database. Implement IDBCommandInterceptor to intercept these data source commands. You can suppress a command or modify the execution algorithm.

Example: Dashboard for WinForms - Override the Default Isolation Level

The following example shows how to override the default isolation level (READ COMMITTED) in a specific query. The change allows users to retrieve information without being locked by another process that modifies the same data. This can significantly reduce the query time.

1. Implement the IDBCommandInterceptor interface (NolockInterceptor.cs in this example). Call the IDBCommandInterceptor.CommandCreated(String, IDbCommand) method and specify CommandText to execute.

   NolockInterceptor.cs

   using DevExpress.DataAccess.Sql;
   using System.Data;
   
   namespace WinDashboard {
       internal class NolockInterceptor : IDBCommandInterceptor {
           public void CommandCreated(string queryName, IDbCommand command) {
               command.CommandText += " WITH (NOLOCK)";
           }
       }
   }
   

   NolockInterceptor.vb

   Imports DevExpress.DataAccess.Sql
   Imports System.Data
   
   Namespace WinDashboard
       Friend Class NolockInterceptor
           Inherits IDBCommandInterceptor
   
           Public Sub CommandCreated(ByVal queryName As String, ByVal command As IDbCommand)
               command.CommandText &= " WITH (NOLOCK)"
           End Sub
       End Class
   End Namespace
   

2. Assign the NolockInterceptor object to the CustomDBCommandInterceptor property.

   Form1.cs

   namespace WinDashboard {
       public partial class Form1 : Form {
           public Form1() {
               InitializeComponent();
               dashboardViewer.CustomDBCommandInterceptor = new NolockInterceptor();
               // ...
           }
       }
   }
   

   Form1.vb

   Namespace WinDashboard
       Partial Public Class Form1
           Inherits Form
   
           Public Sub New()
               InitializeComponent()
               dashboardViewer.CustomDBCommandInterceptor = New NolockInterceptor()
               ' ...
           End Sub
       End Class
   End Namespace