title: SQL generated by EntityFramework StartsWith() contains plan altering ESCAPE '~' (tilde)
body: <p>Using EntityFramework, the clause <code>.OrderBy(x =&gt; x.Title.StartsWith("foo"))</code> results in the SQL <code>WHERE (Title LIKE 'foo%' ESCAPE '~')</code>. </p>
  
  <p>Looking at the execution plan for the full query I see that I get a different plan (one making use of the column's non clustered index) when I remove the <code>ESCAPE '~'</code>. </p>
  
  <p>Why is EF trying to escape a string which doesn't need it, and how can I make it stop? </p>