search

oracle / dotnet-db-samples

.NET code samples for Oracle database developers #OracleDotNet
http://otn.oracle.com/dotnet
MIT License
413 stars 191 forks source link

Failure to update model from oracle database using EF 5 and VS 2017 #2

Closed bilalmalik777 closed 6 years ago

bilalmalik777 commented 6 years ago

I have a C# application using Oracle database and Entity Framework 5. Oracle client is version 12c. My application uses database first approach. I'm trying to run the app using Visual Studio Professional 2017. When I access the edmx file and I try to update the model from the database, it gives me the following error

exception of type 'System.ArgumentException' occurred while attempting to update from the database. The exception message is: 'Unable to convert runtime connection string to its design-time equivalent. The libraries required to enable Visual Studio to communicate with the database for design purposes (DDEX provider) are not installed for provider 'Oracle.DataAccess.Client'. Connection string: XXXXX.

i have already installed oracle developer tool for visual studio 2017 Please help me to solve this issue

bilalmalik777 commented 6 years ago

i fixed this issue by installing ODAC

patrickgdl commented 6 years ago

@bilalMlaik can you help me? What ODAC did you use? Have you had any other procedure? ODT or just ODAC? Pleaseeee, help me

patrickgdl commented 6 years ago

Just for helping someone, this solution worked for me: installed the version 12.2.0.1.0 of ODT and then after went to the folder C:\Program Files (x86)\Oracle Developer Tools for VS2017\odt and installed Oracle.VsDevTools.15.0.vsix. Fixed on VS 2017 Community

sosam29 commented 5 years ago

Hi, Which version of Visual Studio are you using? As I tried all the above suggestions and I am still having the same issue.

yanjianyigaii commented 5 years ago

Hi, Which version of Visual Studio are you using? As I tried all the above suggestions and I am still having the same issue.

Same thing here. I had the latest version ODT installed for VS 2017 BUT GOT THE SAME ERROR WHEN UPDATING THE ENTITIES