Are Oracle Synonyms Supported in Entity Framework?

Question

Are Oracle synonyms supported by Entity Framework, in any form?

When I connect to the database in Visual Studio, it only gives me the option to add Tables, Views and Stored Precedures to my Entity Framework Data Model. In the server explorer panel I can see the Synonyms in the list.

Our database policy mandates that I am only given access to synonyms, so unfortunately I cannot create a view, or work around Entity Framework's limitations on the database side.

Perhaps there is a way to manually create a data model and hook it up?

Any help would be much appreciated!

Answer 1

As far as I know the Entity Framework doesn't provide support for synonyms yet. I had a similar problem recently that I overcame with Views, which you don't have to your avail.

There are some workarounds, maybe you can use them.