LINQ Support

LINQ is a great way to retrieve data. LINQ lets you build intuitive query expressions in any language with optional support to transform, project, or shape data in many forms before it gets displayed.
For more information on LINQ, see http://msdn.microsoft.com/en-us/netframework/aa904594.aspx.

The Grid now supports binding to LINQ through "Pass Through Grouping" introduced in the previous section. Binding the grid with LINQ results has many advantages. The default setting of the grid retrieves all records from the bound datasource. This could become a serious overhead when dealing with large datasources. To override this setting, the grid is bound to the LINQ query results instead of the datasource. Then data from the datasource is retrieved on-demand when s user requests it(by expand and collapse of groups).