How to change the schema via connection string when connecting to Oracle using Entity Framework?

Question

When I generated the EDMX file it set the Schema for each EntitySet

<EntitySet 
    Name="TableName"
    EntityType="Model.Store.TableName"
    store:Type="Tables"
    Schema="MySchema" />

The problem is that if I want to switch to the production database I have to change the EDMX since I don't know how to choose the Schema in the connection string.

How to do it?

Answer 1

I just had to edit the EDMX and remove the Schema from every EntitySet

<EntitySet 
    Name="TableName"
    EntityType="Model.Store.TableName"
    store:Type="Tables" />

Now it connects to the default schema for a given user.

Answer 2

If the code first method is an option you can override the OnModelCreating method in your DbContext class. In the OnModelCreating method you can put logic in to detect oracle and rename the schema accordingly. The code first approach has been asked about here.