将.NET布尔数据类型映射到实体框架中的oracle数(1,0)会抛出错误

发布时间：2020-12-12 13:47:41 所属栏目：百科来源：网络整理

导读：将.NET布尔数据类型映射到.edmx文件中的oracle号(1,0)会抛出以下错误. Error 2019: Member Mapping specified is not valid. The type ‘Edm.Boolean[Nullable=False,DefaultValue=]’ of member ‘COLUMN123’ in type ‘DBModel.TABLE123’ is not compati

将.NET布尔数据类型映射到.edmx文件中的oracle号(1,0)会抛出以下错误.

Error 2019: Member Mapping specified is not valid. The type
‘Edm.Boolean[Nullable=False,DefaultValue=]’ of member ‘COLUMN123’ in
type ‘DBModel.TABLE123’ is not compatible with
‘OracleEFProvider.number[Nullable=False,DefaultValue=,Precision=1,Scale=0]’
of member ‘CHECK_INSTALLATION’ in type ‘DBModel.Store.TABLE123’.

可以使用实体框架将布尔数据类型映射到oracle的数字(1,0)吗？

添加一个oracle.dataaccess.client部分对我来说是不够的.以下(从 Deploying and Configuring ODP.NET to work without installation with Entity Framework开始)工作：

<configuration>
  <configSections>
    <section name="oracle.dataaccess.client" type="System.Data.Common.DbProviderConfigurationHandler,System.Data,Version=4.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089" />
    <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler,Oracle.ManagedDataAccess,Version=4.121.1.0,PublicKeyToken=89b483f429c47342" />
</configSections>
...
<oracle.dataaccess.client>
  <settings>
    <add name="bool" value="edmmapping number(1,0)" />
  </settings>
</oracle.dataaccess.client>
<oracle.manageddataaccess.client>
  <version number="*">
    <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>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!