Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

Large Database (Server Mode)

Time taken:   ms
Drag a column header here to group by that column
Bert ParkinsEmail Attachments. Is it possible to add multiple attachments? I haven't found a way to do this.4/3/20165874
Tom HamlettPayables Due Calculator is ready for testing.3/8/201646749
Tom HamlettEmail Attachments. Is it possible to add multiple attachments? I haven't found a way to do this.2/26/2016184383
Ray ShipmanIntegrating Developer Express MasterView control into an Accounting System.2/21/2016205415
Tom HamlettEmail System. What library are we going to use?3/31/2016258211
Dave MurrelMain Menu: Add a File menu. File menu item is missing.3/12/2016276977
Ryan FischerReceivables Calculator. Where can I find the complete specs?3/5/2016214367
Carl LucasPayables Due Calculator is ready for testing.2/28/2016193712
Brad BarnesReceivables Calculator. Where can I find the complete specs?3/9/2016144899
Carl LucasDrag & Drop operations are not available in the scheduler module.4/6/2016232127
 Count=300,000 Sum=45359070276 
Page 1 of 30000 (300000 items)Prev1234567299982999930000Next

This demo illustrates how the DevExpress ASP.NET MVC Grid View can be bound to a large databases using LINQ to SQL.

With the ASP.NET MVC Grid View, 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, and specify the key field via the GridView's KeyFieldName property. Internally, the BindToEF method uses our LinqServerModeDataSource component, which was specifically designed to allow the Grid View 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 Grid View. In this mode, the Grid View loads records on demand and performs data-aware operations (sorting, filtering, grouping, etc.) on the data server. This technique significantly improves the Grid View's speed and responsiveness.

You can explore the performance of the DevExpress ASP.NET MVC Grid View by executing data shaping operations against it (sorting, filtering, and grouping). Note how quickly the Grid View calculates summaries against 300,000 records.

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).
Open CS Solution
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxGridViewDemos