Issue using the Oracle Command Parameters

Question

Trying to create a Web API which queries the Oracle DB which receives the input as array of String.So trying to add Command Parameters

I added the following references System.Data.OracleClient.dll also,

using Oracle.ManagedDataAccess.Client;
using Oracle.ManagedDataAccess.Client.OracleParameter;
using System.Data.OracleClient;
using System.Data.OracleClient.OracleParameter;

But getting error as below

`A using namespace directive can only be applied to namespaces; 'Oracle.ManagedDataAccess.Client.OracleParameter' is a type not a namespace

A using namespace directive can only be applied to namespaces; 'System.Data.OracleClient.OracleParameter' is a type not a namespace `

Richard · Accepted Answer · 2016-08-04 03:07:38Z

5

You are trying to use both Oracle's Oracle client (Oracle.ManagedDataAccess.Client) and Microsoft's Oracle client (System.Data.OracleClient). You should pick one of them. However, I think the Microsoft one is deprecated in more recent .Net Framework releases so you're probably better off with Oracle's implementation.

answered Aug 4, 2016 at 3:07

Richard

1431 silver badge6 bronze badges

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

12 Comments

trx Over a year ago

Which one should I be adding here

trx Over a year ago

If I just add using System.Data.OracleClient.OracleParameter getting Error 1 A using namespace directive can only be applied to namespaces; 'System.Data.OracleClient.OracleParameter' is a type not a namespace

Hambone Over a year ago

Exactly. System.Data.OracleClient has been depricated for a LONG time. And it's beyond terrible. If you are using a Web app, I'd use standard ODP.net rather than the managed client. The managed client is fine, but it's missing functionality in the original version such as bulk inserts.

Hambone Over a year ago

And parameters on System.Data.OracleClient are beyond terrible. Seriously, switch now!

Richard Over a year ago

I myself would use the Oracle.ManagedDataAccess.Client because the Microsoft isn't available in the more recent versions of the .Net framework.

|

Collectives™ on Stack Overflow

Issue using the Oracle Command Parameters

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related