title: LINQ inserts 'ESCAPE N'~' in query
body: <p>When I examine the SQL query the Linq spits out, I noticed that it places a ESCAPE N'~' when doing a LIKE command.  How do I get rid of this?  It seems like the query takes twice as long with the ESCAPE is in the SQL.</p>
  <p>Here is the LINQ</p>
  <pre><code>var SearchPhrase = &quot;xyz&quot;;
  
  var result = (from i in db.myTable
                where i.col1.contains(SearchPhrase)
                select i).toList();
  </code></pre>
  <p>When I look at the actual SQL it looks something like this:</p>
  <pre><code>   SELECT 
         [Extent1].Col1
     FROM myTable As [Extent1]
     WHERE [Extent1].Col1 LIKE @p__linq__3 ESCAPE N'~'
  </code></pre>