How to work with synonyms

HDumas · Post by **HDumas** » Wed 21 Jul 2010 13:30

Hello,
Using VS2010, EF4 and DotConnect for Oracle 5.70.140.0.
Our DBA has created synonyms in the schema and I need to use them in my application as read only, mostly for combo boxes and lists.
I see a previous post dating January 2009 that it was an issue that you were working on for future builds...
Can you tell me if and when this new build will be available.
Thank you.

HDumas · Post by **HDumas** » Wed 21 Jul 2010 14:04

Just want to add...
If adding synonyms is not possble... then
1. Can I add public views to my EF4 OR
2. Maybe I could connect to another schema to get the views that I need??

Any other way I could do this??

AndreyR · Post by **AndreyR** » Thu 22 Jul 2010 15:06

There is no possibility to add proper support for synonyms in Entity Framework.
1. Sure you can add a view to your model. Please note that in case you are using Entity Data Model wizard there can be a problem beacause views don't have primary key, and in case when view does not have any not null columns it will not be shown in the model designer. As a solution, open the model in XML Editor and edit the Key attribute. This problem should not arise in Entity Developer (in case you add Devart eEntity model, or in standalone mode).
2. You can connect to another schema as well in case user you connect with has select privilege on the necessary tables.