dotnetnext / mysqlsugar Goto Github PK

tinyint被映射为boolean

Insert Without the AUTO_INCREMENT

as title

MySqlSugar.SqlSugarException: 错误信息：实体映射出错。
错误详情：Index was outside the bounds of the array.
at MySqlSugar.Check.Exception(System.Boolean isException, System.String message, System.String[] args) at offset 19
at MySqlSugar.SqlSugarTool.DataReaderToList[T](System.Type type, System.Data.IDataReader dr, System.String fields, System.Boolean isClose, System.Boolean isTry) at offset 354
at MySqlSugar.SqlSugarClient.SqlQuery[T](System.String sql, System.Collections.Generic.List1 pars) at offset 306 at MySqlSugar.SqlSugarClient.SqlQuery[T](System.String sql, System.Object whereObj) at offset 14 at Manage.Webapi.Controllers.JobMaintainController.GetPageCallData(Manage.Models.ViewModel.Search1 search) at offset 50 in G:\svn\Manage.Webapi\Manage.Webapi\Controllers\Job\JobMaintainController.cs:line 115:col 13
at lambda_method(System.Runtime.CompilerServices.Closure, System.Object, System.Object[])
at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(System.Object target, System.Object[] parameters)
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.SyncObjectResultExecutor.Execute(Microsoft.AspNetCore.Mvc.Infrastructure.IActionResultTypeMapper mapper, Microsoft.Extensions.Internal.ObjectMethodExecutor executor, System.Object controller, System.Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__12.MoveNext() at offset 198
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at offset 12
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(System.Threading.Tasks.Task task) at offset 46
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__10.MoveNext() at offset 165
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at offset 12
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(Microsoft.AspNetCore.Mvc.Filters.ActionExecutedContext context) at offset 32
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(Microsoft.AspNetCore.Mvc.Internal.State& next, Microsoft.AspNetCore.Mvc.Internal.Scope& scope, System.Object& state, System.Boolean& isCompleted) at offset 905
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__13.MoveNext() at offset 47
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at offset 12
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(System.Threading.Tasks.Task task) at offset 46
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.d__23.MoveNext() at offset 166
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at offset 12
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(Microsoft.AspNetCore.Mvc.Filters.ResourceExecutedContext context) at offset 32
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(Microsoft.AspNetCore.Mvc.Internal.State& next, Microsoft.AspNetCore.Mvc.Internal.Scope& scope, System.Object& state, System.Boolean& isCompleted) at offset 2123
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.d__18.MoveNext() at offset 47
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at offset 12
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(System.Threading.Tasks.Task task) at offset 46
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.d__16.MoveNext() at offset 302
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at offset 12
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(System.Threading.Tasks.Task task) at offset 46
at Microsoft.AspNetCore.Builder.RouterMiddleware.d__4.MoveNext() at offset 459
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at offset 12
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(System.Threading.Tasks.Task task) at offset 46
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.d__6.MoveNext() at offset 900
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at offset 12
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(System.Threading.Tasks.Task task) at offset 46
at Exceptionless.AspNetCore.ExceptionlessMiddleware.d__3.MoveNext() at offset 115

比如有个student， 他有个属性是id，有个属性是name。
先查询一次id，会缓存一条语句， xxx+student4 //四参数student
再查一次，但是却是查name，一看缓存是4参，从缓存中读出，套参数，查询，悲催了。我看生成的语句后面还是 id = @id，却套个字符串值上去。