aspnetmvc-devexpress-dot-web-dot-mvc-dot-verticalgridextension-dot-bindtolinq-x28-system-dot-type-system-dot-string-system-dot-eventhandler-devexpress-dot-data-dot-linq-dot-linqservermodedatasourceselecteventargs-x29.md
Binds the VerticalGrid to a queryable source in database server mode.
Namespace : DevExpress.Web.Mvc
Assembly : DevExpress.Web.Mvc5.v25.2.dll
NuGet Package : DevExpress.Web.Mvc5
public VerticalGridExtension BindToLINQ(
Type contextType,
string tableName,
EventHandler<LinqServerModeDataSourceSelectEventArgs> selectingMethod
)
Public Function BindToLINQ(
contextType As Type,
tableName As String,
selectingMethod As EventHandler(Of LinqServerModeDataSourceSelectEventArgs)
) As VerticalGridExtension
| 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.
|
| Type | Description |
|---|---|
| VerticalGridExtension |
A VerticalGridExtension object specifying the VerticalGrid extension.
|
Using the BindToLINQ method, you can easily bind the VerticalGrid to queryable data sources. 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 BindToLINQ method uses our LinqServerModeDataSource component, which was specifically designed to allow the VerticalGrid 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 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 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.
See Also