title: LINQ to Entities multiple columns need 1 to be distinct
body: <p>I am trying to select multiple columns from an entity object but I want 1 property to be distinct.  I am very new to both LINQ and Entity Framework so any help will be useful.</p>
  
  <p>Here is my LINQ query so far:</p>
  
  <pre><code>var listTypes = (from s in context.LIST_OF_VALUES
                   orderby s.SORT_INDEX
                   select new { s.LIST_TYPE, s.DISPLAY_TEXT });
  </code></pre>
  
  <p>I want s.LIST_TYPE to be distinct.  I figure using the groupby keyword is what I want (maybe?) but I have not found a way to use it that works.</p>
  
  <p>Thank you.</p>