EFCore 6级联删除问题解决Database operation expected to affect 1 row(s) but actually affected 0 row(s)
异常信息:
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. See http://go.microsoft.com/fwlink/?LinkId=527962 for information on understanding and handling optimistic concurrency exceptions.
处理方案:

public async Task DeleteAnimalInfo(string animalToken) { var dbContext = new DBContext(_configuration); var _animalInfoRepository = new EFRepository<AnimalInfo>(dbContext); var query = _animalInfoRepository .Table; query = query.Where(x => x.AnimalToken.Equals(animalToken)); if (query.Count() <= 0) { throw new Exception("does not exist in the database"); } var entity = query.FirstOrDefault(); _animalInfoRepository .Delete(query); }
分类:
.NET6
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 10年+ .NET Coder 心语 ── 封装的思维:从隐藏、稳定开始理解其本质意义
· 【设计模式】告别冗长if-else语句:使用策略模式优化代码结构
· 提示词工程——AI应用必不可少的技术
· 字符编码:从基础到乱码解决
· 地球OL攻略 —— 某应届生求职总结