How to work with synonyms

How to work with synonyms

Postby 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
 
Posts: 18
Joined: Fri 23 Sep 2005 12:56
Location: Quebec, Canada

Postby 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??
HDumas
 
Posts: 18
Joined: Fri 23 Sep 2005 12:56
Location: Quebec, Canada

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle