Is Oracle NOW fully supported by .NET entity framework?

Are Oracle Synonyms Supported in Entity Framework?

  • 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:

    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 http://stackoverflow.com/questions/6036357/making-an-entity-framework-model-span-multiple-databases, maybe you can use them.

Matt at Stack Overflow Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.