-3

I am using System.Data.OracleClient which has been deprecated. Any suggestion will be appreciated on how and what should I do to replace System.Data.OracleClient. I have tried to Add Oracle.DataAccess by going to solution explorer , add reference. Oracle.DataAccess is not shoiwing in my avaialble options (I do not have the .NET tab). Thanks in advance.

user5511576
  • 37
  • 2
  • 11

1 Answers1

1

Why not use Oracle Data Provider for .NET from Oracle?

According to MSDN

The types in System.Data.OracleClient are deprecated. The types remain supported in the current version of.NET Framework but will be removed in a future release. Microsoft recommends that you use a third-party Oracle provider.

You could install this library as a NuGet package as described here enter image description here

ironstone13
  • 3,325
  • 18
  • 24
  • Oracle Data Provider for .NET = Oracle.DataAccess . Check this link : http://www.oracle.com/technetwork/topics/dotnet/code-154692.html – user5511576 Sep 27 '17 at 19:00
  • @user5511576, sorry my bad - so you are not seeing the .NET tab, but have you installed the ODP.NET? – ironstone13 Sep 27 '17 at 19:02
  • that's correct! :( – user5511576 Sep 27 '17 at 19:14
  • @user5511576, have you tried installing it via NuGet? Please see my updated answer – ironstone13 Sep 27 '17 at 19:18
  • no, I have not. I am giving it a try . Hopefully I'll be all set. Fingers crossed. Will update you tomorrow about how it goes. Thanks bunch!\ – user5511576 Sep 27 '17 at 19:23
  • @user5511576, give it a shot, good luck! – ironstone13 Sep 27 '17 at 19:24
  • Hi @user5511576, how did it go? Is your problem solved? If everything worked out, please mark this as the correct answer. Best regards! – ironstone13 Sep 29 '17 at 18:58
  • Hi ironstone13, I ended up using Visual Studio 2015, and I was able to use my application correctly. I used your suggested method to add the Oracle.DataAccess. However, it is a unmanaged driver and was not working properly. Found a forum where they suggested using an older version of visual Studio, and that worked for me !Thanks for your input though. I did mark your answer as the correct one since I was able to add it. – user5511576 Sep 29 '17 at 21:20