Type of Data in Oracle

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 1
Joined: Mon 08 Jun 2009 14:38

Type of Data in Oracle

Post by marquinhosaguiar » Mon 08 Jun 2009 14:45


I want to know, because when add in ADO.NET Entity Data Model.edmx a table with a cell type number(12,2) the mapping details show double, but if change for the cell type number(18,2) the mapping details show decimal.

The same for number(1) the mapping details show boolean.

Can Somebody help me?

Thank in Advance.

Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 09 Jun 2009 09:08

1. The number(12,2) and number(18,2) mapping is correct. Its mapping is the same as OracleDataReader's one.
2. The NUMBER(1) type is used to store the boolean values usually. So it is mapped as boolean. You can change its mapping to Int32. It is discussed at http://devart.com/forums/viewtopic.php?p=45283.

Post Reply