NUMBER column mapped to long -> insert does not work

[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

[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.

[dcoracle600pro]

Thank you, it works !