CODEWITHSUNDEEP
oracle-databaseentity-frameworkvisual-studio-2017odacentity-data-model
Silmarie
Silmarie

Reputation: 21

Entity Data Model Wizard Gets Exception When Trying to Add a New Oracle Connection

I'm trying to generate/update an edmx model from an oracle database and I need to create a new connection to that oracle database. When I click "Test Connection" it succeeds but when I click "OK" it gives the following error:

Operation is not valid due to the current state of the object

VS 2017 error when adding new connection to update edmx model enter image description here

Upvotes: 2

Views: 1225

Answers (1)

Micke
Micke

Reputation: 2309

I had the exact same issue after a brand new installation of VS2017.

  1. Installed VS2017 (enterprise edition, in my case).
    • Previously ODT didn't work in the community edition, but Oracle might have fixed that.

  2. Installed Oracle Developer Tools for Visual Studio 2017

    • ODT broke VS2017 and I had to do a "repair", which fixed the problem where VS2017 wouldn't even start. This is where a started getting the problem you described.

  3. Reinstalled ODAC 12.2c Release 1 and Oracle Developer Tools for Visual Studio (12.2.0.1.0)

    • It was previously installed for VS2015.

Now, everything works as expected and I'm able to e.g. refresh my EF6 models.

Upvotes: 2

Related Questions