A newer version of this page is available. Switch to the current version.

GridViewExtension.BindToLINQ(String, String, EventHandler<LinqServerModeDataSourceSelectEventArgs>, EventHandler<ServerModeExceptionThrownEventArgs>) Method

Binds the GridView to a queryable source in database server mode.

Namespace: DevExpress.Web.Mvc

Assembly: DevExpress.Web.Mvc5.v18.2.dll

Declaration

public GridViewExtension BindToLINQ(
    string contextTypeName,
    string tableName,
    EventHandler<LinqServerModeDataSourceSelectEventArgs> selectingMethod,
    EventHandler<ServerModeExceptionThrownEventArgs> exceptionThrownMethod
)
Public Function BindToLINQ(
    contextTypeName As String,
    tableName As String,
    selectingMethod As EventHandler(Of LinqServerModeDataSourceSelectEventArgs),
    exceptionThrownMethod As EventHandler(Of ServerModeExceptionThrownEventArgs)
) As GridViewExtension

Parameters

Name Type Description
contextTypeName String

A string representing the DataContext type name.

tableName String

A string specifying the table name.

selectingMethod EventHandler<LinqServerModeDataSourceSelectEventArgs>

A method to which selection logic is delegated.

exceptionThrownMethod EventHandler<ServerModeExceptionThrownEventArgs>

A delegate method that allows catching unhandled/CLR exceptions that appear.

Returns

Type Description
GridViewExtension

A GridViewExtension object representing the GridView extension.

Remarks

Using the BindToLINQ method, you can easily bind the GridView to queryable data sources. Simply call the method, pass the DataContext and table name as method parameters, and specify the key field via the GridView's GridSettingsBase.KeyFieldName property.

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

Example

The code sample below demonstrates how to catch the internal exception thrown when using the Database Server Mode data binding approach.

View code (Razor):


@Html.DevExpress().GridView(settings => {
    // GridView settings
}).BindToLINQ(string.Empty, string.Empty, (s, e) => {
    // Specify queryable source
    var dataContext = new MyProject.Models.LargeDatabaseDataContext();
    e.QueryableSource = dataContext.Emails;
    e.KeyExpression = "Id";
}, (s, e) => {
    // Handle internal exception
    ViewContext.Writer.Write(e.Exception.Message + Environment.NewLine + e.Exception.StackTrace);
}).GetHtml()
See Also