Binding to a Data Source Using Entity Framework

• Aug 10, 2023

The PivotGridControl automatically operates in server mode if it is bound to appropriate supported data source. This example illustrates how to generate model and mapping information, and how to bind the pivot grid to a data source using the Entity Framework.

Creating Data Classes

1. Add an ADO.NET Entity Data Model to the project.

   

2. Follow the wizard steps to generate a new data model using the code-first or database-first development approach.

   

3. Save the generated model, close the EDMX diagram, and rebuild the solution.

Binding the Pivot Grid control to the EntityServerModeDataSource component.

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

   C#

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

   XAML

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