String.IsNullOrWhiteSpace in LINQ Expression

by

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)

More Related Contents:

  1. System.Linq.Expression.Compile error
  2. Get All instead of FirstOrDefault
  3. Join/Where with LINQ and Lambda
  4. How to create LINQ Expression Tree to select an anonymous type
  5. ‘Contains()’ workaround using Linq to Entities?
  6. How to perform Join between multiple tables in LINQ lambda
  7. “A lambda expression with a statement body cannot be converted to an expression tree”
  8. Mutating the expression tree of a predicate to target another type
  9. C# – code to order by a property using the property name as a string [duplicate]
  10. LEFT JOIN in LINQ to entities?
  11. Can I specify my explicit type comparator inline?
  12. How to compare only date components from DateTime in EF?
  13. Multiple Order By with LINQ [duplicate]
  14. How to convert an expression tree to a partial SQL query?
  15. lambda expressions in immediate window for VS2015
  16. Cannot use a lambda expression as an argument to a dynamically dispatched operation without first casting it to a delegate or expression tree type
  17. Cannot convert lambda expression to type ‘string’ because it is not a delegate type [duplicate]
  18. LINQ – Query syntax vs method chains & lambda [closed]
  19. How do I perform Date Comparison in EF query?
  20. How to get first record in each group using Linq
  21. How to merge a list of lists with same type of items to a single list of items?
  22. How to check for nulls in a deep lambda expression? [duplicate]
  23. convert this LINQ expression into Lambda
  24. Calling a SQL User-defined function in a LINQ query
  25. How do I dynamically create an Expression predicate?
  26. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  27. How do you construct a LINQ to Entities query to load child objects directly, instead of calling a Reference property or Load()
  28. Linq – Top value from each group
  29. Only parameterless constructors and initializers are supported in LINQ to Entities message
  30. Convert DataTable to Generic List in C#

Leave a Comment