I first mentioned SubSonic, a .NET DAL framework, almost a year ago in a post discussing my decision regarding a DAL framework for use in an ASP.NET project I was working on. When I made my decision Subsonic was in it’s very early stages of development but peaked my interest nonetheless. I think it’s interesting that a little over a week ago I decided to use SubSonic for a project at work and now Rob Conery, Subsonic’s primary developer, has joined Microsoft to continue development as part of the new MVC framework.
If you haven’t looked at SubSonic, it’s well worth a try particularly if your database consistently makes use foreign keys allowing for the generated object model to provide deep navigation capabilities for lookup field values etc. I’m working on a large ERP system with a database of 300+ tables and generating a SubSonic assembly took only a few minutes. At any rate, it’s always nice when an OS project you’ve chosen receives this sort of backing offering at least some reassurance.
[UPDATE: Jan 10, 2007] Fix spelling of Rob’s name.