Linq Double contains
<p>In my DB I have this field :<code>mySerial Double?</code><br>
I have a Multicritera Search, and I have to search on this field.<br>
User want to search on this field typing the start, the end or anything they want. </p>

<p>So I did this : </p>

<pre class="lang-cs prettyprint-override"><code>results.Where(x =&gt; x.mySerial.ToString().Contains(TextBox_mySerial.Text)) ;
</code></pre>

<p>When I search for : "88890"<br>
I should have :888900, 888901, 888903, 888908, 888909 as result. <br>
But 
I only get : 888889</p>

<p>Linq turn <code>.ToString().Contains</code> my into:</p>

<pre class="lang-sql prettyprint-override"><code>WHERE CONVERT(NVARCHAR(30), [t0].[mySerial], 2) LIKE '%88890%'
</code></pre>

<p>But what I want is :</p>

<pre class="lang-sql prettyprint-override"><code>WHERE [mySerial] LIKE '%88890%'
</code></pre>

<p>Is there any way to achieve this in Linq or do I have to cast <code>[mySerial]</code> in my view into a varchar ? </p>