I'm upgrading a project to .net 4. My GridViews are using DataSets and implement filtering, sorting and paging using an ObjectDataSource.
What is the best practice to connect a GridView to a Linq query and implement sorting, filtering and paging?
Do i still use a DataSet and ObjectDataSource or is there a way to use another type of DataSource that let's me connect directly to a LINQ query result which handles the filtering, sorting and paging for me?
Edit:
There's busineseslogic in between the UI and DatabaseContext therefore connecting directly to my ORM isn't an option. It has to be against a LINQ query result (IQueryable). I'm using separate Insert/Update/Delete functions to handle business logic before talking to the ORM.