This demo illustrates how the DevExpress ASP.NET MVC Card View can be bound to large databases using LINQ to SQL.
With the ASP.NET MVC Card View, you can easily bind to LINQ to SQL data sources with the extension's BindToEF method. Simply call the method, pass the DataContext and table name as method parameters, and specify the key field with the CardView’s KeyFieldName property. Internally, the BindToEF method uses our LinqServerModeDataSource component, which was specifically designed to allow the Card 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 Card View. In this mode, the Card View loads records on demand and performs data-aware operations (sorting, filtering, grouping, etc.) on the data server. This technique significantly improves the Card View's speed and responsiveness.
You can explore the performance of the DevExpress ASP.NET MVC Card View by executing data shaping operations against it (sorting, filtering). Note how quickly the Card View calculates summaries against 300,000 records.