I'm using GenPro v3.5 with the adapter model (database first model).
I have an application that accesses related data from multiple databases. For example: The primary user table is in a SQL server database and user related data is in an Oracle database (no true FK relationship, but the user id values do match). In the designer I can add both SQL+Oracle catalogs and create the entities but I get errors saying...
The entity 'User' doesn't have a mapping to a target element in the target database with driver 'Oracle 9i/10g/11g Driver (MS Oracle)'
I was hoping to create the entities in 1 designer and relate them so I can use prefetches to get the user related data (from Oracle) when getting the user entity (from SQL). Is this possible? or do I need to create seperate projects for each one and perform any joining of the data via other code? If prefetches can't be used across databases, can I manage all of my entities from different databases in 1 designer project?
I saw a few older posts (7 years back) saying it wasn't supported but not sure if things have changed.
Thanks!
