Tables from second schema are not visible in Entities Wizard

Question

I want to add ADO.NET Entity Data Model to my project. I am using Oracle database and Oracle ODP.NET to connect to the database.

I need to query from two schemas. So I configured my connection to use two different Schemas (using the information I found in another SO question ).

The tables are visible in my Server explorer. But they are not visible in ADO.NET Entity Data Model Adding wizard. It shows only tables from the first schema and they have schema name in front:

TableName(SchemaName). 

What must I do to see tables from both schemas?

Answer 1

UPDATE: I had a very similar problem and this workaround found in the Oracle forums helped me. The aformentioned workaround did not seem to make into Oracle's new forums area. Please see my SO answer here for more details.

Summary: In VS2012 with the latest ODAC, when you set up connection filter criteria you always have to include the default schema along with whatever schema you want.

For some reason, I didn't have to do that in VS2010 with previous version of ODAC.

Answer 2

This is a known bug. I too suffer from it and at one point it went away, but now has returned for me. Oracle is aware of it and hopefully will fix it with the next ODAC release. See here for a thread concerning it:

https://forums.oracle.com/forums/thread.jspa?messageID=10396897

Reply from Oracle Employee:

Posted: May 2, 2012 3:53 PM

We've been able to reproduce this bug at Oracle and are currently investigating a solution. We hope to include this bug fix in the next release.