現在 ODP.net 提供兩個版本.

• ODP.NET Managed Driver（不需要 Oracle Client）, 所有訪問的功能都集成在單一的 Oracle.ManagedDataAccess.dll文件中

• ODP.NET unmanaged driver （需要 Oracle Client), 通常建議安裝輕量級的 Oracle Instant Client .

• dotnet(Core) 對應的托管driver包名為: Oracle.ManagedDataAccess.Core

• dotnet(Framework) 對應的托管driver包名為: Oracle.ManagedDataAccess

安裝命令:

 dotnet add package Oracle.ManagedDataAccess.Core
或者:
 Install-Package Oracle.ManagedDataAccess.Core 

  該package的依賴有:
  System.Formats.Asn1         
  System.Security.Cryptography.ProtectedData  
  System.Diagnostics.PerformanceCounter 
  System.Diagnostics.EventLog  
  System.Security.Cryptography.Pkcs  
  System.DirectoryServices.Protocols  
  Oracle.ManagedDataAccess.Core  
  System.Diagnostics.EventLog
  System.Configuration.ConfigurationManager 

下面是一個安裝ODP driver后的csproj文件示例:

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFramework>net8.0</TargetFramework>
    <ImplicitUsings>enable</ImplicitUsings>
    <Nullable>enable</Nullable>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="Oracle.ManagedDataAccess.Core" Version="23.7.0" />
  </ItemGroup>
</Project>

常用的數據類型對應關系為:

• C# int → OracleDbType.Int32
• C# string → OracleDbType.Varchar2
• C# DateTime → OracleDbType.Date
• C# decimal → OracleDbType.Decimal
• C# byte[] → OracleDbType.Blob