Tips and Tricks in a world of Mix

After installing the ODT and updating it after to work with VS2012 to ODAC 11.2.0.3.20 with Oracle Developer Tools for Visual Studio on the same Oracle Client Home

I was able to create the EDMX model , but the synonyms stayed hidden to me on the wizard of the VS (by the way at VS 2010 also) .

The connection works perfect and gets me the regular tables , views and stored procedures .

The trouble is with the rest .

ScreenShot631

ScreenShot629

 

From my approach to Oracle I’ve got a couple of links and a statement that it’s Microsoft’s product that doesn’t support the import at the initialization wizard.

The links provided –

1) Make Entity Framework Designer support Synonyms  – we are not Code First – the schema exists and running

2)A problem to view synonym of Oracle in the Entity Data Model Designer – can’t see the synonyms , not with dba not with any user ..

 

Any ideas will be appreciated!

Comments on: "Synonym of Oracle is missing– Is the Oracle False messiah ?!" (2)

  1. Luisa said:

    I have the same problem, I can’t to import the synonym😦

  2. You should do it with system rules and then synonyms are shown as tables
    After that you should connect with less privilege scheme user and it will still work with the objects created

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Tag Cloud

%d bloggers like this: