StoreGeneratedPattern="Identity"
Posted: Fri 12 Nov 2010 09:38
Hi,
In my edml model, If I declare an entity field as Store Generated Pattern=Identity, this is translated to my CDSL content as an attribute annotation:StoreGeneratedPattern="Identity" in field property.
Then, if I try to create a new entity to my Oracle database, I get this error:
System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Devart.Data.Oracle.OracleException: ORA-00001: unique constraint violated.
If I add manually the attribute StoreGeneratedPattern="Identity" to my SSDL content as an attribute of the field property as in my EDMX model for SQL Server, then it works without any problem.
Was that a bug in edml model?
Thanks in advance,
Dominik.
In my edml model, If I declare an entity field as Store Generated Pattern=Identity, this is translated to my CDSL content as an attribute annotation:StoreGeneratedPattern="Identity" in field property.
Then, if I try to create a new entity to my Oracle database, I get this error:
System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Devart.Data.Oracle.OracleException: ORA-00001: unique constraint violated.
If I add manually the attribute StoreGeneratedPattern="Identity" to my SSDL content as an attribute of the field property as in my EDMX model for SQL Server, then it works without any problem.
Was that a bug in edml model?
Thanks in advance,
Dominik.