I've been trying SubSonic 2 for few days now and it looks pretty cool, I had some problems with updating and deleting record but that seems to be fixed by now. I think that about a two year or so we will be very close to let a website generate it self just by database. SubSonic is pretty far from there but I can defenently see it in the future.

Added few links to the site, just what I remeber at the moment