DbUpdateConcurrencyException: Database operation expected to affect 1 row(s) but actually affected 0 row(s). Data may have been modified or deleted since entities were loaded.

Yalçın Mete 60

If you allow, I would like to ask a question.

I want to replace the data I brought with the "public async Task<IActionResult> WriterEditProfile()" method with the "public IActionResult WriterEditProfile(AppUser p)" method.

"DbUpdateConcurrencyException: Database operation expected to affect 1 row(s) but actually affected 0 row(s). Data may have been modified or deleted since entities were loaded." I get an error.

Why does this occur? Is it because one method is "async" and the other method is not "async" that I get this error?

User's image

[HttpGet]
public async Task<IActionResult> WriterEditProfile()
{
    var values = await _userManager.FindByNameAsync(User.Identity.Name);
    return View(values);
}

[HttpPost]
public IActionResult WriterEditProfile(AppUser p)
{
    UserManager userManager = new UserManager(new EfUserRepository());
    userManager.TUpdate(p);
    return RedirectToAction("Index","Dashboard");
}

public class UserManager : IUserService
{
	IUserDal _userDal;
	public void TUpdate(AppUser t)
	{
		_userDal.Update(t);
	}
}

public class EfUserRepository : GenericRepository<AppUser> , IUserDal
{
	
}

 public class GenericRepository<T> : IGenericDal<T> where T : class
 {
	public void Update(T t)
    {
        using var c = new Context();
        c.Update(t);
        c.SaveChanges();
    }
}

Thanks

JasonPan - MSFT 4,796 Microsoft Vendor

Hi @Yalçın Mete,

Try reloading the latest entities before updating, like below.

public void Update(T t)
{
    using var c = new Context();
    var existingEntity = c.Set<T>().Find(t.Id); // reload
    if (existingEntity == null)
    {
        throw new Exception("Entity not found");
    }
    c.Entry(existingEntity).CurrentValues.SetValues(t);
    c.SaveChanges();
}

Best Regards

Jason

Yalçın Mete 60

Hi @JasonPan - MSFT

Can't find "id".

public void Update(T t)
{    using var c = new Context();
    var existingEntity = c.Set<T>().Find(t.Id); // reload
    if (existingEntity == null)
    {
        throw new Exception("Entity not found");
    }
    c.Entry(existingEntity).CurrentValues.SetValues(t);
    c.SaveChanges();
}