GridViewExtension.BindToLINQ(String, String) Method

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

Namespace: DevExpress.Web.Mvc

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

NuGet Package: DevExpress.Web.Mvc5

Declaration

C#

public GridViewExtension BindToLINQ(
    string contextTypeName,
    string tableName
)

VB.NET

Public Function BindToLINQ(
    contextTypeName As String,
    tableName As String
) As GridViewExtension

Parameters

Name	Type	Description
contextTypeName	String	The DataContext type name.
tableName	String	The table name.

Returns

Type	Description
GridViewExtension	A GridViewExtension object representing the GridView extension.

Remarks

Using the BindToLINQ method, you can easily bind 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.

Note

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

Example

Note

For a full example, refer to the GridView - BindToLINQ - How to export a large amount of filtered data with Reports online example.

Razor(View)

@Html.DevExpress().GridView(
    settings => {
        settings.Name = "gvDataBindingToLinq";
        settings.CallbackRouteValues = new { Controller = "Home", Action = "DataBindingToLargeDatabasePartial" };
        settings.KeyFieldName = "ProductID";

}).BindToLINQ("CS.Models.LargeDatabaseDataContextDataContext", "Products").GetHtml()