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 BindToLINQ 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 BindToLINQ 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.