MVC + Nhibernate + Oracle Schema Configuration

Question

Our customer wants us to use a connectionstring with username = "external" and add schemaName "original" infront of our queries like:

"select columnA from original.TableA"

• I dont want to change mapping files which are shared by other projects,

• tried adding default schema as:

  <property name="default_schema">original</property>

But this doesn't work. Any Help?

Answer 1

At the end i added a key to the application settings and include default schema to the fluent nhibernate configuration.

Fluently.Configure().
Database(OracleClientConfiguration.
Oracle10.Dialect<Oracle10gDialect>().
Driver<OracleDriver>().
DefaultSchema(defaultSchema)