Page 1 of 1

How to work with synonyms

Posted: Wed 21 Jul 2010 13:30
by HDumas
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.

Posted: Wed 21 Jul 2010 14:04
by HDumas
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??

Posted: Thu 22 Jul 2010 15:06
by AndreyR
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.