I have a serious problem that needs to be resolved.
In my server explorer in VS2013, I established a database connection with valid user credentials and password.
So, I have a schema called Connect1, and it must have access to another schema called Connect2, as under the same data source name: Dev1. The user I'm connecting to is called Connect1, so by default I'm connected to Connect1. I was able to verify that I have permissions for this user to connect to Connect2.
Using the ODP.NET managed driver, I was able to install this. Enter all connection details.
The configurations are shown on this page:
Using Oracle Developer Tools for Visual Studio
In order to allow viewing of the schemes, I had to change the "Filters" tab and add all the related schemes that I use (by adding Connect2). Then I click update, and I can use these tables in the edmx file.
However, the problem occurs when I close Visual Studios. My filter was lost, and my connection returned to using only Connect1.
Then it destroys my table mapping in my edmx to series
Error 11007: Object type "Table1" is not displayed.
This is really frustrating since I will have to repeat the same procedure over and over again, manually reassigning all my tables.
, Server Explorer, . EF ; . , , , , , Connect2 .