locked
ADO.Net Provider for oracle RRS feed

  • Question

  • We have been really tired lately dealing with all bugs that comes out of ODP.Net and the lag time to bring out any new product out. I am looking for ado.net provider for oracle and looking for the following:

    1. Entity Framework

    2. Linq

    3. Good support (in case we run into issues)

    4. Quick response to open issues

    5. Quick updates and new releases

    I looked at datadirect and dotConnect by DevArt...But I am not sure if any one is better than other. I would greatly appreciate any suggestions/comments about any of these or other products.

    Thanks
    .

    Saturday, February 12, 2011 2:46 AM

Answers

  • Hello musica11,

     

    Welcome to the MSDN Forum and thanks for posting here.

    Here is the introduction about OracleClient and ODP.NET, I hope it can help you.

    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

     


    Jackie Sun [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, February 15, 2011 8:07 AM