How to: Bind a PivotGridControl to a Database at Design Time so that it Operates in Server Mode

  • 2 minutes to read

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.

The following example is a step-by-step guide that demonstrates how to bind a PivotGridControl to a LinqServerModeSource data source at design time using the Data Source Configuration Wizard.

This example consists of the following steps.

Launching the Data Source Configuration Wizard

  1. To invoke the Data Source Configuration Wizard, do one of the following.

    • Click the Data Source Wizard panel in the center of the pivot grid control.
    • Click the smart tag icon (SmartTag) displayed at the top-right of the pivot grid and select the Data Source Wizard item.

      PivotGrid-DataSourceWizard

  2. Select LINQ to SQL technology and click New Data Source... button.

    Server Mode LINQ New Data Source

    The Add New Item window is invoked. This allows you to create new data classes.

Creating Data Classes

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

    Server Mode LINQ  Add LINQ to SQL classes

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

    Server Mode LINQ OR Designer

  3. Save your changes, close the O/R Designer, and rebuild the solution.

Binding to a Data Source using 'LINQ to SQL Classes'

  1. Invoke the Data Source Configuration Wizard again, select the LINQ to SQL technology and choose the previously created data source. Click Next.

    Server Mode LINQ Select Data Source

  2. In the next window, select Server-Side Data Processing and click Next. This activates the server mode.

    Server Mode LINQ Server-Side Connection

  3. Select a table and a key expression column, and click Finish to close the Data Source Configuration Wizard.

    Server Mode LINQ Specify Data Source

  4. The PivotGridControl is now bound to the LinqServerMode data source and automatically operates in server mode.

    pivot grid server mode result

    To learn how to retrieve fields at design time, see the Fields Page topic.