How to: Bind a PivotGridControl to a Database at Design Time Using Server Mode

If you need to connect a pivot grid control to a database with a large number of records, you can use server mode. The pivot grid control, if it is bound to an appropriate data source, automatically operates in server mode. You can use dedicated data sources tailored to work with 'LINQ to SQL Classes' or 'Entity Framework 4+' data access technologies.

Creating Data Classes

Select the LINQ to SQL Classes item and add it to the project.

Data classes can then be created and edited in an Object Relational Designer (O/R Designer). An O/R Designer provides a visual design surface for creating LINQ to SQL entity classes and relationships based on objects in a database.

Create and map entity classes to tables and views by dragging database tables and views from Server Explorer onto the O/R Designer. To learn how to connect to the Northwind Database, see this MSDN Topic.