Binding to a Data Source Using Entity Framework

Dec 17, 2020

This example shows how to generate model and mapping information and bind the pivot grid to the data source using Entity Framework.

Creating Data Classes

Add ADO.NET Entity Data Model to the project.
Follow the wizard steps to generate a new data model using the code-first or database-first development approach.
Save the generated model, close the EDMX diagram, and rebuild the solution

Binding the ASPxPivotGrid control to the EntityServerModeSource component

Drag the EntityServerModeSource component and drop it onto the Page.
Specify the type of objects retrieved from a data source, using the EntityServerModeDataSource.ContextTypeName property.
Specify the data table name using the EntityServerModeDataSource.TableName property.
Bind the Pivot Grid control to the EntityServerModeDataSource component.

If the database table that is used to generate a EDMX diagram does not have a primary key, handle the EntityServerModeDataSource.Selecting event and specify the LinqServerModeDataSourceSelectEventArgs.KeyExpression and LinqServerModeDataSourceSelectEventArgs.QueryableSource properties.

C#
VB.NET

csharp

using DevExpress.Data.Linq;

protected void EntityServerModeDataSource1_Selecting(object sender, DevExpress.Data.Linq.LinqServerModeDataSourceSelectEventArgs e)
{
    e.KeyExpression = "OrderID";
    e.QueryableSource = new ASP.NETEntityServerMode.NWindEntities().SalesPersons;
}

Imports DevExpress.Data.Linq

Protected Sub EntityServerModeDataSource1_Selecting(ByVal sender As Object, ByVal e As DevExpress.Data.Linq.LinqServerModeDataSourceSelectEventArgs)
    e.KeyExpression = "OrderID"
    e.QueryableSource = New ASP.NETEntityServerMode.NWindEntities().SalesPersons
End Sub