The DAL is a click away

by mgordon 11. June 2007 11:00
I recently started working on a personal project and decided to give Subsonic a try at the same time.  Subsonic is a DAL generation tool and it simply rocks!  I spent maybe an hour or so watching the helpful videos provided on the site to learn the basics of setting the tool up, configuring it in the .config file and wiring it up to visual studio as an external tool.  After it was set up, I was generating data transport/business classes and data access code from my database in no time.   Subsonic generates business objects and collections that know how to retrieve by criteria and how to save themselves.  Stored procedures are supported, as well.  While I'm not yet a big fan of the query tool, it can be used to generate queries in code without resorting to managing dynamic sql as strings.  I tend to be old school in some ways and still prefer to use stored procedures to manipulate database.  Even so, Subsonic offers me the ability to call any stored procedure on my database with a single line of code.  It supports Sql Server, MySql and Oracle. Again, I love being more productive.  Subsonic helps me be as productive as possible by relieving me of having to write as much code.

Tags: , ,

.Net | Productivity | Database

Comments are closed

Powered by BlogEngine.NET 1.5.0.7
Theme by Extensive SEO