LINQ to Entities 不识别方法“Boolean IsNullOrWhiteSpace(System.String)”

最新推荐文章于 2022-11-07 15:45:19 发布

weixin_34294649

最新推荐文章于 2022-11-07 15:45:19 发布

阅读量590

点赞数

原文链接：https://my.oschina.net/HJCui/blog/844418

版权

LINQ to Entities 不识别方法“Boolean IsNullOrWhiteSpace(System.String)”,可以编译通过，执行时会报错。IsNullOrWhiteSpace()不能转化成SQL，同样IsNullOrEmpty()也是不行的。

You need to replace

!string.IsNullOrWhiteSpace(b.Diameter)

with

!(b.Diameter == null || b.Diameter.Trim() == string.Empty)

For Linq to Entities this gets translated into:

DECLARE @p0 VarChar(1000) = ''
...
WHERE NOT (([t0].[Diameter] IS NULL) OR (LTRIM(RTRIM([t0].[Diameter])) = @p0))

and for Linq to SQL almost but not quite the same

DECLARE @p0 NVarChar(1000) = ''
...
WHERE NOT (LTRIM(RTRIM([t0].[TypeName])) = @p0)

转载于:https://my.oschina.net/HJCui/blog/844418

关注