Mapping difference between Number in Stored Proc and Table

GlennBA · Post by **GlennBA** » Tue 02 Jun 2009 13:02

I am current evaluating dotConnect for Oracle.

It seems to map Number in table to System.Decimal and Number in Stored Proc to System.Double. That is very unfortunate

Best regards
Glenn

AndreyR · Post by **AndreyR** » Tue 02 Jun 2009 13:54

The precision of data type is lost when procedure is described (this is a designed behaviour of the Oracle database).
You can edit data types manually in Entity Developer.

GlennBA · Post by **GlennBA** » Tue 02 Jun 2009 14:46

System.Decimal is not compatible with System.Double which means that Entity Developer generates code which is not compilable when defining Update procedures, for example

AndreyR · Post by **AndreyR** » Thu 04 Jun 2009 13:58

I have just made some simple update tests using procedures and succeeded.
Could you please send me a script of the procedure causing the compilation error?