Type of Data in Oracle

marquinhosaguiar · Post by **marquinhosaguiar** » Mon 08 Jun 2009 14:45

Hello.

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.

Shalex · 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.