Oracle.ManagedDataAccess.Clientの使い方のメモ

More than 3 years have passed since last update.


環境変数

ORACLE_HOMEがあるといいかも


アプリ側


app.config

<?xml version="1.0" encoding="utf-8"?>

<configuration>
<system.data>
<DbProviderFactories>
<clear />
<add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
</system.data>
<oracle.manageddataaccess.client>
<version number="*">
<settings>
<setting name="TNS_ADMIN" value="%ORACLE_HOME%/network/admin" />
</settings>
<edmMappings>
<edmMapping dataType="number">
<add name="bool" precision="1" />
<add name="byte" precision="2" />
<add name="int16" precision="5" />
</edmMapping>
</edmMappings>
</version>
</oracle.manageddataaccess.client>
</configuration>


配布時

tnsnames.oraをTNS_ADMINか%ORACLE_HOME%/network/adminかexeファイルと同じ階層におく