Friday, November 9, 2012

LINQ - The data source does not support server-side data paging.

Issue:

When trying to bind a result set to a gridview from a LINQ query you may receive the following error.

gridView.DataSource = results;


Error:

The data source does not support server-side data paging.


Solution:

Chances are you just need to add a .ToList() on your return var from your LINQ query. A common case is when you use .Intersect on lists and forget to do another .ToList().