Entity Framework's Where statement with whitespaces at the end
<p>I'm trying to use Where statement for retrieving data from the database and it's always returning data if whitespaces are added at the end of the string, so</p>

<pre><code>.Where(p =&gt; p.Username == "sysadmin")
</code></pre>

<p>and</p>

<pre><code>.Where(p =&gt; p.Username == "sysadmin      ")
</code></pre>

<p>both are returning data (I expect the second one to return null). And the same thing is with <code>WebSecurity.Login</code> method, it is logging in succesfully in both cases.</p>