Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 29
Joined: Wed 19 May 2010 07:26


Post by Dominik » Fri 12 Nov 2010 09:38


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,


Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 12 Nov 2010 10:06

No, this is not a .edml bug. If you declare a conceptual attribute, it does not influence the storage part of the model.
In a .edml model you can edit the Storage model in design time (go to the Model.Store node in the Model Explorer Entity Developer window).
This is a more convenient way than editing XML (that was discussed for the .edmx models in this thread).

Post Reply