Mapping difference between Number in Stored Proc and Table

Mapping difference between Number in Stored Proc and Table

Postby 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
GlennBA
 
Posts: 21
Joined: Tue 02 Jun 2009 12:58

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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
GlennBA
 
Posts: 21
Joined: Tue 02 Jun 2009 12:58

Postby 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?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to LinqConnect (LINQ to SQL support)