title: Linq query: append column to query results
body: <p>I am trying to figure out how to append a column to Linq query results based on the max value of the query.  Essentially, I want to create an EnumerableRowCollection of DataRows that would include a max value record with the same value for each record.  So if i have a hundred records returned through the query, I want to next calculate the max value of one of the fields, then append that max value to the original query table:</p>
  
  <pre><code>DataTable dt = new DataTable();
  dt = myDataSet.myDataTable;
  
  EnumerableRowCollection&lt;DataRow&gt; qrySelectRecords =
            (from d in dt.AsEnumerable()
             where d.Field&lt;DateTime&gt;("readingDate") &gt;= startDate &amp;&amp; g.Field&lt;DateTime&gt;("readingDate") &lt;= endDate
             select d);
  </code></pre>
  
  <p>Here's where I need help:</p>
  
  <pre><code>double maxValue = qrySelectRecords.Field&lt;double&gt;("field1").Max();
  
  foreach (DataRow dr in qrySelectRecords)
  {
   qrySelectRecords.Column.Append(maxValue)
  }
  </code></pre>