Entity Framework (EF) Core

• Jul 14, 2021
• 2 minutes to read

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

Note

In this tutorial, the PivotGridControl is bound to the Sales MS SQL database. Refer to the Getting started with EF Core on .NET Framework with an Existing Database topic for details on how to generate Entity Framework models for existing SQL databases.

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 (EF) Core…

3. On the next page, select the binding method.

4. On the final page, specify the table and click Finish.

5. The PivotGridControl is now bound to the created data source.