LINQ to SQL

• Mar 14, 2021
• 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.

   

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

   

   … 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 LINQ to SQL Classes item is selected in the invoked dialog. Then, specify the required name and click Add.

   

   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.

   

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.

   

   • Simple Binding - allows you to bind the PivotGridControl to an Entity Framework data source directly.
   • Manipulating Data via ICollectionView - allows you to bind the PivotGridControl to a DataSet using the ICollectionView component, which enables collections to have the functionalities of current record management, custom sorting, filtering, and grouping. To learn more, see ICollectionView Specifics.
   • Server Side Data Processing - allows you to bind the PivotGridControl to large data sources. To learn more, see Database Server Mode.

   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.

   Note

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

   XAML

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

   XAML

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