I am a great fan of MyGeneration and really love the DOODAD architecture. I always mentioned it was very easy to use and you would generate a complete DAL in minutes. in 6 minutes to be precise. Don't believe me, have a look at this link http://blog.donews.com/venliong/archive/2006/04/06/814969.aspx and see it really takes 6 minutes to generate a complete DAL.
I am still using Mygeneration in my everyday projects and must say that once I started with it, I am a lot more productive.
Nicer templates are becoming available everyday, so now it's possible to generate various Web Pages / Windows Forms for data entry. (they al use DOODADS as the DAL).
Besides DOODADS there is also support for NHIBERNATE and various other types of data access. Really worth to have a look at it.
Also worth mentioning is the EntitySpaces project. The guys from MyGeneration have cooked up some new datalayer called Entityspaces. This product is getting more professional by the day and is specifically targeted to .Net 2.0. Go and have a look at that as well here is the link : http://www.entityspaces.net/Portal/Default.aspx
Some of the highlights are :
The EntitySpaces architecture for .NET is a new architecture for the Microsoft .NET 2.0 Framework. The EntitySpaces architecture is database independent. The data providers are loosely coupled to your application and allow you to use the same compiled code to access a whole host of databases.
- Simple, yet powerful, dynamic queries
- Saving via stored procedures or dynamic SQL
- Two different transaction models
- Design time data binding
- Generated and custom class isolation
- Generated from your database schema
- Hierarchical support
- .NET remoting