title: How to use ToString() method to convert an integer to string inside LINQ
body: <p>When I try to use ToString() inside the below LINQ Lambda expression, I get an exception saying "LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression."  </p>
  
  <pre><code>query = query.Where(q =&gt; q.date.ToString().Contains(filtertext)
                            || q.invoicenum.ToString().Contains(filtertext)
                            || q.trans_type.ToString().Contains(filtertext)
                            || q.charge.Contains(filtertext));
  </code></pre>
  
  <p>I am using Linq to entites. And the Database used is MySQL and not the SQL Server. Immediate help would be highly appreciated.             </p>