Mybatis.Net 整合 ODP.NET Managed

时间：2023-03-08 22:57:52
Mybatis.Net 整合 ODP.NET Managed

初步接触MyBatis.Net的朋友，请先移步 MyBatis.Net 学习手记 
1. 项目中先添加Oracle.ManagedDataAccess.dll程序集引用

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

 <provider

     name="ODP.NET Managed"

     description="Oracle, ODP.NET Managed 4.121.1.0"

     enabled="true"

     assemblyName="Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342"

     connectionClass="Oracle.ManagedDataAccess.Client.OracleConnection"

     commandClass="Oracle.ManagedDataAccess.Client.OracleCommand"

     parameterClass="Oracle.ManagedDataAccess.Client.OracleParameter"

     parameterDbTypeClass="Oracle.ManagedDataAccess.Client.OracleDbType"

     parameterDbTypeProperty="OracleDbType"

     dataAdapterClass="Oracle.ManagedDataAccess.Client.OracleDataAdapter"

     commandBuilderClass="Oracle.ManagedDataAccess.Client.OracleCommandBuilder"

     usePositionalParameters="true"

     useParameterPrefixInSql="true"

     useParameterPrefixInParameter="true"

     parameterPrefix=":"

     useDeriveParameters="false"

     allowMARS="false"

 />

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的相关节点修改

 <!--db provider类型及连接串-->

 <database>

     <provider name="ODP.NET Managed" /> <!--这里要与Providers.config中的nama保持一致-->

     <dataSource name="oracle" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=***.***.***.***)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=***)));Persist Security Info=True;User ID=***;Password=***;" />

 </database>

相关文章