In a look back at what I have put up this year, here are the posts that have been most frequently visited: LINQ Distinct, a DataTable and the IEqualityComparer<T> Using Database Projects for Visual Studio Custom Entity Classes Using LINQ to SQL (Series) Implementing Interfaces: ICloneable and IComparable ASP.NET Ajax, JQuery & JSON Date Serialization There you have it! I hope that these articles have helped. I have had a lot of fun this year, my first year blogging. It is ve... [More]

So this is what it has come to anymore. Everyone is all about server side paging via SQL Server. As well they should be! It is so much faster and more efficient than having ADO or ADO.NET bring back a ton of records and then chop it to page it. However, there has always been some problems when trying to accomplish this task, especially using a SQL database that is pre 2005. This task is easier to accomplish in SQL 2005 and 2008 using the ROW_NUMBER() function. The part that gets flaky is having a dynamic o... [More]