Page 1 of 1

Type of Data in Oracle

Posted: Mon 08 Jun 2009 14:45
by marquinhosaguiar
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.

Posted: Tue 09 Jun 2009 09:08
by Shalex
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.