locked
FAQ Item: What are OracleClient and ODP.NET? RRS feed

  • Question

  • What are OracleClient and ODP.NET?
    Sunday, June 20, 2010 1:50 PM

Answers

  • OracleClient is the ADO.NET provider for Oracle developed by Microsoft and ships as a part of .NET Framework. Unfortunately, this provider will be deprecated since Visual Studio 2010 and .NET Framework 4.0. But Microsoft will continue to provide support and hotfixes for critical issues in OracleClient as per the standard support policy for .NET Framework 4.0. Developing new applications which use OracleClient will be supported; however, warnings will be raised if the applications are compiled against .Net 4.0. Once compiled, no warnings or errors will be generated while running these applications. We strongly recommend customers to use our partners’ ADO.NET Provider for Oracle instead of continuing to use Microsoft’s OracleClient for new application development.

    More information you can get from ADO.NET team blog,

    http://blogs.msdn.com/adonet/archive/2009/06/15/system-data-oracleclient-update.aspx

     

    ODP.NET is the .NET provider for Oracle database developed by Oracle.

    If you are interested in what differences between these two providers, you can read the following article which compares them from many aspects, DataTypes, Connection, Command, Transaction and so on,

    http://msdn.microsoft.com/en-us/library/ms971518

     

    Related Threads:

    http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/ad29c4dd-24bc-4f04-a5c6-b3481d506a22
    • Marked as answer by MSDN FAQ Sunday, June 20, 2010 1:51 PM
    Sunday, June 20, 2010 1:51 PM