Thanks to Haacked for the post.

For us who have been developing for years, we are bone tired of repeating the same process every time we build new applications. We create the same layers, follow the same naming conventions and use the same database structures. At some point we have all tried to automate our development process, as for me I've been using codesmith to generate starter code given a database and it pretty much puts right about 10% of the project.

The code generated from codesmith, covers all of the basic in/out of the database such as error handling, store procedures, data access layer, extended data access layer and other stuff that are usually optional but again, it gives me a head start instead of spending a week doing it all over again.

OK, to the point - the ASP.NET Action pack seems to be ideal when it comes to my situation. Few settings here and there and I'll have complete access to my database from within my code behind including intelli-sense. The action pack, definitely includes some big bang and we need to keep an eye on it, it supports several db providers and more. As I'm all for simple ASP.NET development, I'm loving it.

Yes, there are some things that you will have to do manually such as special queries, presentation, business logic and more.

You can do so much with the action pack that I strongly suggest that you watch the cast here.