SubSonic is a utility toolset for .NET to generate a complete Data Access Layer (DAL) and Rails-like scaffolding (Data editing forms per table) based on the database design of your application. The DAL can be generated at the compile time for ASP.NET applications and it injects the code into the memory without writing the code to the disk. This makes web applications much simpler and the DAL will be up to date with the database every time the application is build. If you need the DAL to be written to disk it can be done using the SubSonic’s web interface which will be useful to implement any other types of applications (ex: Windows Applications).
The most interesting part I noticed with SubSonic is that we do not need to write any SQL code or database connectivity code to manipulate data. The DAL it generates provides a comprehensive interface to do almost everything (Access to tables, views and stored procedures). We just need to write some configuration settings in the web configuration file including the database connection string. It is an open source project and licensed under Mozilla Public License (MPL).
At the end SubSonic realized me how important it is to refer different languages and see what they are keen on! Have a look at _[_Ruby On Rails](http://www.rubyonrails.org/).
Thanks Merill for the very useful presentation on SubSonic!