.NET Mapping In entity framework, converting a Boolean datatype to an Oracle number(1,0) causes an error.

.net entity-framework

Question

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

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

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

1
17
2/1/2012 12:19:42 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Adding a oracle.dataaccess.client section wasn't sufficient for me. The following (taken from Deploying and Configuring ODP.NET to work without installation with Entity Framework) did work:

<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>
8
5/23/2017 12:25:47 PM

Related Questions

Entity Framework: tinyint to boolean mapping

From MSDN's page on ...integer types..., we see that the ...tinyint... type represents an integer ranging from 0 to 255. ...A ...bool..., in contrast, represents only a binary ...0... or ...1.... ...Changing the default mapping from ...byte... to ...bool... (if it were even possible, which according to ...this page... it seems like it's not) does n...
c# entity-framework mapping
asked by Donut

Entity Framework Error: The SQL Server version in use does not support the datatype 'datetime2'.

I dont see any workaround till date. So if you are using ...SQL Server 2008 Express..., please right click on your edmx, open it with XML (Text) Editor and set ...ProviderManifestToken="2005".... ...Doesn't sound that good. But its all I have got as of now.
asp.net c# entity-framework
asked by naveen

The float datatype is converted to a double by Entity Framework.

I'm not sure if your problem is identical to this or not:...http://forums.asp.net/p/1606916/4100117.aspx...But it doesn't seem like this should cause any problems. You could lose precision with your numbers going from a double to a float, but it should still work unless you need the extra digits.
asp.net-mvc-3 entity-framework
asked by Eric Garrison

Entity Framework error - Error 11009: Property ' ' is not mapped

Check the xml file of your model, it's probably still in there somewhere. Try deleting it manually from that XML file, then try to update again. Be sure to take backups though.
c# entity-framework mapping visual-studio-2008
asked by Thousand

How to get Oracle next sequence value in .NET Entity Framework?

I had this same issue, and resolved it with some help from this site and Oracle. I'm assuming you're using Database First, since you mentioned another legacy app uses the same database. ...There are a few things I had to do. Like Daniel Gabriel mentioned, if you allow Oracle to manage the identity, you don't need to ever call the sequence to fin...
.net entity-framework nextval oracle11g sequence
asked by jozolo

Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found

I finally was able to to use ODP with EF6....I did the following to make it work :-...First Installing ODAC 12c Release 3 which includes support for Entity Framework 6 Code First and Code First Migrations; NuGet, .NET Framework 4.5.2; and ODP.NET, Managed Driver XML DB. As per...http://www.oracle.com/technetwork/topics/dotnet/whatsnew/index.html...
.net ado.net-entity-data-model entity-framework odac oracle
asked by Wasef Anabtawi

Oracle ODP.Net With Entity Framework 6 - TypeInitializationException - CreateConnection()

There was a bug in app.config section:...<oracle.manageddataaccess.client> ...I had to remove:...<settings> ...Nevertheless, the application still does not work, but for a different reason.
entity-framework-6 odp.net
asked by BLuM

Mapping xmltype oracle with entity framework 6 code first annotations

Update :...This is Oracle data provider's Known Issue.So you have to wait until they'll fix this issue....An "ORA-00932 : inconsistent datatypes" error can be encountered if a string of 2,000 or more characters, or a byte array with 4,000 bytes or more in length, is bound in a WHERE clause of a LINQ/ESQL query. The same error can be encounter...
c# ef-code-first entity-framework entity-framework-6 xmltype
asked by Sampath

How can I prepare WITH CLAUSE using Oracle .Net entity framework queries

If I understood the problem, it is that you can't use the ...WITH... factoring clause. If that's so, move the ...EVENTS... CTE into the ...FROM... clause:...select * from (select * from EVENTS_ATCS WHERE ROWNUM <10) A --> this is EVENTS LEFT JOIN ATCS_EVENT_MASTER B ON (A.TYPEID = B.EventId) AND ((A.BYTE1 >= B.GE_BYTE1 AND A.BYTE1 <= ...
common-table-expression entity-framework entity-framework-6 oracle
asked by Littlefoot

Oracle 18c & .Net 4.7.2: "Oracle.ManagedDataAccess.Client could not be loaded"

I have the data access logic in a separate project, installing the Oracle DataAccess nuget package also in my main project solved the problem. Looking closer to the error message helped ... ;)..."and that the assembly is available to the running application"
.net entity-framework-6 oracle
asked by IngoB

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow