dataProvider="Oracle9Odp"- Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.100...

We are using Oracle 11g as backend database.

I have LightSpeed version=5.0.2889 installed through NuGet

  <package id="Mindscape.LightSpeed" version="5.0.2889" targetFramework="net45" />

I've configured LightSpeedContext to use "Oracle9Odp" data provider

  <lightSpeedContexts>
    <add name="Development" connectionStringName="Development" dataProvider="Oracle9Odp" pluralizeTableNames="False" identityMethod="MultiSequence" />
  </lightSpeedContexts>

I've have "Oracle.DataAccess" version 2.112.1.0 installed throught NuGet

  <package id="Oracle.DataAccess.x86" version="2.112.1.0" targetFramework="net45" />

However, when I run the application, I get the following runtime error:

Additional information: Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.100, 
enter code here`Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. 
The located assembly's manifest definition does not match the assembly reference. 
(Exception from HRESULT: 0x80131040)

How do I get the correct version of the Oracle.DataAccess, which works with Lightspeed ("Oracle9Odp")?

I got this working! I installed the "Oracle Data Provider for .net (ODP.NET) x64" package via NuGet.

packages\odp.net.x64.112.3.20\lib\net40\Oracle.DataAccess.dll

Then I added the following assemblyBinding redirect. Note the newVersion number.

  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" culture="neutral"/>
        <bindingRedirect oldVersion="10.2.0.100" newVersion="4.112.3.0" />
      </dependentAssembly>

In IIS for my WebApi application, I had to make sure to use an Application pool was using .Net Framework 4.0. Plus I did NOT need to enabled 32 bit appl since I'm using the 64 bit version of Oracle Data Provider.