Page 1 of 1

EF4: Wrong Mapping for Column Number(10,0)

Posted: Sat 04 Sep 2010 09:22
by Sebastian Gebhardt
I use the dotConnect for Oracle with Entity Framework 4.

I have a Table with Column DataType "Number(10,0)". If I create the Model from this Table, this Column get the Type Int64 instead of Int32.
But if a change the ColumnType to "Number(9,0) the created Model get the right Type.

Greetings

Posted: Mon 06 Sep 2010 13:44
by AndreyR
Actually, NUMBER(10, 0) can contain values too large for CLR Int32 data type, so the default mapping should use Int64.
The full table of type mappings is available here.