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

環境変数

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ファイルと同じ階層におく