DashboardSqlDataSource.DataProcessingMode Property

Gets or sets the data processing mode for the current data source.

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v20.2.Core.dll

NuGet Packages: DevExpress.Dashboard.Core, DevExpress.WindowsDesktop.Dashboard.Core

Declaration

C#

[DefaultValue(DataProcessingMode.Server)]
public DataProcessingMode DataProcessingMode { get; set; }

VB.NET

<DefaultValue(DataProcessingMode.Server)>
Public Property DataProcessingMode As DataProcessingMode

Property Value

Type	Default	Description
DataProcessingMode	**Server**	A DataProcessingMode enumeration value that specifies the data processing mode for the current data source.

Available values:

Name	Description
Client	In-memory mode in which all data is stored in the application’s memory and the data engine operates without being connected to the database servers.
Server	Data-related operations are performed on the database server side.

Remarks

Initially any SQL Data Source works in server mode (the DataProcessingMode property value is DataProcessingMode.Server). You can toggle the mode in the Dashboard designer or in code.

To determine data processing mode for the specified query in the current data source, use the DashboardSqlDataSource.GetDataProcessingMode method.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DataProcessingMode property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-implement-a-custom-logic-for-writing-data-to-reading-data-from-a-data-extract-t437252/CS/Dashboard_CustomExtractDriver/Form1.cs#L13

DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource();
sqlDataSource.DataProcessingMode = DataProcessingMode.Client;
Access2007ConnectionParameters connectionParams = new Access2007ConnectionParameters(@"..\..\Data\Northwind.accdb", "");

aspxdashboard-how-to-switch-dashboards-by-clicking-thumbnails-displayed-in-image-slider-t526185/CS/WebApplication18/Data/DataSourceGenerator.cs#L12

DashboardSqlDataSource dashboardSqlDataSource1 = new DashboardSqlDataSource("NWind DataSource", "NorthwindConnectionString");
dashboardSqlDataSource1.DataProcessingMode = DataProcessingMode.Client;
dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1";

VB.NET

aspxdashboard-how-to-switch-dashboards-by-clicking-thumbnails-displayed-in-image-slider-t526185/VB/WebApplication18/Data/DataSourceGenerator.vb#L16

Dim dashboardSqlDataSource1 As New DashboardSqlDataSource("NWind DataSource", "NorthwindConnectionString")
dashboardSqlDataSource1.DataProcessingMode = DataProcessingMode.Client
dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1"

Implements

DataProcessingMode