LINQ to SQL

• Dec 23, 2021
• 2 minutes to read

The Data 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 Data Source Wizard button placed on the PivotGridControl or use the corresponding command in the control’s smart tag.

   

2. In the invoked Data 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 creat a data model, rebuild the solution.

5. After creating LINQ to SQL classes, click the Data Source Wizard button again.

   

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

   

   Click Next.

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

   

   • Direct Binding to Data Source - allows you to bind the PivotGridControl to a data source directly.
   • Binding via the BindingSource Component - allows you to bind the PivotGridControl to a data source using the BindingSource component that simplifies design-time data binding. To learn more, see BindingSource Component Specifics.
   • Server Side Data Processing - allows you to bind the PivotGridControl to large data sources. To learn more, see Database Server Mode.

   Select Direct Binding to Data Source and click Next.

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

   

   Select the required table and click Finish.

9. The following code will be generated by the Data Source Configuration Wizard.

   C#

   public Form1()
           {
               // This line of code is generated by Data Source Configuration Wizard
               pivotGridControl1.DataSource = new WinFormsPivot.NorthwindDataContext().SalesPersons;
           }
   

   VB.NET

   Public Class Form1
       Sub New()
           InitializeComponent()
           ' This line of code is generated by Data Source Configuration Wizard
           PivotGridControl1.DataSource = New WinFormsPivot.NorthwindDataDataContext().SalesPersons
       End Sub
   End Class
   

   You can work now with the created data source at runtime. For instance, to retrieve fields from the connected data source, call the PivotGridControl.RetrieveFields method.