Mybatis.Net 整合 ODP.NET Managed - yjmyzz－IT工程師數位筆記本

文章出處

初步接觸MyBatis.Net的朋友，請先移步 MyBatis.Net 學習手記
1. 項目中先添加Oracle.ManagedDataAccess.dll程序集引用

2. MyBatis.Net 中Providers.config文件修改

 1 <provider
 2     name="ODP.NET Managed"
 3     description="Oracle, ODP.NET Managed 4.121.1.0"
 4     enabled="true"
 5     assemblyName="Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342"
 6     connectionClass="Oracle.ManagedDataAccess.Client.OracleConnection"
 7     commandClass="Oracle.ManagedDataAccess.Client.OracleCommand"
 8     parameterClass="Oracle.ManagedDataAccess.Client.OracleParameter"
 9     parameterDbTypeClass="Oracle.ManagedDataAccess.Client.OracleDbType"
10     parameterDbTypeProperty="OracleDbType"
11     dataAdapterClass="Oracle.ManagedDataAccess.Client.OracleDataAdapter"
12     commandBuilderClass="Oracle.ManagedDataAccess.Client.OracleCommandBuilder"
13     usePositionalParameters="true"
14     useParameterPrefixInSql="true"
15     useParameterPrefixInParameter="true"
16     parameterPrefix=":"
17     useDeriveParameters="false"
18     allowMARS="false"  
19 />

tips:

a) assemblyName類型不知道如何填寫的，可通過類似 Assembly.LoadFile(@"D:\soft\ODP.NET_Managed121010\odp.net\managed\common\Oracle.ManagedDataAccess.dll").FullName獲得

b)name,description 這二處可隨便填寫

3.MyBatis.Net中SqlMap.config的相關節點修改

1 <!--db provider類型及連接串-->
2 <database>
3     <provider name="ODP.NET Managed" /> <!--這里要與Providers.config中的nama保持一致-->
4     <dataSource name="oracle" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=***.***.***.***)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=***)));Persist Security Info=True;User ID=***;Password=***;" />
5 </database>