I'm working on a utility application that is going to extend / be a supplement to a third party product. My application is going to communicate directly with the database and I have decided to use Entity Framework as ORM. Since we need to support both SQL and Oracle, I have made a shared conseptual model and made one set of .msl and .ssdl for each database type.
There are some columns specified as smallint in SQL. These are mapped to Int16 in .NET. My problem is that I cannot get these columns to work with the corresponding number type in Oracle. I'm not really familiar with Oracle, but for me it looks like the column types are slightly different configured compared to what they are in SQL. Columns that are smallint in SQL are NUMBER(*,0) in Oracle, and the NUMBER(*,0) is also used where int is used in SQL. Since I am not owning the database schema I cannot change it.
I have tried different column types in the Oracle .ssdl file. The only that will let me use the model is:
Code: Select all
Code: Select all
The specified value is not an instance of type 'Edm.Decimal'
Parameter name: value
I have read through the forums here and tried any hint I have found. http://www.devart.com/forums/viewtopic.php?t=13175 is a pretty similar issue, but it does use int / Int32 and not short / Int16.
I would appreciate any feedback.
Terje Myklebust