注册

Microsoft.EntityFrameworkCore.Dm语句转换问题

At First 2024/09/05 400 3 已解决

使用Microsoft.EntityFrameworkCore.Dm执行查询通过跟踪出来的语句执行失败了以下附上语句:
SELECT CAST(COUNT() AS INT)
FROM LQMS.FlowScheme AS f
WHERE TRUE & CASE
WHEN f.DeleteMark = 0 THEN TRUE
ELSE FALSE END;

我在中间加上缺失的&符号就执行成功了以下附上语句:
SELECT CAST(COUNT(*) AS INT)
FROM LQMS.FlowScheme AS f
WHERE TRUE && CASE
WHEN f.DeleteMark = 0 THEN TRUE
ELSE FALSE END;image.png1

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