Entityframework throws The property 'Id' is part of the object's key information and cannot be modified while modifying existing record

Question

I am trying to update an existing entity using the following code. Getting the error :

The property 'Id' is part of the object's key information and cannot be modified

Not sure what I am doing wrong. Can anyone please help me with this? Find below my code:

var record = await (from c in context.Customers
   where c.Id == input.Id
   select c)
   .AsNoTracking()
   .FirstOrDefaultAsync<Customer>();

if (record == null)
{
   // New record 
   context.Customers.Add(input);
}
else
{
   // Existing record 
   context.Customers.Attach(record);
   context.Entry(record).CurrentValues.SetValues(input);
   record.SetUpdateInfo(user.UserId);
}

score 1 · Answer 1 · answered Mar 09 '17 at 18:37

1

If your input has an Id set, Entity Framework is going to try and create an entity with that Id. Try setting the Id of input to 0 if its not found and add the record.

answered Mar 09 '17 at 18:37

Phil Hess

41
1

Entityframework throws The property 'Id' is part of the object's key information and cannot be modified while modifying existing record

1 Answers1