StrataFrame Forum

Business Object Mapper and Oracle Table Synonyms?

http://forum.strataframe.net/Topic10505.aspx

By Keith Harvey - 7/22/2007

Hi there,

Our application uses tables located in two Oracle schemas.  The first schema is our primary and we create Oracle table synonyms to access the tables in the second schema.  Is there a way to have the SF BOM "see" the table synonyms?

Is there a way to effectively map the tables in the second schema without causing any problems?

Cheers!

By StrataFrame Team - 7/23/2007

You can certainly map to tables in more than one schema, the business objects store off the schema in addition to the table name.  However, I don't believe the way that we're gathering the table names exposes the synonyms/aliases for any of the database objects.  But, since it will work at runtime, you can modify the TableName property of the business object that's generated by the BOMapper.  However, if you're going to change the value returned by the TableName property, I would go ahead and cut it from the partial class and put it in the main code file for the business object... that way, when you rebuild the partial, you'll get an error reminding you to go delete the property from the partial class, instead of overwriting it and you forgetting to go change it Wink