title: LINQ To SQL Contains Case Sensitive Searching
body: <p>When I use below query, it gets result perfectly. But it is case-sensitive. Here is my codes:</p>
  
  <pre><code>    IQueryable&lt;article&gt; results;
      if (rrbAuthor.IsChecked)
          results = (from a in _db.articles join k in _db.keywords on a.id equals k.aid where a.author.Contains(textBox1.Text) select a).Distinct();
      else if (rrbKeywords.IsChecked)
          results = (from a in _db.articles join k in _db.keywords on a.id equals k.aid where k.word.Contains(textBox1.Text) select a).Distinct();
      else
          results = (from a in _db.articles join k in _db.keywords on a.id equals k.aid where a.title.Contains(textBox1.Text) select a).Distinct();
  
      ListArticles(results, 1);
  </code></pre>
  
  <p>How can I manage to get results in in-sensitive case?</p>