EDIT: 2008-05-26

See the "ES2008 UserData Template" section below for ES2008 specific instructions.

ES2007 Instructions

If your table or column names are not producing the EntitySpaces class or property names you want, you can use MyGeneration to give them an Alias, and regenerate. Here's how:

• Open MyGeneration.
• Click on the "L" toolbar button. (This is for "Local User Meta Data".)
• Open the MyGeneration "MyMeta Browser" window (3rd toolbar button from the left.)
• In the MyMeta Browser dockable window, expand your database.
• Click on (not expand) the "Tables" node in the tree.
• In the User Meta Data window, you can give any Table an alias.
• Press the little save icon in the dockable window.
• Regenerate (you might have to close/re-open MyGeneration for them to take.)

In the printscreen below, we've opened MyMeta Browser and Local User Meta Data docking windows. The objective is to get rid of the space in "Order Details". (Note: This is not necessary for EntitySpaces. EntitySpaces PascalCases tables/columns for you. This is just an example of what you can accomplish.)

1. We clicked on "Tables" under Northwind.
2. We changed the default "Order Details" Alias and hit "Enter".
3. We clicked the Save icon that appeared.

You can do the same for columns by clicking on (not expanding) the "Columns" node under each table in the MyMeta Browser.

EDIT: 2008-05-26

ES2008 UserData Template

Since we are using our own EntitySpaces MetadataEngine, we use our own esUserData.xml file for aliasing tables and columns in MyGeneration and CodeSmith. We install a UserData template that provides similar functionality for ES 2008 as MyGeneration's UserMetaData. On first use, the template converts UserMetaData.xml (which is where MyGeneration stores its aliases for use with ES2007), into esUserData.xml. From that point on, you would alias columns and tables for EntitySpaces by using our template. We'll get it better documented, but the look and usage is almost identical to that described above.

• Open MyGeneration, or CodeSmith.
• Expand the EntitySpaces 2008 namespace in the Template Browser in MyGeneration, or template folder shortcut in CodeSmith.
• Execute the UserData template.
• In the window on the left, expand your database.
• Click on (not expand) the "Tables" node in the tree.
• In the right window, you can give any Table an alias.
• Press the little save icon at the top of the right window.
• Regenerate your Generated Master.

You can alias individual columns, simply by navigating further into the tree. 

The UserData template itself does not generate code. As soon as you click the Save icon, your changes are written to esUserData.xml. After that, you can just close the template UI. But, you need to regenerate your classes to get the benefit. If you've aliased a table name, and have already added code to your custom classes, you will have to manually modify the class name in the file. Custom classes are set to not over-write. If you have no custom code in them, and wish to regenerate them as well, you will need to delete them from your project folder, first.

This template can also be used to store sequence and concurrency information for use in our Oracle templates.

EDIT: 2008-08-13 - Revised the ES2008 instructions to make it clear that the same technique is available in CodeSmith.