This demo illustrates how the DevExpress ASP.NET MVC Vertical Grid can be bound to large databases using LINQ to SQL.
With the ASP.NET MVC Vertical Grid, you can easily bind to LINQ to SQL data sources via the extension's BindToEF method. Simply call the method, pass the DataContext and table name as method parameters. Internally, the BindToEF method uses our LinqServerModeDataSource component, which was specifically designed to allow the Vertical Grid MVC extension to efficiently process large amounts of data. The LinqServerModeDataSource component automatically enables server mode to optimize the execution of all LINQ queries initiated by the Vertical Grid. In this mode, the MVC Vertical Grid performs data-aware operations on the database server side, which allows the MVC Vertical Grid to quickly load and display data even if sorting, grouping, filtering, and summary are used. This technique significantly improves the Vertical Grid's speed and responsiveness.
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
The source code files for this demo are installed (by default) in the following directory:
Open CS Solution
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxVerticalGridDemos