This demo illustrates how the DevExpress ASP.NET MVC Grid View can be bound to a large databases using Entity Framework ORM.
With the ASP.NET MVC Grid View, you can easily bind to a EF data source 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 EntityServerModeDataSource component, which was specifically designed to allow the Grid View MVC extension to efficiently process large amounts of data. The EntityServerModeDataSource component automatically enables server mode to optimize the execution of 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.