[UnitOfWork]属性如果贴在使用ISqlDispatchProxy实现的SQL方法是会报Connetion错误

[AllowAnonymous]
        [UnitOfWork]
        [Route("/api/home/update-user")]
        public int UpdateUserInfo(UpdateUserParam param)
        {
            int iCount = _sql.ExistsUser(param.LoginName);
            if (iCount == 1)
            {
                _sql.UpdatePsw(param.LoginName, StringHelper.EncodeUtf8Base64(param.NewPassword));
            }
            return iCount;
        }
_sql 通过ISqlDispatchProxy  实现。我测试了用实现IRepository 实现是不会报这个错误
报错内容

```
System.InvalidOperationException: The connection was not closed. The connection's current state is open.
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.Open()
   at StackExchange.Profiling.Data.ProfiledDbConnection.Open() in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbConnection.cs:line 121
   at Furion.DatabaseAccessor.DbObjectExtensions.OpenConnection(DatabaseFacade databaseFacade, DbConnection dbConnection)
   at Furion.DatabaseAccessor.DbObjectExtensions.PrepareDbCommand(DatabaseFacade databaseFacade, String sql, Object model, CommandType commandType)
   at Furion.DatabaseAccessor.SqlAdoNetExtensions.ExecuteNonQuery(DatabaseFacade databaseFacade, String sql, Object model, CommandType commandType)
   at Furion.DatabaseAccessor.SqlDispatchProxy.ExecuteSql(SqlProxyMethod sqlProxyMethod)
   at Furion.DatabaseAccessor.SqlDispatchProxy.Invoke(MethodInfo targetMethod, Object[] args)
--- End of stack trace from previous location ---
   at System.Reflection.DispatchProxyGenerator.Invoke(Object[] args)
   at generatedProxy_1.UpdatePsw(String , String )
   at SmartSearch.Application.Services.HomeService.UpdateUserInfo(UpdateUserParam param) in E:\Work\SmartSearchWeb\SmartSearchWeb\SmartSearch.Application\Services\HomeService.cs:line 236
   at lambda_method65(Closure , Object , Object[] )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker)
   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)
```

GVP dotNET China/Furion

内容风险标识

评论 (7)

GVPdotNET China/Furion

内容风险标识