This content has been marked as final. Show 3 replies
By default the connection only shows you certain schemas. You can get EF To show you more of them in this way:
In Server Explorer right click on the connection and go to "modify connection". Then click on the "Filters" tab.
One of the filters is for Displayed Schema. You can have multiple values in that, so you need to add the schemas you want to see to it and save the connection.
This is simply not working for me. I installed the latest 11g ODP.net and developer tools for Visual Studio 2010. When I try to add an ADO Entity Framework model to my project (regardless of whether I create a new connection on the spot or use an existing one) the Wizard just does not see the tables from the schema I specify in the connection. I can only see the objects created by my user ID. Test Connection works fine. However, in the server explorer for my connection I can see all the tables from my target schema. This is extremely frustrating.
I read somewhere else that your ID needs to be specifically granted Select on the tables. Can't be "Select any table". Also, all our grants are done for groups; not individual IDs.
Try expanding server explorer and the Tables node before invoking the EF wizard There's a known bug with that, and opening server explorer first works around it.