Connect to several schemas
Posted: Fri 23 Apr 2010 14:11
Hello,
I use Oracle XE 10g for development. Our customers (say CustomerA and CustomerB) use the same tables (mapped into entities) and use different stored procedures for internal logic. These stored procedures are not imported functions and have no relation to EF. For development purposes I want to quick switch between customers schemas but schema is hardcoded in SSDL. Is there any way to specify schema in connection string or specify some kind of scheme synonym (is it possible in Oracle?) or whatever...?
I use Oracle XE 10g for development. Our customers (say CustomerA and CustomerB) use the same tables (mapped into entities) and use different stored procedures for internal logic. These stored procedures are not imported functions and have no relation to EF. For development purposes I want to quick switch between customers schemas but schema is hardcoded in SSDL. Is there any way to specify schema in connection string or specify some kind of scheme synonym (is it possible in Oracle?) or whatever...?