title: String.Equals() not working as intended
body: <p>I am using LINQ to search through one of my Entity Framework tables and find a "group" based on the name. The name is a string and appears to be Unicode (says it is in the edmx). I have a method <code>GetGroup()</code> and I pass in a name to search for. Debugging through the code, I already have a group named "Test" in my database. Once I pass in a group named "TEST" I expect it to return the "Test" which was already in the database. It for some reason, does not find the "Test" and thinks "TEST" doesn't exist. Here is my query, I cannot see why it does not work. Please help.</p>
  
  <p>"name" is the passed in the group name. My <code>.Equals</code> seems to only work if the <code>gr.Name</code> and name are the exact same. If one character is capital in one of the two strings, then the .Equals doesn't work.  I have tried to use <code>InvariantCultureIgnoreCase</code>, and that did not seem to help.  In case someone asks, the <code>MyLeagueId</code> and <code>LeagueId</code> will always match, the database is setup so there can be a group in a different league id. I do not think this is the problem.</p>
  
  <pre><code>Group g = (from gr in this.DatabaseConnection.Groups
             where gr.Name.Equals(name, StringComparison.OrdinalIgnoreCase) &amp;&amp;
             gr.LeagueId == this.MyLeagueId
             select gr).FirstOrDefault();
  </code></pre>