locked
Oracle driver recommendations? RRS feed

  • Question

  • User-1177406051 posted

    I see several nuget packages for Oracle.  Oracle Data Provider (ODP) 32 bit, a (ODP) 64 bit, and once just called ODP 'Managed Driver' that has far fewer donwloads.

    I am building an MVC/WebAPI app and need pretty much simple read-only access to an Oracle database to lookup a number of things in a warehouse.

    I will not be writing anything back at all.

    Suggestions?

    Thanks.

    Wednesday, May 22, 2013 8:40 AM

Answers

  • User269602965 posted

    I use ODP.NET 32-bit and 64-bit depending on the OS environment of app development.  For me it has always been faster than the Microsoft Oracle Client, which is now deprecated.  The ODP.NET Managed driver is a step in the right direction, but still in my mind it is an evolving beta, so I can wait.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, May 22, 2013 10:58 PM

All replies

  • User269602965 posted

    I use ODP.NET 32-bit and 64-bit depending on the OS environment of app development.  For me it has always been faster than the Microsoft Oracle Client, which is now deprecated.  The ODP.NET Managed driver is a step in the right direction, but still in my mind it is an evolving beta, so I can wait.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, May 22, 2013 10:58 PM
  • User-1177406051 posted
    This is for web so I cannot be 100% sure of CPU type when delpoyed. Test machines could be 32 bit. Prod machines could be 64. How do you address that? Thanks.
    Thursday, May 23, 2013 7:36 AM
  • User269602965 posted

    Recompile from 32-bit to 64-bit moving from test to prod.

    Just have to make sure the correct ODP.NET ODAC.dll is being used and referenced.

    I put the correct ODAC.dll in the website /BIN and make LOCAL reference to the DLL.

    Friday, May 24, 2013 9:26 PM