'metadata' is an invalid connection string attribute in ASP.Net MVC using Oracle

Question

In my controller I have a JsonResult function called by a Javascript that's called by a button in View. this will save input from textbox to database table. But in it's first line of code (connecting to Oracle), it's alread having an error:

using (var con = new OracleConnection(ConfigurationManager.ConnectionStrings["DBEntities"].ConnectionString))

An exception of type 'System.ArgumentException' occurred in Oracle.DataAccess.dll but was not handled in user code

Additional information: 'metadata' is an invalid connection string attribute

Here's my auto-generated connectionString in web.config:

<add name="DBEntities" connectionString="metadata=res://*/DBModel.csdl|res://*/DBModel.ssdl|res://*/DBModel.msl;provider=Oracle.ManagedDataAccess.Client;provider connection string=&quot;DATA SOURCE=DBDEV;PASSWORD=db;PERSIST SECURITY INFO=True;USER ID=db&quot;" providerName="System.Data.EntityClient" />

What seems to be the problem? And how do I fix it?

Possible duplicate of Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found — Ravi A.
– Ravi A., Commented Aug 5, 2016 at 3:45
I believe the link you posted is not the same with mine. They don't even mention there the metadata connectionstring — Harambe Attack Helicopter
– Harambe Attack Helicopter, Commented Aug 5, 2016 at 6:10
Not exact duplicate but those are the steps you need to follow to connect with Oracle DB in EF code first approach. It talks about how connection string should exactly look like when using Oracle DB with EF. — Ravi A.
– Ravi A., Commented Aug 5, 2016 at 6:14
I tried the solution but it didn't fix my problem. Same System.ArgumentException error — Harambe Attack Helicopter
– Harambe Attack Helicopter, Commented Aug 5, 2016 at 8:28

jozolo · Accepted Answer · 2019-10-25 18:04:34Z

1

I had this same issue and resolved it using this post: Keyword Not Supported: Metadata

The trick is because it is Oracle you need to change your string to something like this:

<add name="DBEntities" connectionString="DATA SOURCE=DBDEV;PASSWORD=db;PERSIST SECURITY INFO=True;USER ID=db&quot;" providerName="Oracle.ManagedDataAccess.Client" />

I know this post is super old, but hopefully this helps someone else.

answered Oct 25, 2019 at 18:04

jozolo

3674 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user10285265 Over a year ago

Lose the end quote. It's only the silly EF which uses it. <add name="DBEntities" connectionString="DATA SOURCE=DBDEV;PASSWORD=db;PERSIST SECURITY INFO=True;USER ID=userId" providerName="Oracle.ManagedDataAccess.Client" />

Collectives™ on Stack Overflow

'metadata' is an invalid connection string attribute in ASP.Net MVC using Oracle

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related