VerticalGridExtension.BindToEF(Type, String, EventHandler<LinqServerModeDataSourceSelectEventArgs>) Method

Binds the VerticalGrid to a data source via the Entity Framework in database server mode.

Namespace: DevExpress.Web.Mvc

Assembly: DevExpress.Web.Mvc5.v24.1.dll

NuGet Package: DevExpress.Web.Mvc5

Declaration

C#

public VerticalGridExtension BindToEF(
    Type contextType,
    string tableName,
    EventHandler<LinqServerModeDataSourceSelectEventArgs> selectingMethod
)

VB.NET

Public Function BindToEF(
    contextType As Type,
    tableName As String,
    selectingMethod As EventHandler(Of LinqServerModeDataSourceSelectEventArgs)
) As VerticalGridExtension

Parameters

Name	Type	Description
contextType	Type	A Type specifying the DataContext type.
tableName	String	A string specifying the table name.
selectingMethod	EventHandler<LinqServerModeDataSourceSelectEventArgs>	A method to which selection logic is delegated.

Returns

Type	Description
VerticalGridExtension	A VerticalGridExtension object representing the VerticalGrid extension.

Remarks

Using the BindToEF method, you can easily bind the VerticalGrid to Entity Framework data models. Simply call the method, pass the DataContext and table name as method parameters, and specify the key field via the VerticalGrid’s GridSettingsBase.KeyFieldName property.

Internally, the BindToEF method uses our EntityServerModeDataSource component, which was specifically designed to allow the VerticalGrid to efficiently process large amounts of data. The EntityServerModeDataSource component automatically enables database server mode to optimize the execution of all queries to the data context initiated by the VerticalGrid. In this mode, the VerticalGrid loads records on demand and performs data-aware operations (sorting, filtering, grouping, etc.) on the data server. This technique significantly improves the VerticalGrid’s speed and responsiveness.

Note

The current BindToEF overload catches and conceals any exception thrown by an EF data provider. To catch these exceptions manually, use the BindToEF(string contextTypeName, string tableName, EventHandler<LinqServerModeDataSourceSelectEventArgs> selectingMethod, EventHandler<ServerModeExceptionThrownEventArgs> exceptionThrownMethod) overload method.