Using RadGrid with LINQ paging

[Steve]

Hi,
I am trying to use RadGrid with paging, using LINQ for Entities to do paging.  I am using a respository method to do this:

        public IEnumerable<TEntity> GetAllPaged(int page, int pageSize)
        {
            return _objectSet.AsEnumerable().Skip(pageSize).Take(page);
        }

The LINQ part works just fine, but when I do this, the pager on the Grid is no longer available- assuming that all the records are displayed.  Is there anyway to make sure the pager ribbon is still visible, and has the correct number of pages links?  Is there a way to use LINQDataSource (either Microsoft's or Telerik), which makes paging easier and much more efficient?

Thanks,

Steve

[Iana Tsolova]

Hello Steve,

To achieve your goal you should set the AllowCustomPaging and VistualItemCount properties for the grid. Thus you will achieve the desired custom paging. You can see how this is done in the demo below:
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/custompaging/defaultcs.aspx

Best wishes,
Iana
the Telerik team

[Steve]

Hi Iana,

It looks fairly simple to implement.  Can I set the VirtualItemCount in code rather than the hard-coded number in the example, such as when I press my search button on the form (and have the criteria set), so that I know the full count of the underlying query? 

[Iana Tsolova]

Hello Steve,

Indeed, you can set the VirtualItemCount in the NeedDataSource event handler.

Kind regards,
Iana
the Telerik team