DashboardSqlDataSource.DataProcessingMode Property

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

Namespace: DevExpress.DashboardCommon

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

Declaration

C#
VB.NET

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

<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.

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.

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#
VB.NET

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";

how-to-implement-a-custom-logic-for-writing-data-to-reading-data-from-a-data-extract-t437252/VB/Dashboard_CustomExtractDriver/Form1.vb#L15

Dim sqlDataSource As New DashboardSqlDataSource()
sqlDataSource.DataProcessingMode = DataProcessingMode.Client
Dim connectionParams As New Access2007ConnectionParameters("..\..\Data\Northwind.accdb", "")

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

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

DashboardSqlDataSource.DataProcessingMode Property

Declaration

Property Value

Remarks

Implements

DashboardSqlDataSource.DataProcessingMode Property

Declaration

Property Value

Remarks

Related GitHub Examples

Implements