Have you considered using the Entity Framework for data access instead of Linq to SQL ? It first appeared in the .NET Framework 3.5 and had a mixed reception. There's a new version of it in the latest .NET Framework 4.0 which I hear is much improved.
I've just created a very shoddy blog article about paging and sorting a GridView/ListView in which I used the Entity Framework to connect to the data (Microsoft's AdventureWorks sample database). You need to create an ADO.NET Entity Data Model project item which is under the Data category, give it a go.
I'm looking forward to seeing the next MVC blog article.
Have you considered using the Entity Framework for data access instead of Linq to SQL ? It first appeared in the .NET Framework 3.5 and had a mixed reception. There's a new version of it in the latest .NET Framework 4.0 which I hear is much improved.
I've just created a very shoddy blog article about paging and sorting a GridView/ListView in which I used the Entity Framework to connect to the data (Microsoft's AdventureWorks sample database). You need to create an ADO.NET Entity Data Model project item which is under the Data category, give it a go.
I'm looking forward to seeing the next MVC blog article.
Ian.