Subsonic is an ideal option to automatic generation of DAL

To day i worked with sub sonic. its master piece. it creates a class for every table present in the database. fetchall function gives faciltiy of returning all the rows from table. there are two methods insert and update to support object data source. there are two controls which are most useful in the point web developer scuffold, quick table. for more details go through www.subsonicproject.com