[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
  [Collapse]Grid View
   [Expand]Product Information
    Getting Started
   [Expand]Fundamentals
   [Collapse]Concepts
    [Collapse]Binding to Data
      Connecting ASPxGridView to a Data Source
     [Collapse]Binding to Large Data (Database Server Mode)
       Data Binding to Large Data via EF
       Data Binding to Large Data via LINQ
       Data Binding to Large Data via XPO
       Database Server Mode Limitations
      Built-in Row Caching
    [Expand]Data Representation Basics
    [Expand]Focus and Navigation
    [Expand]Data Editing
    [Expand]Data Shaping and Manipulation
    [Expand]Data Formatting
    [Expand]Master-Detail Relationship
     Appearance Customization
     Adaptivity
     Save and Restore Layout
    [Expand]Templates
    [Expand]Export
     Toolbars
    [Expand]ASPxGridLookup
    ASPxGridView Designer
   [Expand]Visual Elements
   [Expand]Examples
   [Expand]Member Tables
   [Expand]ASPxGridView - Animated Images
  [Expand]Tree List
  [Expand]Card View
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Pivot Grid
  [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]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Data Binding to Large Data via LINQ

The ASPxGridView control supports binding to large data sets via the LinqServerModeDataSource component. This component fully support database server mode (i.e. delegates all data processing to the DB server), and only loads records to be displayed on screen. This allows you to dramatically increase performance when working with large datasets.

The server mode can be enabled for any Language-Integrated Query (LINQ) provider. The LinqServerModeDataSource component is designed for ASP.NET applications, and serves as a data source for the ASPxGridView control.

When an end-user performs data operations - sorting, grouping, etc., the LinqServerModeDataSource component analyzes the grid's current state and generates smart queries to receive only those records that must be displayed on-screen. These requests are passed to the associated LINQ Provider. The LINQ Provider translates them into required queries and executes them.

Expanded Example

The LinqServerModeDataSource component allows you to bind ASPxGridView to 'LINQ to SQL Classes' and enable the server mode.

Expanded Create Data Classes

  1. Add 'LINQ to SQL Classes'.

  2. Data classes can then be created and edited in the Object Relational Designer (O/R Designer). The O/R Designer provides a visual design surface for creating LINQ to SQL entity classes and relationships based on objects in a database. The O/R Designer currently supports only SQL Server 2000, SQL Server 2005, SQL Server 2008, and SQL Server Express databases.

    Entity classes can be created and mapped to tables and views by dragging database tables and views from Server Explorer/Database Explorer onto the O/R Designer.

  3. Save your changes, close the O/R Designer, and rebuild the solution.

Expanded LinqServerModeDataSource

  1. Drag the LinqServerModeDataSource component and drop it onto the Page.
  2. Specify the type of objects retrieved from a data source, using the LinqServerModeDataSource.ContextTypeName property.

  3. Specify the data table name using the LinqServerModeDataSource.TableName property.

  4. Bind the ASPxGridView control to the LinqServerModeDataSource component, and specify the grid's ASPxGridBase.KeyFieldName property.

Expanded Database Server Mode Limitations

In database server mode, ASPxGridView does not have simultaneous access to bound data in its entirety. This imposes some limitations on the grid's features, which are still available in regular binding mode. see the following topic for information on features that are not supported in server mode: Database Server Mode Limitations.

Expanded See Also

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