Loading

Microsoft.EntityFrameworkCore.Database.Transaction: Error

Microsoft.EntityFrameworkCore.Database.Transaction: Error

osyris zosar

5y2.9kLearn iOS Programming

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

3 Replies

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

Satya Karki5y ago
Accepted answer
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));
}
Rijwan Ansari5y ago
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
Satya Karki5y ago
Hi, how have you defined your _context?