SubSonic will be your friend, will never tell you you're dumb, and will do whatever it takes to get you home earlier, convincing you that too many hours spent at work turn you into a potato.
Part of using SubSonic is the letting go of a lot of things that you may cling to, and letting our convention take over (ideally our convention and the things you cling to are the same. Sometimes not though).
All of the approaches SubSonic uses are based on the idea that we don't want to get in your way. Each of the approaches below (except for SimpleRepository) relies on code generated by T4 templates. If you don't like something - change it! It's easy to do and if you tweak the templates enough, share them with us!
If you're the kind of person who wants to do things your way, SimpleRepository is for you. You can code your objects the way you like (with some minor convention tweaks) and the SimpleRepository will save them for you. It will also create your database on the fly if you want, altering the schema as you change your object.
If you like having to do as little as possible with your data access, ActiveRecord makes this very, very simple. You don't need to create a lot of extra objects or know how the guts of anything work. It's as simple as asking for a new object and calling a Save() method.
If you like Linq to Sql and want the convenience of a Repository for testing, we have that worked up for you as well.
Linq To SubSonic
At the core of SubSonic's templates is Linq to SubSonic. Originally created by Matt Warren, our Linq tool allows you to create your own Linq implementation very, very easily.