I know DNN 3.x/4.x has an enterprise level n-tier structure, you create the tables, the stored procedures, the data access layer (sqldataprovider and dataprovider), the business logic layer (controller and info), and finally the UI.  After writing tons of code (or using CodeSmith), a simple module can be created. 

Is anyone using a simplified n-tier design?  Create the tables, the stored procedures and then have a single middle-tier file that has the provider information, the data access, and the business logic. 

I think DNN is the greatest thing, but just seems to be a bit of a overkill on some of the smaller sites that I'm working on.  Especially since ASP.NET 2.0 and VS Express makes designing a data access site very fast using SQL Express and the use of TableAdapters.