开发者

Inserting to a table with an identity column

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 t开发者_StackOverflowo 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?


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.


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜