I am facing a problem of mapping with Oracle mapping with .Net.
By default, the mapping for a number(5) is int16 (short), where the number(5) can be much bigger (99999 VS 32767).
I searched a while and the only solution I found is to put this in the app.config and regenerate the edmx file :
*<add name="int16" value="edmmapping number(4,0)" />*
Well, I got the error 2019 error in VS2010, but it compile fine. Read data in database works fine, but I can't insert a number bigger than the max of a short. By example, if I try to insert 99999, when I look in the database, I found -31073.
I 'm not an expert and can't find anymore thing to do to make it works. Any help will be greatly appreciated.
Here is my config, if this could help :
- Windows 2003 server
- Oracle 10g database
- ODAC 11.2 Release 4 (220.127.116.11.0) with Oracle Developer Tools for Visual Studio
- Visual Studio 2010 (C# / .net4)