Page 1 of 1

NUMBER column mapped to long -> insert does not work

Posted: Fri 07 Oct 2016 07:52
by dcoracle600pro
Hi,

I have a table with the pk column as NUMBER (no precision). I know that this column will not contains decimal values. So in my POCO EF class, in declare a property of type long.

When I try to create and save a new object, the SQL query generated ommit this column (-> error ORA-01400) ! If I change the type from long to Decimal, it works fine.

Is this behaviour normal ?

I use version 8.5.558

Thank you

Re: NUMBER column mapped to long -> insert does not work

Posted: Fri 07 Oct 2016 15:22
by Shalex
Try setting Store Generated Pattern=None for your PK property explicitly. If this doesn't help, send us a small test project for reproducing the issue in our environment.

Re: NUMBER column mapped to long -> insert does not work

Posted: Tue 11 Oct 2016 05:44
by dcoracle600pro
Thank you, it works !