Search code examples
c#oracle-databasedevartdotconnect

Change Schema Name at Runtime in data context

So, I'm using dotConnect for Oracle. I used the template and wizard to create a model of the database (Database first approach). We have multiple databases that a single application needs to reference and unfortunately the schema naming which contain the tables are not uniform across the other databases.

In the auto generated class in the Designer.cs file I get:

[Table(Name = @"FMC_TP.EQUIPMENT")]

But considering which database connection the schema could be:

[Table(Name = @"FMC_DEV.EQUIPMENT"]

Is there a way to change the schema for the mapping at runtime?

Solution

  • In Oracle you can call alter session set current_schema = SCHEMA_NAME statement which set contex of your session. Then you can go without prefixing tables with schema name but this may help only if you're using same session for all statements.