[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Reporting
  [Expand]Chart Control
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Collapse]Binding to Data
     Binding to Data Overview
    [Expand]OLAP Data Source
    [Collapse]Database Server Mode
      Binding to a Data Source Using Entity Framework
      Binding to a Data Source Using 'LINQ to SQL Classes'
     Unbound Fields
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Expand]Layout
   [Expand]Appearance
   [Expand]Export
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]Examples
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Scheduler
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Gauges
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Database Server Mode

If you need to connect an ASPxPivotGrid control to a database with a large number of records, you can use server mode. Server mode has been specifically designed to work with large datasets (the specific amount of data depends on your circumstances). In this mode, the pivot grid control performs data-aware operations on the database server side. This ensures quick access to data, even if grouping and filtering are used.

For end-users, the pivot grid control functions identically in regular and server modes. In server mode, they can scroll the pivot grid, sort, group and filter data, and calculate summaries.

The ASPxPivotGrid control performs data-aware operations (retrieving data from the server, grouping, filtering data and calculating summaries) in a background thread by default, allowing the entire application to stay responsive while these operations are in progress.

Expanded Server Mode Data Sources

The ASPxPivotGrid automatically operates in server mode if it is bound to an appropriate data source. Use one of the following data sources to enable this mode.

Data Access Technology Server Mode Data Source
Entity Framework 4+ EntityServerModeDataSource
LINQ to SQL LinqServerModeDataSource
Note

The EntityServerModeDataSource and LinqServerModeDataSource are read-only data sources.

Expanded Examples

The following step-by-step tutorials demonstrate how to bind a Pivot Grid control to different data sources.

Expanded Server Mode Limitations

In server mode, the pivot grid control doesn't have simultaneous access to bound data in its entirety, and this imposes some limitations on the pivot grid's features. See the list below for information on features that are not supported in a server mode.

Is this topic helpful?​​​​​​​