软删除如果数据不存在，则报错

> 特别说明：如果 Issue 报告为问题且开发成员回复确认问题之后但**三天内**都不能得到反馈，则视为无效Issue。

### Furion 版本号

哪个版本号？
2.2.6
-----------

### Web 项目类型

- [x] WebApi
- [ ] Mvc
- [ ] Razor Pages
- [x] Blazor Server

-----------

### 描述你的问题

发生了什么？
软删除时，数据不存在会报错
```SQL
UPDATE "User" SET "IsDeleted" = 'True', "UpdatedTime" = '2021-05-06T12:00:04+08:00', "UpdatedUserId" = '1', "UpdatedUserName" = 'Sa'
WHERE "Id" = '55';
SELECT changes();
```
生成的sql在数据库里可以正常运行

-----------

### 异常堆栈信息

异常堆栈是什么？

-----------
Microsoft.EntityFrameworkCore.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. See http://go.microsoft.com/fwlink/?LinkId=527962 for information on understanding and handling optimistic concurrency exceptions.
   at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ThrowAggregateUpdateConcurrencyException(Int32 commandIndex, Int32 expectedRowsAffected, Int32 rowsAffected)
   at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeResultSetWithoutPropagation(Int32 commandIndex, RelationalDataReader reader)
   at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.Consume(RelationalDataReader reader)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.Storage.NonRetryingExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges()
   at Furion.DatabaseAccessor.DbContextPool.<>c.<SavePoolNow>b__9_1(KeyValuePair`2 u) in D:\Code\Test\Furion\framework\Furion\DatabaseAccessor\Pools\DbContextPool.cs:line 125
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.GetCount(Boolean onlyIfCheap)
   at Furion.DatabaseAccessor.DbContextPool.SavePoolNow() in D:\Code\Test\Furion\framework\Furion\DatabaseAccessor\Pools\DbContextPool.cs:line 123
   at Furion.DatabaseAccessor.UnitOfWorkFilter.OnActionExecutionAsync(ActionExecutingContext context, ActionExecutionDelegate next) in D:\Code\Test\Furion\framework\Furion\DatabaseAccessor\UnitOfWork\Filters\UnitOfWorkFilter.cs:line 67
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)

### 代码或代码仓库

什么代码导致？

-----------
```c#
        /// <summary>
        /// 删除一条
        /// </summary>
        /// <param name="id"></param>
        public async Task Delete(int id)
        {
            await _userRepo.FakeDeleteAsync(id);
        }
```

### 数据库信息

- [x] Sqlite
- [ ] SqlServer
- [ ] Mysql
- [ ] Oracle
- [ ] PGSql
- [ ] Firebird
- [ ] Cosmos

-----------

### 期待结果

期待的结果是？

-----------
如果数据不存在，返回Null

GVP dotNET China/Furion

内容风险标识

评论 (1)

GVPdotNET China/Furion

内容风险标识