Robert Q Johnson
06.30.2012
1 Solution
Hi Robert,
Thank you for your question. To generate persistent classes from existing database tables or to create and edit them visually, use the new ORM Data Model Designer.
Please let us know if you need any additional assistance.
-
I'm not sure how you think this answers my questions. The link you offer shows me how to use some feature of XAF (which I don't believe I own in my license) that permits me to build the objects one property at a time, manually typing their names, etc.
I just can't do this. I'm looking for a tool that will allow me to point it at a database and tell it to make business objects in my code project whose names are the tables and whose properties are the field names. I'll grant you that it's pretty primitive ORM work. But it's all I need. Some of my apps use dozens of the tables in the database with which I always interact (which has almost 300 tables). So I'm trying to find something that can build a couple of dozen business objects (including capturing the nature of the relationships between parent and child tables) in a minute or two, rather than the several hours it seems such a task will take with the tool you pointed me to.
Am I making my requirements a little clearer? Sorry for any initial confusion.
Q
-
The tool Michael referred to is included with XPO, and it'll generate persistent classes, including modelling the parent<-> child relationships (I just tried it on a 'known' database with ~100 tables, it took a couple of minutes to generate the model / code and the results looked to be pretty good). However, automatically creating consolidated business objects based only on the existing tables would seem to be a pretty hard ask from any automatic tool.
-
I have referred to that XAF article because we do not have a similar one in the XPO documentation yet. We will extend the XPO documentation with future releases. To generate classes from an existing database, choose the "Map to an existing database" option on the first wizard page, specify connection parameters, and select tables, columns, and stored procedures you want to generate classes for.
Is your intention to post an answer to your own question?
- If so, then proceed.
- If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
- If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.
Facebook
Twitter
Google+