Skip to main content
BuyLog In
ASP.NET Bootstrap Controls
Search in…
Docs > Grid View > Binding to Data > Binding to Large Data (Database Server Mode) > Data Binding to Large Data via EF
All docs
V23.2
ASP.NET Bootstrap Controls
Overview
Getting Started
Demos and Sample Applications
Project Configuration
Security Considerations
Grid View
Binding to Data
Connecting Bootstrap Grid View to a Data Source
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 Cache
Data Representation Basics
Data Summaries
Filtering
Grouping
Sorting
Cell Merging
Focus and Navigation
Data Editing
Master-Detail Relationship
Adaptivity
Templates
Export
Data-Toggle Attribute
Card View
Scheduler
Spreadsheet
Rich Text Editor
Charts
Sparkline
Data Editors
Site Navigation
Site Layout
File Manager
Redistribution and Deployment
.NET Framework API Reference
Client API Reference
Download CHM

Data Binding to Large Data via EF

  • 2 minutes to read

The Bootstrap Grid View control supports binding to large data sets using the EntityServerModeDataSource component. This component fully supports database server mode (i.e., it delegates all data processing to the DB server), and loads the minimum required amount of records to be displayed on the screen. This allows you to dramatically increase performance when working with large datasets.

Server mode can be enabled for any Entity Framework (EF) Data Model. The EntityServerModeDataSource component is designed for ASP.NET applications, and serves as the data source for the Bootstrap Grid View control.

When an end-user performs data operations - sorting, grouping, etc., the EntityServerModeDataSource 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 EF Data Model. The EF Data Model translates them into the required queries and executes them.

Note

The EntityServerModeDataSource component is a read-only data source, so you cannot enable data editing, updating and deleting using the built-in ASPxGridView functionality.

Example

The EntityServerModeDataSource component allows you to bind Bootstrap Grid View to the ADO.NET Entity Data Model and enable database server mode.

Create Data Classes

  1. Add the ADO.NET Entity Data Model.

    ASP.NET_Grid_ServerMode_EF

  2. Follow the wizard’s steps to generate a new data model using the code-first or database-first development approach.
  3. Save the generated model, close the EDMX diagram, and build the solution.

Connect to the Data Model using the EntityServerModeDataSource control

  1. Drag the EntityServerModeDataSource component and drop it onto the Page.
  2. Specify the data context type name using the EntityServerModeDataSource.ContextTypeName property.
  3. Specify the data table name using the EntityServerModeDataSource.TableName property.
  4. Bind the Bootstrap Grid View control to the EntityServerModeDataSource component and specify the grid’s ASPxGridBase.KeyFieldName property.

Database Server Mode Limitations

In database server mode, the Bootstrap Grid View 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. Please see the following topic for information on features that are not supported in server mode: Database Server Mode Limitations.

See Also