String.ToLowerInvariant not working in lambda expression

Asked Jan 16 '16 at 08:45

Active Jan 16 '16 at 10:24

Viewed 232 times

When I use ToLowerInvariant or ToUpperInvariant they don't work in lambda expressions.

I get an exception:

LINQ to Entities does not recognize the method 'System.String ToUpperInvariant()' method, and this method cannot be translated into a store expression.

How can I use these methods or how can I convert UTF8 characters inside lambda expressions to lower or upper case?

  var words = context.Words;

  if (words.Any(wr => wr.Orthography.ToUpperInvariant() == textRange.Text.ToUpperInvariant()))

edited Jan 16 '16 at 10:24

marc_s

732,580
175
1,330
1,459

asked Jan 16 '16 at 08:45

Elvin Mammadov

25,329
11
40
82

1

Is `words` an IQueryable? – Domysee Jan 16 '16 at 08:47
@Domysee, thanks a lot. – Elvin Mammadov Jan 16 '16 at 09:11
Well, I've deleted my answer because you shouldn't actually use it. `context.Words.ToList();` would retrieve *all* words, but you just need to know if any of them satisfies the constraint. – Domysee Jan 16 '16 at 09:31

String.ToLowerInvariant not working in lambda expression

0 Answers0