LINQ to SQL

  • 2 minutes to read

The Items Source Configuration Wizard allows you to bind the PivotGridControl to an SQL database using LINQ to SQL at design time. This topic shows how to do this.

  1. Click the PivotGridControl's smart tag and select the Items Source Wizard command.

    WpfPivot_ProvidingData_SmartTag

  2. In the invoked Items Source Configuration Wizard, select LINQ to SQL...

    ItemsSourceConfigurationWizard_Linq

    ... and click the New Data Source button placed within the Data Sources area.

    DataSourceConfigurationWizard_SelectAdoNet_NewDataSource

  3. The following message will appear.

    ItemsSourceConfigurationWizard_RebuildWarning

    Click OK.

  4. Make sure that the LINQ to SQL Classes item is selected in the invoked dialog. Then, specify the required name and click Add.

    Pivot_AddLinqClassesDialog

    To learn how to create LINQ to SQL classes that are based on objects in a database, see the following topic: Creating LINQ to SQL Classes.

    IMPORTANT

    After you create a data model, rebuild the solution.

  5. After creating a data source, click Items Source Wizard again.

    WpfPivot_ProvidingData_SmartTag

  6. In the invoked Items Source Configuration Wizard, select the created data model.

    ItemsSourceConfigurationWizard_Linq_SelectModel

    Click Next.

  7. On the next page, select the required binding method.

    ItemsSourceConfigurationWizard_EF_SelectBindingMethod

    Select Simple Binding and click Next.

  8. On the final page, you can specify the table.

    ItemsSourceConfigurationWizard_ADO_SelectTable

    Select the required table and click Finish.

  9. The PivotGridControl will be bound to the created data source.

    WpfPivot_BoundToDataSet

    You can now use the Retrieve Fields command to retrieve the available data source fields.

    NOTE

    Note that the Items Source Configuration Wizard adds the created data source to window resources.

    <dx:DXWindow.Resources>
            <dx:LinqSimpleDataSource x:Key="LinqSimpleDataSource" ContextType="{x:Type local:NorthwindDataContext}" Path="SalesPersons"/>
        </dx:DXWindow.Resources>
    

    Then, the PivotGridControl is bound to the created data source.

    <dxpg:PivotGridControl DataSource="{Binding Data, Source={StaticResource LinqSimpleDataSource}}"/>
    
See Also