Entity Framework generates short instead of int

.net, c#, ef-database-first, entity-framework, oracle

Solution

Solved it, Added this to the web.config:

<oracle.dataaccess.client>
<settings>
<add name="int16" value="edmmapping number(4,0)" />
<add name="int32" value="edmmapping number(9,0)" />
</settings>
</oracle.dataaccess.client>

Recreated the Model with the `*.edmx` file and...

Now `Number(5)` is `Int32` instead of `Int16` and `Number(10)` is `Int64` instead of `Int32`

I hope it'll help someone else in the future...

Problem

We are using Entity Framework database-first for our Oracle database. For some reason `Number(5)` becomes `Int16` - `short` Max `Number(5)` value is 99999 Max `Int16` value is 32767 Problem... is there a way to instruct the mapper to translate `Number(5)` to `int32`?

Original source

Related problems