title: How to get distinct value of Upper and lower case?
body: <p>I have this function and I want to get distinct value in # Data #. but my problem is if there are two value with the same characters but one is Upper and one is Lower (i.e Comedy and comedy) it still have both value Comedy and comedy in my Data. So when I bind to Data...it shows both. </p>
  
  <p>My function is:</p>
  
  <pre><code>public void LoadBookGenre(Book abc)
  {
      var loadbook = from Book s in BookDB.Books where s.Genre == abc.Genre select s;
      BookAttribute.Clear();
      foreach (Book m in loadbook) BookAttribute.Add(m);
      List&lt;Book&gt; distinct = BookAttribute.GroupBy(a =&gt; a.Genre).Select(g =&gt; g.First()).ToList(); 
      Data.Clear(); 
      foreach (Book s in distinct) Data.Add(s);
  }
  </code></pre>