Trying to get first letter of string in Linq

My error today;

LINQ to Entities does not recognize the method ‘Char get_Chars(Int32)’ method, and this method cannot be translated into a store expression.

I was trying to get list of records that matches fist letter of string.  But I guess it’s not as simple as just

but this worked.

 

Leave a Reply