Are Oracle synonyms supported in Entity Framework?

Question

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

When I connect to a database in Visual Studio, this gives me the ability to add tables, views, and saved drives to my Entity Framework data model. In the server explorer pane, I see synonyms in the list.

Our database policy states that I only have access to synonyms, so unfortunately I cannot create a view or work with Entity Framework restrictions on the database side.

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

Any help would be greatly appreciated!

Answer 1

As far as I know, Entity Framework does not support synonyms yet. I recently had a similar problem that I overcame Views that you do not have at your service.

There are several workarounds , maybe you can use them.