注册

efcore7查询筛选翻译错误

Xiao 2024/08/09 287 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:win11
【CPU】:
【问题描述】*:使用的最新版本的efcore dm驱动,查询生成的语句如下:

--Failed executing DbCommand (19ms) [Parameters=[:__ef_filter__p_0='False', :__ef_filter__p_1='False'], CommandType='Text', CommandTimeout='30'] SELECT CAST(COUNT(*) AS INT) FROM "AppBusiness" AS "a" INNER JOIN ( SELECT "a0"."Id", "a0"."AccessFailedCount", "a0"."Avatar", "a0"."ConcurrencyStamp", "a0"."CreationTime", "a0"."CreatorId", "a0"."DeleterId", "a0"."DeletionTime", "a0"."Email", "a0"."EmailConfirmed", "a0"."EntityVersion", "a0"."ExtraProperties", "a0"."IsActive", "a0"."IsDeleted", "a0"."IsExternal", "a0"."LastModificationTime", "a0"."LastModifierId", "a0"."LastPasswordChangeTime", "a0"."LockoutEnabled", "a0"."LockoutEnd", "a0"."Name", "a0"."NormalizedEmail", "a0"."NormalizedUserName", "a0"."PasswordHash", "a0"."PhoneNumber", "a0"."PhoneNumberConfirmed", "a0"."SecurityStamp", "a0"."ShouldChangePasswordOnNextLogin", "a0"."Surname", "a0"."TenantId", "a0"."TwoFactorEnabled", "a0"."UserName" FROM "AbpUsers" AS "a0" WHERE (:__ef_filter__p_0 OR "a0"."IsDeleted" = 0) AND (:__ef_filter__p_1 OR ("a0"."TenantId" IS NULL)) ) AS "t" ON "a"."UserId" = "t"."Id" LEFT JOIN "AppRegion" AS "a1" ON "a"."RegionId" = "a1"."Id"

错误如下:
Dm.DmException (0x80004005): 第8 行附近出现错误:
查询使用值表达式作为过滤条件
at Dm.DmCommand.do_ExecuteDbDataReader(CommandBehavior behavior)
at Dm.DmCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Dm.Storage.Internal.DmExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.AsyncEnumerator.MoveNextAsync()

从参数上看bool\int值传参被转成string了

回答 0
暂无回答
扫一扫
联系客服