Thanks, Marcel. I do agree that if you run a tool against a relational database, and let it create classes that are 1:1 with your tables, you'll be in trouble. (Although, that approach often works just fine in simple content management systems for websites, for example). I'm just not so sure that the reverse approach works completely, either. In other words, I don't know that you can completely infer an accurate and performant database model from a DSL model built to serve as a class diagram. One issue is that any changes that need to be made to the DB structure after generation would somehow need to be managed and tracked along with the project(s) as well. Another issue is that versioning and multi-developer use of this system is going to be difficult. (I'm thinking about source control here)
I really think to make this thing go from useful to brilliant, it needs to be 2-directional. One would need to be able to map properties in their objects to fields in the database. There is a great tool for CSLA that's been around for a while. It pulls in the database model, and lets you create CSLA objects by selecting fields from tables, views, or sproc result sets. It has support for Authorization, Business Rules, Lazy Loading, Active Objects (an excellent implementation of the observer pattern), and more. It even navigates the relationships in the DB to generate the CRUD sprocs. [CSLAGen - http://groups.google.com/group/CslaGenerator]
I'm not promoting them, just suggesting that the tool is incredibly useful, as yours will likely be. Why is it not Brilliant? No visual model.
You are left with a list of objects, and no way to see the relationship between any of them. Of course, those relationships are there. You use the property grid to select objects that are child properties of other objects, for example. There is just not a visual aid. So while it can let you build the entire behavior focused BO Library from an existing, well designed, purely relational database, it can be very difficult to see the big picture.
Just food for thought. V2 maybe.
Best wishes on rolling out something soon!
Kevin