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

String.IsNullOrWhiteSpace in LINQ Expression

up vote 86 down vote favorite 17

I have the following code: return this.ObjectContext.BranchCostDetails.Where( b => b.TarrifId == tariffId && b.Diameter == diameter || (b.TarrifId==tariffId && !string.IsNullOrWhiteSpace(b.Diameter)) || (!b.TarrifId.HasValue) && b.Diameter==diameter); And I get this error when I try to run the code: LINQ to Entities does not recognize the method 'Boolean IsNullOrWhiteSpace(System.String)' method, and this method cannot be translated into a store expression." How can I solve this problem and write code better than this? c# linq lambda null linq-to-entities share improve this question edited Jul 18 '13 at 17:54 Nondeterministic narwhal 462 5 17 asked Mar 7 '12 at 18:20 Hossein Moradinia 2,044 8 45 79

add a comment

3 Answers

active oldest votes

up vote 167 down vote accepted

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) share improve this answer edited Mar 7 '12 at 22:08 answered Mar 7 '12 at 18:24 Phil 27.9k 4 62 77

3   Why? This code compiles: List<string> my = new List<string>(); var i = from m in my where !string.IsNullOrWhiteSpace(m) select m; –  Eric J. Mar 7 '12 at 18:24 28   It may compile, but it won't be translated into SQL by Linq to entities. Method 'Boolean IsNullOrWhiteSpace(System.String)' has no supported translation to SQL. The same applies for IsNullOrEmpty. –  Phil Mar 7 '12 at 18:27 Makes sense.... –  Eric J. Mar 7 '12 at 18:31 1   The same is true for Linq to SQL –  Phil Mar 7 '12 at 18:40 add a comment