blocks|key|2909433|text|下面是一个包含自定义映射的app.config示例，其中NUMBER(1，0)映射到Bool，NUMBER(3,0)映射到Byte，Int16、Int32和Int64的最大精度分别从默认值5、10、19更改为4、9、18：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2909434|+++++++++<?xml+version="1.0"+encoding="utf-8"?>
+++++++++<configuration>
+++++++++<connectionStrings>
+++++++++</connectionStrings>
+++++++++<oracle.dataaccess.client>
+++++++++<settings>
+++++++++<add+name="bool"+value="edmmapping+number(1,0)"+/>
+++++++++<add+name="byte"+value="edmmapping+number(3,0)"+/>
+++++++++<add+name="int16"+value="edmmapping+number(4,0)"+/>
+++++++++<add+name="int32"+value="edmmapping+number(9,0)"+/>
+++++++++<add+name="int64"+value="edmmapping+number(18,0)"+/>
+++++++++</settings>
+++++++++</oracle.dataaccess.client>
+++++++++</configuration>|code-block|syntax|javascript|2909435|同样，您可以将Oracle布尔值映射到.net编号(1，0)|2909436|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Below is an example of app.config that contains a custom mapping where 
NUMBER(1, 0) is mapped to Bool, NUMBER(3,0) is mapped to Byte, and the 
maximum precisions for Int16, Int32, Int64 are changed to 4, 9, 18 from the 
default values of 5, 10, 19, respectively: 

<pre><code> &lt;?xml version="1.0" encoding="utf-8"?&gt;
 &lt;configuration&gt;
 &lt;connectionStrings&gt;
 &lt;/connectionStrings&gt;
 &lt;oracle.dataaccess.client&gt;
 &lt;settings&gt;
 &lt;add name="bool" value="edmmapping number(1,0)" /&gt;
 &lt;add name="byte" value="edmmapping number(3,0)" /&gt;
 &lt;add name="int16" value="edmmapping number(4,0)" /&gt;
 &lt;add name="int32" value="edmmapping number(9,0)" /&gt;
 &lt;add name="int64" value="edmmapping number(18,0)" /&gt;
 &lt;/settings&gt;
 &lt;/oracle.dataaccess.client&gt;
 &lt;/configuration&gt;
</code></pre>

In the same way you can map .net bool to Oracle Number(1,0)

blocks|key|240331|text|添加一个oracle.dataaccess.client部分对我来说是不够的。以下代码(摘自Deploying+and+Configuring+ODP.NET+to+work+without+installation+with+Entity+Framework)确实有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|240332|<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,+Culture=neutral,+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>|code-block|syntax|javascript|240333|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/13721025/^0|1A|2C|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Adding a oracle.dataaccess.client section wasn't sufficient for me. The following (taken from <a href="https://stackoverflow.com/questions/13721025/">Deploying and Configuring ODP.NET to work without installation with Entity Framework</a>) did work:

<pre><code>&lt;configuration&gt;
 &lt;configSections&gt;
 &lt;section name="oracle.dataaccess.client" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt;
 &lt;section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" /&gt;
&lt;/configSections&gt;
...
&lt;oracle.dataaccess.client&gt;
 &lt;settings&gt;
 &lt;add name="bool" value="edmmapping number(1,0)" /&gt;
 &lt;/settings&gt;
&lt;/oracle.dataaccess.client&gt;
&lt;oracle.manageddataaccess.client&gt;
 &lt;version number="*"&gt;
 &lt;edmMappings&gt;
 &lt;edmMapping dataType="number"&gt;
 &lt;add name="bool" precision="1"/&gt;
 &lt;add name="byte" precision="2" /&gt;
 &lt;add name="int16" precision="5" /&gt;
 &lt;/edmMapping&gt;
 &lt;/edmMappings&gt;
 &lt;/version&gt;
&lt;/oracle.manageddataaccess.client&gt;
</code></pre>

blocks|key|3123864|text|这种配置在我使用VS2012、EF5和Oracle11和oraclManageDataAccess+12.1时有效。数字%251+not+null已转换为bit。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3123865|<?xml+version="1.0"+encoding="utf-8"?>
<configuration>
++<configSections>
++++<section+name="entityFramework"
+++++++++++++type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection,+EntityFramework,+Version=5.0.0.0,+Culture=neutral,+PublicKeyToken=b77a5c561934e089"
+++++++++++++requirePermission="false"+/>
++</configSections>
++<entityFramework>
++++<defaultConnectionFactory+type="System.Data.Entity.Infrastructure.SqlConnectionFactory,+EntityFramework"+/>
++</entityFramework>
++<connectionStrings>
++</connectionStrings>
++<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>
</configuration>|code-block|syntax|javascript|3123866|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This configuration worked for me using VS 2012, EF5 with Oracle 11 and oraclManageDataAccess 12.1.
NUMBER 1 not null was converted to bit.

<pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
&lt;configuration&gt;
 &lt;configSections&gt;
 &lt;section name="entityFramework"
 type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
 requirePermission="false" /&gt;
 &lt;/configSections&gt;
 &lt;entityFramework&gt;
 &lt;defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" /&gt;
 &lt;/entityFramework&gt;
 &lt;connectionStrings&gt;
 &lt;/connectionStrings&gt;
 &lt;oracle.manageddataaccess.client&gt;
 &lt;version number="*"&gt;
 &lt;edmMappings&gt;
 &lt;edmMapping dataType="number"&gt;
 &lt;add name="bool" precision="1" /&gt;
 &lt;add name="byte" precision="2" /&gt;
 &lt;add name="int16" precision="5" /&gt;
 &lt;/edmMapping&gt;
 &lt;/edmMappings&gt;
 &lt;/version&gt;
 &lt;/oracle.manageddataaccess.client&gt;
&lt;/configuration&gt;
</code></pre>

blocks|key|241366|text|我在复制用于新项目的解决方案时遇到错误，因此我从非托管oracle驱动程序更改为托管oracle驱动程序，然后问题消失了，但当我发布到服务器时，服务器没有安装托管oracle驱动程序，因此我不得不改回非托管oracle驱动程序。当然，问题又回来了，所以我转到服务器资源管理器，验证我可以连接到我的oracle源代码(使用非托管驱动程序)，然后我打开edmx文件，右键单击并单击验证，它仍然在错误列表上显示错误，然后我只需右键单击并单击从数据库更新模型，验证表是否列在刷新选项卡中，然后单击完成，更新需要一段时间才能完成，但当更新完成时，错误就消失了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|241367|我认为当尝试使用web.config和app.config文件中的非托管驱动程序设置，但连接到服务器资源管理器中的托管驱动程序(这是edmx+'update+model+from+database‘操作使用的连接)时，会出现此错误，反之亦然。|241368|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I got the errors when I copied a solution to use for a new project, so I changed from the unmanaged oracle driver to the managed oracle driver, then the problem went away, but when I published to the server, the server did not have the managed oracle driver installed, so I had to change back to the unmanaged oracle driver. Problem came back of course, so I went to the server explorer and verified that I could connect to my oracle sources (using the unmanaged driver), then I opened the edmx file and right clicked and clicked validate which still showed the errors on the error list, then I simply right clicked and clicked update model from database, verified that the tables were listed in the refresh tab, then clicked finish, it took a little while for the update to finish, but when it was done the errors went away.

I believe this error comes up when trying to use the unmanaged driver settings in the web.config and app.config files but connecting to the managed driver in the server explorer (which is the connection that the edmx 'update model from database' action uses), or vise versa.

blocks|key|237884|text|在VS+2015中遇到了这个错误。项目编译时不会出现错误，但错误列表仍然会显示此错误。已将以下部分添加到我的app.config以解决此问题。请注意，edmMapping元素与oracle提供的XSD+schema不兼容(因此，如果您的配置文件是打开的，您会收到有关它的警告)，但这仍然比显示这些错误要好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|237885|++++<oracle.manageddataaccess.client>
++++<version+number="*">
++++++++<edmMappings>
++++++++++++<edmNumberMapping>
++++++++++++++++<add+NETType="bool"+MinPrecision="1"+MaxPrecision="1"+DBType="Number"+/>
++++++++++++</edmNumberMapping>
++++++++++++<edmMapping+dataType="number">
++++++++++++++++<add+name="bool"+precision="1"/>
++++++++++++</edmMapping>
++++++++</edmMappings>
++++</version>
</oracle.manageddataaccess.client>|code-block|syntax|javascript|237886|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Was getting this error in VS 2015. The project would compile without errors, but error list would still show this error.
Added the following section to my app.config to resolve the issue.
Please note that edmMapping element is not compatible with the XSD schema that oracle provides (so you get a warning about it if your config file is open), but it's still better than having those errors show up.

<pre><code> &lt;oracle.manageddataaccess.client&gt;
 &lt;version number="*"&gt;
 &lt;edmMappings&gt;
 &lt;edmNumberMapping&gt;
 &lt;add NETType="bool" MinPrecision="1" MaxPrecision="1" DBType="Number" /&gt;
 &lt;/edmNumberMapping&gt;
 &lt;edmMapping dataType="number"&gt;
 &lt;add name="bool" precision="1"/&gt;
 &lt;/edmMapping&gt;
 &lt;/edmMappings&gt;
 &lt;/version&gt;
&lt;/oracle.manageddataaccess.client&gt;
</code></pre>

Mapping .NET boolean datatype to oracle number(1,0) in .edmx file throws following error.

<blockquote>
 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'.
</blockquote>

Can a Boolean datatype be mapped to oracle's number(1,0) using entity framework?

Mapping .NET Boolean datatype to oracle number(1,0) in entity framework throws error

数据库

服务器

将.edmx文件中的.NET布尔数据类型映射到oracle number(1,0)会引发以下错误。错误2019:指定的成员映射无效。类型“”DBModel.TABLE123“”中成员“”COLUMN123“”的类型“”DBModel.TABLE123，DefaultValue=“”与类型“”DBModel.Store....

问在实体框架中将.NET布尔数据类型映射到oracle number(1,0)时抛出错误
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在实体框架中将.NET布尔数据类型映射到oracle number(1,0)时抛出错误EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在实体框架中将.NET布尔数据类型映射到oracle number(1,0)时抛出错误
EN