Skip to main content

Entity Framework

  • 2 minutes to read

The Items Source Configuration Wizard allows you to bind the PivotGridControl to an SQL database using the Entity Framework at design time. This topic guides you through the steps needed to do this.

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


  2. In the invoked Items Source Configuration Wizard, select Entity Framework


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


  3. The following message will appear.


    Click OK.

  4. Make sure that the ADO.NET Entity Data Model item is selected in the invoked dialog. Then, specify the required name and click Add.


    To learn how to create a new Entity Framework data model from the existing database, see the following topics: Entity Framework (EF) Documentation.


    After you creat a data model, rebuild the solution.

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


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


    Click Next.

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


    Select Simple Binding and click Next.

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


    Select the required table and click Finish.

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


    You can now use the Retrieve Fields command to retrieve the available data source fields. To retrieve fields in code, use the PivotGridControl.RetrieveFields method.


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

            <dx:EntitySimpleDataSource x:Key="EntitySimpleDataSource" ContextType="{x:Type local:NorthwindDataModel}" Path="SalesPersons"/>

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

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