You can download an updated version os SubSonic that fixes a number of bugs. SubSonic uses T4 Templates to generate classes for your data access layer. You not only get a nice ActiveRecord Pattern that makes it really easy to access your database, but you also have the ability to use LINQ to query the underlying database as well.
Obviously there are a number of O/R Mappers and Code Generators that make data access in your web application pretty easy. However, if you are currently in a love-hate relationship with your current data access layer solution, you may want to download the latest version of SubSonic here.
We will be talking about another O/R Mapper ActiveRecord solution at this month's Sarasota Web Developer Group Meeting: Castle ActiveRecord. If you are a web developer in the Sarasota, Florida area, check out the meeting: Leveraging ASP.NET MVC - Web Forms - DynamicData - Castle ActiveRecord.
David Hayden
O/R Mappers