EntitySpaces, LLC has created a new provider independent DAL for the Microsoft .NET 2.0 Framework. The EntitySpaces ^TM architecture is generated via a set of templates by the popular MyGeneration code generator and OR Mapping tool. The EntitySpaces architecture works great as DAL for DotNetNuke.

We have a sample GuestBook module that has been built using both EntitySpaces and AJAX on our site. The source to the module plus an overview of the module, including how it was built, is also available.

 EntitySpaces offers DNN module developers an unprecedented feature set.

•  Provider Independent DynamicQueries (no stored procedures necessary)
• Ability to Save via stored procedures or dynamic SQL
• Transaction support - both local ADO.NET and Distributed Transactions
• Serialization Support
• Webservice Support 

And coming in a release very soon both hierachical object models and .NET remoting support. Below is an example of how the GuestBook module writes a record to the GuestBook table.

 using (esTransactionScope scope = new esTransactionScope())
{
    GuestBook objGuestBook = new GuestBook();
    objGuestBook.AddNew();
    objGuestBook.ModuleId = this.ModuleId;
    objGuestBook.UserId = this.UserId;
    objGuestBook.Message = eventArgument;
    objGuestBook.PostedOn = DateTime.Now;
    objGuestBook.Save();
    scope.Complete();
} 

See http://www.entityspaces.net for more information.