Binding to a Data Source Using 'LINQ to SQL Classes'

• Aug 10, 2023
• 2 minutes to read

The PivotGridControl automatically operates in server mode if it is bound to appropriate supported data source. You can use dedicated data sources tailored to work with ‘LINQ to SQL Classes’. This example shows how to use LINQ query providers.

Creating Data Classes

1. Add LINQ to SQL Classes to the project.

   

2. Data classes can then be created and edited in an Object Relational Designer (O/R Designer). An O/R Designer provides a visual design surface for creating LINQ to SQL entity classes and relationships based on objects in a database.

   You can create and map entity classes to tables and views by dragging database tables and views from the Server Explorer onto the O/R Designer.

   

   Save your changes, close the O/R Designer, and rebuild the solution.

Binding the Pivot Grid control to the LinqServerModeDataSource component

3. Create a new instance of the LinqServerModeDataSource class. Specify the type of objects retrieved from a data source LinqServerModeDataSource.KeyExpression and LinqServerModeDataSource.QueryableSource properties. Finally, bind the Pivot Grid control to the LinqServerModeDataSource component.

   C#

   using DevExpress.Xpf.Core.ServerMode;
   
   public MainWindow()
   {
       InitializeComponent();
       pivotGridControl1.DataSource = new LinqServerModeDataSource()
       {
           KeyExpression = "OrderID",
           QueryableSource = new DataClasses1DataContext().SalesPersons
       };
   }
   

   XAML

   <Window.Resources>
       <dx:LinqServerModeDataSource 
           x:Key="LinqServerModeDataSource1" 
           ContextType="{x:Type local:DataClasses1DataContext}" 
           DefaultSorting="{x:Null}" 
           KeyExpression="OrderID" 
           Path="SalesPersons">
           <dx:DesignDataManager.DesignData>
               <dx:DesignDataSettings RowCount="5"/>
           </dx:DesignDataManager.DesignData>
       </dx:LinqServerModeDataSource>
   </Window.Resources>
   <Grid>
       <dxpg:PivotGridControl 
           x:Name="pivotGridControl1" 
           DataSource="{Binding Data, Source={StaticResource LinqServerModeDataSource1}}">
       </dxpg:PivotGridControl>
   </Grid>