SQLite + Entity Framework 4.0 + Identity column/Autoinc does not work

Question

Hello,

thats my table:

-- Original table schema CREATE TABLE [SchoolYear] ( [Start] datetime NOT NULL, [End] datetime NOT NULL, [Id] integer PRIMARY KEY ON CONFLICT ABORT AUTOINCREMENT NOT NULL );

my Entity in the EF designer has StoredGeneratedPattern set to Identity OR Compute and datatype is int64.

Everytime I insert a second SchoolYear object I get this error:

An object with the same key is already in the ObjectStateManager...

Answer 1

Check that the autoincremented property has the StoreGeneratedPattern attribute set to "Identity" in the SSDL part of the model, not in CSDL.
This is a known issue, the conceptual attribute is not taken into account while generating the code.