This demo illustrates how to bind the DevExpress ASP.NET Pivot Grid control to a large databases using LINQ to SQL.
With the ASPxPivotGrid control, you can easily bind to LINQ to SQL data sources via the LinqServerModeDataSource data providing component.
Simply specify the type of objects retrieved from a data source and the table name. Internally,
the LinqServerModeDataSource component was specifically designed to allow the Pivot Grid control 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 Pivot Grid.
In this mode, the Pivot Grid control performs data-aware operations on the database server side, which allows the control to quickly load and display data even if sorting,
grouping, filtering, and summary are used. This technique significantly improves the Pivot Grid's speed and responsiveness.
You can try this feature in our Sales Viewer real world application demo.