Grouped grid datasource, neither a DataColumn nor a DataRelation

[Phil]

Hi
I am converting to the latest controls and I am getting the following runtime error:

    intKey is neither a DataColumn nor a DataRelation for table GroupedTable0.

This code is currently working with version 2010.3.1109 of controls.  The data for the grouped grid is coming from a stored procedure via a strongly types data adapter (i.e. dataset).  I am applying a filter on the data, prior to manually binding the grid.  When I bind the grid I get the above exception.
I have added a intKey column with visibility set to false to the columns collection but that did not help.

Phil

[Pavlina]

Hi Philip,

I already answered your support ticket post with the same question. To avoid duplicate posts I will ask you to continue our communication there.

Greetings,
Pavlina
the Telerik team

[Phil]

Hi:

I added per a different problem ticket:

<MasterTableView EnableLinqGrouping="false">

and all was better.

Phil

[Curt]

Just what I needed.

Thanks Phil!!

[Nick]

Can anyone elaborate on when and  why <MasterTableView EnableLinqGrouping="false"> is required for Radgrids in newer versions of Telerik libraries?  I have not seen the original Philip's first post that Pavlina says she has responded to.   My company recently updated our libraries after many years of being idle and I'm seeing a lot of similar issues like this on our website.

[Shinu]

Hi Nick,

Since Q3 2011 release, a new Linq based grouping is turned on by default. This type of grouping has a huge performance optimization and internally uses Dynamic Linq for grouping. Also this grouping is controlled by the RadGrid. EnableLinqExpressions and  MasterTableView.EnableLinqGrouping properties (default values are "true"). More information you could find here:
http://blogs.telerik.com/aspnet-ajax/posts/11-11-08/super-charged-performance-optimizations-for-telerik-s-asp-net-ajax-grid-in-q3-2011.aspx

Thanks,
Shinu

[Nick]

That is great to know, but can you tell me more about when this grouping needs to be turned off to prevent errors like this?

[Shinu]

Hi NIck,

RadGrid does not support groping performed on the database level via LINQ to SQL. The RadGrid grouping is designed to get all data from the datasource and perform grouping over it. However if you have a millions of records this could slow down the performance. Since Q3 2011 release a new LINQ based grouping which is turned on by default. This grouping is controlled by theMasterTableView.EnableLinqGrouping property(default value is "true").

Thanks,
Shinu

[Nick]

So when should the MasterTableView.EnableLinqGrouping property be set to false?  When the datasource has large numbers of records?

[Shinu]

Hi Nick,

The EnableLinqGrouping property was set to true to increase performance when the grid has large number of records. But in some scenarios this causes errors, to avoid that we have to set this property to false. Telerik is doing its best to fix this issue as soon as possible and provide a stable product to the customers.

Thanks,
Shinu