The following is a great example i found of how to use SQL paging, LINQ, and an ObjectDataSource to support efficient paging for an ASP.Net Gridview or ListView.
http://mosesofegypt.net/post/Building-Custom-Paging-with-LINQ2c-ListView2c-DataPager-and-ObjectDataSource.aspx
I still need to research how LINQ and DataContext classes work...
Tags: asp.net gridview, objectdatasource, linq to sql, paging