[UnitOfWork] 属性开启事务，执行SqlNonQuery发生报错

:tw-1f1f7: **任务清单：**

- [ 报错信息 ]

```
信息：ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction.  The Transaction property of the command has not been initialized.
   at Microsoft.Data.SqlClient.SqlCommand.ValidateCommand(Boolean isAsync, String method)
   at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbCommand.cs:line 280
   at Furion.DatabaseAccessor.SqlAdoNetExtensions.ExecuteNonQuery(DatabaseFacade databaseFacade, String sql, DbParameter[] parameters, CommandType commandType)
   at Furion.DatabaseAccessor.SqlRepository`1.SqlNonQuery(String sql, DbParameter[] parameters)
   at Zhyq.Service.SystemManage.RoleService.SaveRoleAuth(Int64 roleId, String menuIds, String appMenuIds) in D:\SVN\智慧园区\03项目源码\0305后端\Zhyq\Zhyq.Service\SystemManage\RoleService.cs:line 165
   at Zhyq.Business.SystemManage.RoleBLL.SaveRoleAuth(Int64 roleId, String menuIds, String appMenuIds) in D:\SVN\智慧园区\03项目源码\0305后端\Zhyq\Zhyq.Business\SystemManage\RoleBLL.cs:line 114
   at Zhyq.Web.Area.Admin.SystemManage.RoleController.SaveRoleAuth(String RoleId, String MenuIds, String AppMenuIds) in D:\SVN\智慧园区\03项目源码\0305后端\Zhyq\Zhyq.Web\Area\Admin\SystemManage\RoleController.cs:line 168
   at lambda_method153(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.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>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)`
```

- [ 控制器代码 ]

```
        [HttpPost]
        [UnitOfWork]
        public async Task<TData> SaveRoleAuth([FromForm] string RoleId, [FromForm] string MenuIds,[FromForm] string AppMenuIds)
        {
            TData data = await _roleBLL.SaveRoleAuth(RoleId.ParseToLong(), MenuIds,AppMenuIds);
            return data;
        }
```

- [ 业务代码 ]

```
        public async Task<TData> SaveRoleAuth(long roleId, string menuIds, string appMenuIds)
        {
            TData obj = new TData();
            await _roleService.SaveRoleAuth(roleId, menuIds, appMenuIds);
            obj.Tag = 1;
            return obj;

}
```

- [ 数据服务代码 ]

```
public async Task SaveRoleAuth(long roleId, string menuIds, string appMenuIds)
        {
            string sql = "Delete From SysMenuAuthorize Where AuthorizeId =" + roleId;
            _roleEntityDB.SqlNonQuery(sql); // 执行到此处抛出上面的错误

sql = "Delete From SysAppMenuAuthorize Where AuthorizeId =" + roleId;
            _roleEntityDB.SqlNonQuery(sql);

if (!string.IsNullOrEmpty(menuIds))
            {
                foreach (long menuId in TextHelper.SplitToArray<long>(menuIds, ','))
                {
                    var menuAuthorizeEntity = new MenuAuthorizeEntity();
                    menuAuthorizeEntity.Id = IdGeneratorHelper.Instance.GetId();
                    menuAuthorizeEntity.AuthorizeId = roleId;
                    menuAuthorizeEntity.MenuId = menuId;
                    menuAuthorizeEntity.AuthorizeType = AuthorizeTypeEnum.Role.ParseToInt();
                    menuAuthorizeEntity.BaseCreateTime = DateTime.Now;
                    menuAuthorizeEntity.BaseCreatorId = 0;
                    _sysMenuAuthorizeDB.InsertNow(menuAuthorizeEntity);

}
            }

if (!string.IsNullOrEmpty(appMenuIds))
            {
                foreach (long appMenuId in TextHelper.SplitToArray<long>(appMenuIds, ','))
                {
                    var menuAuthorizeEntity = new AppMenuAuthorizeEntity();
                    menuAuthorizeEntity.Id = IdGeneratorHelper.Instance.GetId();
                    menuAuthorizeEntity.AuthorizeId = roleId;
                    menuAuthorizeEntity.MenuId = appMenuId;
                    menuAuthorizeEntity.AuthorizeType = AuthorizeTypeEnum.Role.ParseToInt();
                    menuAuthorizeEntity.BaseCreateTime = DateTime.Now;
                    menuAuthorizeEntity.BaseCreatorId = 0;
                    _appMenuAuthorizeDB.InsertNow(menuAuthorizeEntity);
                }
            }

}
```

GVP dotNET China/Furion

内容风险标识

评论 (1)

GVPdotNET China/Furion

内容风险标识