LINQ Server Mode
- 2 minutes to read
The server mode can be enabled for any Language-Integrated Query (LINQ) provider. When an end-user performs data operations - sorting, grouping, etc., the LINQ Server Mode Source analyzes the grid’s current state, and generates smart queries to receive only those records that must be displayed on-screen. These requests are passed to the associated LINQ Provider. The LINQ Provider translates them into required queries, and executes them.
Creating Data Classes
Add ‘LINQ to SQL Classes’.
Data classes can then be created and edited in the Object Relational Designer (O/R Designer). The O/R Designer provides a visual design surface for creating LINQ to SQL entity classes, and relationships based on objects in a database.
Entity classes can be created and mapped to tables and views by dragging database tables and views from Server Explorer/Database Explorer onto the O/R Designer.
- Save your changes, close the O/R Designer, and rebuild the solution.
Binding to LinqServerModeSource
Create a new instance of the LinqServerModeSource class. Specify the type of objects retrieved from a data source, the key expression and queryable source. Finally, bind the DXGrid control to the LinqServerModeSource component.