View: @model IEnumerable @foreach( var item in Model) { @item.category "DeleteCategory" asp-route-id= "@item.Id" >Delete } Controller: public async Task DeleteCategory( int Id) { if (Id == null ) { return NotFound(); } var findId = _context.Categorys.FirstOrDefault(x => x.Id == Id); _context.Categorys.Remove(findId); _context.SaveChangesAsync(); return RedirectToAction(nameof(Category)); } I have to press several times on the Delete link in order for it to work when it doesnt work i get the error: Microsoft.EntityFrameworkCore.Database.Transaction: Error: An error occurred using a transaction. I would like to Understand why the code is not running smoothly Thanks

Hi You can check with below code: public async Task DeleteCategory( int Id) { if (Id == null ) { return NotFound(); } //You context is getting used and running so better reinitiate using (DBContext _contextNew = new DBContext()) { var findId = _contextNew.Categorys.FirstOrDefault(x => x.Id == Id); _contextNew.Categorys.Remove(findId); _contextNew.SaveChangesAsync(); } return RedirectToAction(nameof(Category)); }

Hi, how have you defined your _context?

Hi, Please reinitiate your dbcontext in this function before executing it. using (DBContext _contextNew = new DBContext()) { var findId = _contextNew.Categorys.FirstOrDefault(x => x.Id == Id); _contextNew.Categorys.Remove(findId); _contextNew.SaveChangesAsync(); } Regards Rijwan