SubSonic is an open-source toolset, created by Rob Conery, as an attempt to put the fun back into programming and just get the job done. Inspired by Ruby on Rails, SubSonic takes a minimalist approach to coding and emphasizes convention over configuration. While it takes its inspiration from Ruby on Rails, it is not a port of it. (Check out MonoRail it that's what you're looking for.) Instead, SubSonic takes the best ideas of Ruby on Rails and adapts them into the already existing ASP.NET framework. Currently SubSonic, version 1.05, implements two core features:
ActiveRecord
This design pattern in its simplest form is one class per database table, one object per database row. SubSonic includes a build-time code generator to implement this pattern that acts as an object-relational mapper eliminating the need to write SQL. It also includes a dynamic query tool and simple store procedure support to extend the model when needed.
Scaffolding
Admin pages are a chore that scaffolding helps remove. Simply point a scaffold control at a table and you get the standard grid view and detail view to find and update data in the underlying table. While not meant to ever be shown to users, it makes a nice, quick and easy developer tool.
Find the entire series of posts here.