Hello,
I am using the following Linq Query:
var filter = (from t in database.Tags
where t.Name.StartsWith(q,
StringComparison.CurrentCultureIgnoreCase)
orderby t.Name
select t);
But I am getting an error:
Server Error in '/' Application
The method 'StartsWith' has a translation to SQL, but the overload
'Boolean StartsWith (System.String, System.StringComparison)' does
not.
Description:
An unhandled exception occurred during the execution of the current
web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details:
System.NotSupportedException: The method 'StartsWith' has a
translation to SQL, but the overload 'Boolean
StartsWith(System.String, System.StringComparison)' does not.
Does anyone has any idea what am I doing wrong?
Thanks,
Miguel