What tools are available for automatically generating the SqlDatProvicer and related classes for a module from the base table?  I'm aware of Codesmith but was wondering if there were any other more simplified tools jsut focused on this task?

Check out Bonosoft's tool at http://www.bonosoft.dk/Default.aspx?tabid=36

I'm not sure if it supports .Net 2.0 but it's earlier releases did a great job.  It generates C# and VB.Net.

---

Professional DNN Extensions, custom solutions and mobile apps since 2003.
www.OnyakTech.com

Check out EntitySpaces. Our architecture / object persistence layer, doesn't have the controller info form of DNN, but can be used on any .NET 2.0 app Web or Winform. We have many features not available in the DNN DAL, and even have templates to generate Data Driven UI's which can be used as modules with no code whatsoever from you. Here are some of the features:

Features:

• Serialization
• Nullable types
• Powerful dynamic queries
• Saving via stored procedures or dynamic SQL
• Two different transaction models
• Design time data binding
• Generated from your database schema
• Regenerate without losing custom business logic
• Admin Grid Template suite for ASP.NET (new)
• Admin Grid Template suite for DotNetNuke (beta)

Providers Available:

• Microsoft SQL Server
• Microsoft Access
• Oracle
• MySQL

Currently in our 1.5.0 Beta

• Hierarchical support
• LINQ Support