insert时爆Unknown column 'Discriminator' in 'field list'

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

### Furion 版本号

1.15.0

-----------

### Web 项目类型

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

-----------

### 描述你的问题

在执行insert的时候爆Unknown column 'Discriminator' in 'field list'，
看日志是多插了一个Discriminator字段，但是全局搜索关键字都搜不到这个词，
我是DB First。

-----------

### 异常堆栈信息

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> MySqlConnector.MySqlException (0x80004005): Unknown column 'Discriminator' in 'field list'
 ---> MySqlConnector.MySqlException (0x80004005): Unknown column 'Discriminator' in 'field list'
   at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 49
   at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 131
   at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 436
   at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 60
   at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 310
   at MySqlConnector.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) in /_/src/MySqlConnector/MySqlCommand.cs:line 255
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   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 Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.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__6_1(DbContext u)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.GetCount(Boolean onlyIfCheap)
   at System.Linq.Enumerable.Count[TSource](IEnumerable`1 source)
   at Furion.DatabaseAccessor.DbContextPool.SavePoolNow()
   at Furion.DatabaseAccessor.UnitOfWorkFilter.OnActionExecutionAsync(ActionExecutingContext context, ActionExecutionDelegate next)
   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)

附sql

```sql
INSERT INTO `vm_materials_pickinfo` (`barcode`, `corp_name`, `corp_sn`, `cost_center`, `Discriminator`, `loc_sn`, `mach_name`, `mach_sn`, `mat_brand`, `mat_brand_name`, `mat_cat`, `mat_is_old`, `mat_life_plan`, `mat_model`, `mat_name`, `mat_need_back`, `mat_packing_name`, `mat_packing_unit_name`, `mat_pic`, `mat_qty_unit_pack`, `mat_sn`, `mat_use_for_id`, `mp_mr_sn`, `pdt_name`, `pdt_op_name`, `pdt_op_sn`, `pdt_sn`, `picking_qty`, `pk_domain`, `pk_rdorder_sn`, `pk_return_time`, `pk_sn`, `pk_sync_info`, `pk_sync_time`, `pk_time`, `pk_u_costcenter`, `pk_u_pick_type`, `plicking_list_sn`, `supplier_name`, `supplier_sn`, `user_name`, `user_sn`, `vm_sn`)
VALUES ('', '', 'WHEAT', '', 'VmMaterialsPickinfo', '1', '', '', '', '', '', 0, 0, 'test001fff', 'test001', 0, '盒', '片', '/goods/2020-07/20200716200527.jpg', 9, 'test005', null, '', '', '', '', '', 9, '1', '', '', 'PK-VM01-20210312092656', '', '', '2021-03-12T09:26:56', '', null, '', '', 'HaiHong', '555', '5555', 'VM01');
SELECT `pk_id`, `mat_life_rest`, `mat_life_used`, `mp_mat_quota_consumption`, `mp_MPS_qty`, `mp_mr_project_sn`, `pk_cw_mblnr_sn`, `pk_cw_po_sn`, `pk_cw_receipt_sn`, `pk_mat_price`, `pk_mat_price_sum`, `pk_mat_res1`, `pk_mat_res2`, `pk_mat_res3`, `pk_mat_res4`, `pk_mat_res5`, `pk_qr_code`, `pk_return_mat_type`, `pk_return_sn`, `pk_synced`
FROM `vm_materials_pickinfo`
WHERE ROW_COUNT() = 1 AND `pk_id` = LAST_INSERT_ID();
```

-----------

### 代码或代码仓库

```csharp
 [UnitOfWork]
        private void SaveMaterialPickingInfo(PickingInfoDto pickingInfo, VmStock stock)
        {
            pickingInfo.PickingQty *= pickingInfo.MatQtyUnitPack;
            pickingInfo.MatIsOld = stock.LocMatQtyOld > 0;
            var dbPickingInfo = _mapper.Map<VmMaterialsPickinfo>(pickingInfo);
            _materialPickInfoRepository.Insert(dbPickingInfo); //插入出库信息
            stock.LocMatQtyNew -= pickingInfo.PickingQty; 
            _stockRepository.Update(stock);//更新库存信息
            var keep = _stockKeepRepository.SingleOrDefault(s =>
                s.SukUserSn == pickingInfo.UserSn && s.SukMatSn == pickingInfo.MatSn) ?? new VmStockKeep
            {
                SukUserSn = pickingInfo.UserSn,
                SukMatSn = pickingInfo.MatSn,
                SukMatQty = 0
            };
            keep.SukMatQty += pickingInfo.PickingQty;
            _stockKeepRepository.InsertOrUpdate(keep);//更新个人库存信息（非一次性用品，每个人手上有多少）
        }
```

-----------

### 数据库信息

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

-----------

### 期待结果

解决报错

-----------

GVP dotNET China/Furion

内容风险标识

评论 (6)

GVPdotNET China/Furion

内容风险标识