Ado.net entity frmawork error getting while saveChanges()

P Narasimha

13y24.5kLINQ

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 .

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Apurva11y ago
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();
}
0
Manoj Bhoir11y ago
Hi,

"Violation of PRIMARY KEY constraint 'PK_Table1'. Cannot insert duplicate key in object 'dbo.TableName'.\r\nThe 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.
0
karthicka v11y ago
{"Violation of PRIMARY KEY constraint 'PK_Table1'. Cannot insert duplicate key in object 'dbo.TableName'.\r\nThe statement has been terminated."}
0
Blocked Account13y ago
Hi

Please mention what kind of error you are getting.

Thanks
0