DashboardViewer.CustomDBCommandInterceptor Property

Specifies the IDBCommandInterceptor object for the Dashboard Viewer control.

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

NuGet Package : DevExpress.Win.Dashboard

Declaration

C#
VB.NET

csharp

[Browsable(false)]
[DefaultValue(null)]
public IDBCommandInterceptor CustomDBCommandInterceptor { get; set; }

<DefaultValue(Nothing)>
<Browsable(False)>
Public Property CustomDBCommandInterceptor As IDBCommandInterceptor

Property Value

Type	Default	Description
IDBCommandInterceptor	null

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.

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

Implements

CustomDBCommandInterceptor