title: How do I get a distinct, ordered list of names from a DataTable using LINQ?
body: <p>I have a <code>DataTable</code> with a <code>Name</code> column. I want to generate a collection of the unique names ordered alphabetically. The following query ignores the <em>order by</em> clause.</p>
  
  <pre><code>var names =
      (from DataRow dr in dataTable.Rows
      orderby (string)dr["Name"]
      select (string)dr["Name"]).Distinct();
  </code></pre>
  
  <p>Why does the <code>orderby</code> not get enforced?</p>