inserting to a table with an identity column

Question

i am trying to insert a row to a table with an identity column and three "normal" columns using entity framework in wpf. however i got this error message: Cannot insert explicit value for identity column in table 'MyTable' when IDENTITY_INSERT is set to OFF here is my code snippet, trying to add to the user table who has name, surname, age and userID(identity) column:

        var newuser = new User();
        newuser.SurName = surNameTextBox.Text;
        newuser.Name = nameTextBox.Text;
        newuser.Age = Int32.Parse(ageTextBox.Text);
        context.AddToUsers(newuser);
        context.SaveChanges();

can anyone help me on solving this problem? thanks in advance.

Answer 1

Identity columns indeed update themselves - that is their purpose.

If this is the only code that you are using to update the User, then I would look at (or post) the AddToUsers method in the DataContext.

Answer 2

I'm not familiar with entity-framework, but for the curious this is the MS SQL command for enabling an insert on an identity column:

SET IDENTITY_INSERT tablename ON

I agree with Wonko to Sane, the problem is almost certainly in the AddToUsers method.