Type of Data in Oracle

Type of Data in Oracle

Postby 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.
Posts: 1
Joined: Mon 08 Jun 2009 14:38

Postby 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.
Devart Team
Posts: 7889
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for Oracle