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.
1 Answer
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

8 Comments
user5511576
Oracle Data Provider for .NET = Oracle.DataAccess . Check this link : oracle.com/technetwork/topics/dotnet/code-154692.html
ironstone13
@user5511576, sorry my bad - so you are not seeing the .NET tab, but have you installed the ODP.NET?
user5511576
that's correct! :(
ironstone13
@user5511576, have you tried installing it via NuGet? Please see my updated answer
user5511576
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!\
|