Entity Framework Id auto incrementing

Question

Have a problem with incrementing. I created a new object and tried set it into my DB I received an error of data violation. The index in table wasn't increased (Id=0). Id - set as primary key in SQL table and the StoredGeneratedPattern property of field "Id" in EDM set as "Identity" so, obviously, it must be incremented automatically.

public void AddPhone(UserPhone phone)
{
    context.AddToUserPhone(phone);
    context.SaveChanges();
}

I can't understand why.

Did the new object get saved? – Eranga Jan 24 '12 at 15:50 — Eranga, Jan 24 '12 at 15:50

score 5 · Answer 1 · answered Jan 24 '12 at 15:48

Entity Framework does not automatically increment IDs. That's the database's job. Set the ID column on the database table as an IDENTITY column so that it will auto-increment. Then you should find that after you SaveChanges() the phone's ID property will have been set to the value the database chose for it.

Entity Framework Id auto incrementing

1 Answers1

Linked