Paging isn't always the easiest thing to figure out - and sometimes not the most performant thing you can do to a we site. Here's a webcast to show you how to set it up both ways: the ASP way, and the SubSonic way.

Subsonic makes working with stored procedures and your database simple. This writeup was stolen from Kevin Fricovsky - thanks Kevin ! Getting Started The SubSonic team obviously decided right out of the gate that allowing developers to use stored procedures was a main concern. SubSonic doesn't force you or limit you to make use of the generated ORM data access layer. That's right, believe it or not ActiveRecord doesn't solve all your problems. Sometimes a good 'ol stored procedure is the best answer to getting the data out of your system and back to the user. It's all about Provider Configuration...

(Starting with version 2.1, this query tool has been superceded. We've left all the good stuff here in place - but please be sure to view this post here if you're using 2.1+) Let's Watch a Movie... Using the Query Tool This webcast shows you some really neat tricks to do with the Query Tool. Dynamic Query Tool The Dynamic Query Tool is a very versatile class that will allow you to do 90% of the queries you need. Our position on the more complex queries (using ORs, Joins, etc) is to use Views or Stored Procedures and have SubSonic wrap them for you that way. The query tool uses what's been coined...