title: Enumerate SqlDataReader Columns
body: <p>Given the following code snip:</p>
  
  <pre><code>using (var reader = cmd.ExecuteReader())
  {
      while(reader.Read())
      {
          var count = reader.FieldCount; // the first column must be name all subsequent columns are treated as data
          var data = new List&lt;double&gt;();
          for (var i = 1; i &lt; count; i++)
          {
              data.Add(Convert.ToDouble(reader[i].ToString()));
          }
          barChartSeries.Add(new ColumnBarChart.ColumnChartSeries((string)reader[0],
                                                                  data));
          columnChart.xAxis.categories.Add((string)reader[0]);
      }
  }
  </code></pre>
  
  <p>Is there an easy way to eliminate the for loop? Perhaps using linq?</p>
  
  <p>reader[0] will always be a string
  reader[0+?] will be a double </p>
  
  <p>I want to pull all the doubles into a list if possible.</p>