I downloaded the Oracle Data Access components for Microsoft Entity Framework and LINQ beta, and am facing a strange issue with it.
Whenever I run the Entity Model creation wizard, I only get the list of tables from my default schema (i guess, the one for which the specified user ID has default rights).
I have read access to multiple schemas and I can see those tables if I set this from the filters tab in the new connection dialog box (shown when adding a new connection in the Add Connection option of the Visual Studio Server Explorer).
Could anyone help in getting the list of all the tables from all the schemas on which I have the read access? Or, Is this even possible in this beta?
If this is not the correct forum for this kind of question, please help in redirecting it to an appropriate community.
I believe you were using a very old Beta. This issue should have been fixed in a newer Beta version.
Can you try ODAC 11.2 Release 4 (18.104.22.168.0) version
and let us know if this issue persists?
i am facing the same issuue. I configured the filters to see all schemas the user has access to. Server explorer shows all tables from all schemas. When starting the entity model wizard it only shows tables from the default schema with the schema name they are belonging to in brackets behind the table name.
This suggests it probably is intended to show tables from other schemas to.
I am experiencing this issue too, using v 22.214.171.124.0.
My colleague is using v 126.96.36.199.2 and did not have this issue. Should I roll back to that version? The Oracle download page does not indicate that Entity Framework is supported until the latest release though.
Here's a workaround to the problem:
Expand the Visual Studio Server Explorer Tables node under the connection before invoking the EDM wizard.
As long as you do this before trying to read the schema objects in the EDM wizard, you'll be able to see other schemas you have privileges to see. And don't forget to set up your Server Explorer filters, such that the primary Oracle user can view the other user's schema objects.
For the workaround to work, enable 'save password' in the connection properties as well.
Edited by: Alex Keh - Oracle Product Manager on Jul 31, 2012 12:08 PM
What version of Entity framework did you tried for your work around?
I'm on oracle drivers: 188.8.131.52.0
Open the solution
Open the Server Explorer and expand the table node (it open the connection to the server)
Open my Edmx file
Click on "Update from Database"
And when the wizard opened, I can't see the tables other from the default schema.
thanks for your help
By the way, any date for the next release with a fix?