title: Case-insensitive "contains" in Linq
body: <p>I have a mvc project which I use linq in it. 
  In my database there is some records, for example "Someth ing","SOmeTH ing","someTh ing","SOMETH ING","someTH ING"</p>
  
  <p>I want to do this:</p>
  
  <pre><code>SELECT * FROM dbo.doc_dt_records WHERE name LIKE '%' + @records.Name + '%'
  </code></pre>
  
  <p>However if I run this code, list.Count returns 0. What should I do? </p>
  
  <pre><code>    records.Name = "someth ing"; //for example
      var rec = db.Records.ToList();
           var lists = rec.Where(p =&gt; p.Name.Contains(records.Name)).ToList();
  if (lists.Count &gt; 0)
  {
      // do sthng
  }
  </code></pre>
  
  <p>Thanks for your helps...</p>