title: How can I get .ToUpper() (or the equivalent) to work when using .Contains() in Linq to Sql?
body: <p>This code:</p>
  
  <pre><code>keyword = 's';
  IEnumerable&lt;Member&gt; searchResults = 
          (from m in members
           where m.ScreenName.ToUpper().Contains(keyword.ToUpper())
           select m).AsEnumerable();
  </code></pre>
  
  <p>Only returns records that have an uppercase 'S' in the <code>ScreenName</code>. Why is <code>m.ScreenName.ToUpper()</code> being ignored? How do I convert <code>m.ScreenName</code> to uppercase so I can perform case-insensetive checks?</p>
  
  <h1>Edit</h1>
  
  <p>This is not a duplicate. I attempted the solution in the proposed duplicate:</p>
  
  <pre><code>IEnumerable&lt;Member&gt; searchResults = 
         (from m in members
          where m.ScreenName.Contains(keyword, StringComparison.OrdinalIgnoreCase)
          select m).AsEnumerable();
  </code></pre>
  
  <p>This failed. <code>StringComparison.OrdinalIgnoreCase</code> is not a valid parameter for .Contains().</p>