Ado.net entity frmawork error getting while saveChanges()

Question

Hi All Please help me anybody on this. I am getting below error while save data into database. I am using Code firtst entity Framework. error is this. error on Updating record An error occurred while updating the entries. See the inner exception for details. Model is [Key] public int UserId { get; set; } public User SaveUser(User user) { try { if (user.UserId == 0) { var UserId = objSequenceHelper.GetNextValue(DomainModels.Enumerations.Sequences.S_SECURITY_USER); //StoreGeneratedPattern.Identity.ToString(); user.UserId = UserId; db.Users.Add(user); } else db.Entry(user).State = System.Data.EntityState.Modified; db.SaveChanges(); return user; } } while saving geting above error .

Apurva · Answer

The code you are mentioning is correct. It seems like the usedid you are trying to add already exists which is violating the primary key constraint. I have tried it with the following code and is working fine: using(var db = new MyDataContext()) { User user = new User(); if (user.UserId == 0) { var UserId = 10; user.UserId = UserId; db.Users.Add(user); } else db.Entry(user).State = EntityState.Modified; db.SaveChanges(); }

Manoj Bhoir · Answer

Hi Violation of PRIMARY KEY constraint 'PK_Table1'. Cannot insert duplicate key in object 'dbo.TableName'.
The statement has been terminated. It means you are inserting duplicate value for primary key column. Please try to insert validation code before inserting record in table. As per your question i think UserId is primary key so check that userid should not exist in your table before saving your record in database.

karthicka v · Answer

{Violation of PRIMARY KEY constraint 'PK_Table1'. Cannot insert duplicate key in object 'dbo.TableName'.
The statement has been terminated.}

Manish Dwivedi · Answer

Hi Please mention what kind of error you are getting. Thanks