The LINQ expression '(str1.CompareTo(str2) < 0)' could not be translated and will be evaluated locally

Question

I am trying to make an alphabetical comparison in LINQ but the expression cannot be compiled in SQL.

Any hint?

The suggested answer does not work. I get:

The LINQ expression '(Compare([f].str1, str2, Ordinal) < 0)' could not be translated and will be evaluated locally.

@Seb: How would you expect that to even compile? There's no `<(string, string)` operator. — Jon Skeet, Feb 23 '16 at 20:46
Possible duplicate of [Linq function like .Net string.CompareOrdinal](http://stackoverflow.com/questions/15784340/linq-function-like-net-string-compareordinal) — Matthew Whited, Feb 23 '16 at 20:50

score 2 · Answer 1 · answered Feb 23 '16 at 20:49

2

you need to use string.Compare(...)

.Where(e => string.Compare(str1, str2, StringComparison.OrdinalIgnoreCase) < 0)

answered Feb 23 '16 at 20:49

Matthew Whited

Actually the third argument doesn't matter, so `string.Compare(str1, str2)` is sufficient. – Ivan Stoev Feb 23 '16 at 21:00
2

It still does not like it: The LINQ expression '(Compare([f].str1, str2, Ordinal) < 0)' could not be translated and will be evaluated locally. – user2715109 Feb 23 '16 at 21:02
if you want more help you will need to include sample code such as the method body giving you problems. The issue seems to be in the way you are constructing your query. – Matthew Whited Feb 24 '16 at 14:16
I am using this class to construct my query: http://www.albahari.com/nutshell/predicatebuilder.aspx – user2715109 Feb 24 '16 at 19:54

1 Answers1