title: Entity Framework's Where statement with whitespaces at the end
body: <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>