aspnetmvc-116309-components-vertical-grid-binding-to-data-binding-to-large-data-database-server-mode.md
The MVC VerticalGrid extension supports a specific binding mode designed to work with large datasets. Within this binding mode, data-aware operations (sorting, grouping, etc.) are performed on the database server side, which is why this mode is called database server mode.
In database server mode, the MVC VerticalGrid is bound to a queryable source using the VerticalGridExtension.BindToLINQ method, which allows the VerticalGrid to load data from the queryable source on demand.
When an end-user performs data operations (sorting, grouping, etc.), the VerticalGrid generates smart queries to receive only those records that must be displayed on screen. These requests are passed to the associated queryable source. The queryable source translates these requests into the required queries and executes them. This ensures a quick response and improved performance for large data sources.
For end-users, the MVC VerticalGrid functions identically in regular and server modes. In database server mode , end-users can use an automatic filtering feature to access a specific data range, sort, group and filter data, calculate summaries, etc.
Perform the following steps to bind the VerticalGrid to a data source in database server mode.
Add the VerticalGrid to your project
Change the View code
In server mode, the MVC VerticalGrid does not have simultaneous access to bound data in its entirety. This imposes some limitations on the VerticalGrid’s features that are still available in regular binding mode. see the table below for information on features that have limitations in server mode.