Error synchronizing oracle database with entity framework

Question

Error synchronizing oracle database with entity framework

Navigation

#1 by (0 votes)

0

When updating the database model so that it takes changes to the schema of the database, it shows me this error:

An exception of type 'System.ArgumentException' was thrown when trying to update from the database. The exception message is: 'The runtime connection string can not be converted to its design-time equivalent The libraries required for Visual Studio to communicate with the database for design tasks (DDEX provider) are not installed for the provider 'Oracle.ManagedDataAccess.Client' Connection string: DATA SOURCE = ooo.ccc.int: 1521 / orr; PASSWORD = PARTNER; PERSIST SECURITY INFO = true; USER ID = PARTNER '

I have made a connection to this scheme from the server browser and there is no problem.

Thanks for the help,

c# oracle entity-framework visual-studio-2017

asked by Ststecnico 23.10.2018 в 11:02

source

1 answer

Change the value of a textarea from buttons in CKEDITOR - Laravel Problem when running a stored procedure does not execute the change in c # mysql, mysql and workbench

score 0 · Answer 1

I understand you have a .edmx that you want to update

In the project where the .edmx is found you should have a app.config where the connection string is defined in the way it requires it

The form is something like this:

<add name="Northwind_Entities"  
     connectionString="metadata=res://*/Northwind.csdl|  
                                res://*/Northwind.ssdl|  
                                res://*/Northwind.msl;  
                       provider=System.Data.SqlClient;  
                       provider connection string=  
                           &quot;Data Source=.\sqlexpress;  
                                 Initial Catalog=Northwind;  
                                 Integrated Security=True;  
                                 MultipleActiveResultSets=True&quot;"  
     providerName="System.Data.EntityClient"/>

explains it in the title "Database / Model First with connection string in app.config / web.config file"

Connection strings and models

you must validate that you define it that way in the .config of the project where the edmx

is

Where I point is that it is not a simple string conenction, but the edmx requires those metadata to be able to solve the model