title: Distinct Value from Linq Query
body: <p>I have the below <code>class</code> and <code>linq</code> query I am using to populate a <code>grid</code>!</p>
  
  <p>The <code>Title</code> is the same for every row returned.  What I am trying to do is populate <code>mString</code> with the <code>distinct</code> <code>Title</code> from the query so I can bind it to a seperate textblock. </p>
  
  <p>I probably didnt need to show all the code, but maybe it will help.  How can I show the <code>distinct Title</code>. </p>
  
  <pre><code>public class Items
  {
      public int Id { get; set; }
      public string Details { get; set; }
      public string Title { get; set; }
      public int NewNumber { get; set; }
  }
  
  private ObservableCollection&lt;Items&gt;  mItem = new ObservableCollection&lt;Items&gt;();
  private string mString = string.Empty;
  
  public string SpecTitle
  {
      get { return mString; }
  }
  
  public ObservableCollection&lt;Items&gt; GetItems
  {
      get { return mItem; }
  }
  </code></pre>
  
  <p>Here is the linq query</p>
  
  <pre><code>var results = (from z in mContext.View
                 orderby z.ItemNumber ascending
                 where z.ItemId == mId
                 select new Items()
                 {                                         
                     Id = z.ItemId,
                     Details = z.Details,
                     Title = z.ItemTitle,
                     NewNumber = z.ItemNumber
                 });
  
  List&lt;Items&gt; mNewItems = results.ToList();
  mItem.Clear();
  mNewItems.ForEach(y =&gt; mItem.Add(y));
  </code></pre>