Skip to main content
BuyLog In
ASP.NET Web Forms Controls
Search in…
Docs > Components > Vertical Grid > Bind to Data > Bind to Large Data (Database Server Mode) > Bind to Large Data (LINQ)
All docs
V24.1
ASP.NET Web Forms Controls
Prerequisites
Supported Browsers
What's Installed
Get Started
Upgrade to a New Version
Common Concepts
Components
Card View
Chart Control
Data and Image Navigation
Data Editors
Diagram
Docking and Popups
File Management
Gantt
Gauges
Grid View
HTML Editor
Multi-Use Site Controls
Pivot Grid
Reporting
Rich Text Editor
Scheduler
Site Navigation and Layout
Spell Checker
Spreadsheet
Tree List
Vertical Grid
Deployment
Get Started
Bind to Data
Connecting ASPxVerticalGrid to a Data Source
Bind to Large Data (Database Server Mode)
Bind to Large Data (EF)
Bind to Large Data (LINQ)
Bind to Large Data (XPO)
Database Server Mode Limitations
Built-in Record Cache
Data Representation Basics
Focus and Navigation
Data Editing
Data Shaping and Manipulation
Data Formatting
Appearance Customization
Templates
Export
Toolbars
Grid Designer
Visual Elements
Query Builder
Security Considerations
Redistribution and Deployment
Troubleshooting
Get More Help
.NET Framework API Reference
Client API Reference
Download CHM

Data Binding to Large Data via LINQ

  • 2 minutes to read

The ASPxVerticalGrid control supports binding to large data sets using the LinqServerModeDataSource component. This component fully supports 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 ASPxVerticalGrid 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 the required queries and executes them.

Example

The LinqServerModeDataSource component allows you to bind ASPxVerticalGrid to ‘LINQ to SQL Classes’ and enable the server mode.

Create Data Classes

  1. Add ‘LINQ to SQL Classes’.

    cdLINQ_addClasses

  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.

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 ASPxVerticalGrid control to the LinqServerModeDataSource component, and specify the grid’s ASPxGridBase.KeyFieldName property.

Database Server Mode Limitations

In database server mode, ASPxVerticalGrid 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.

See Also