title: Can I create an anonymous type collection from a DataReader?
body: <p>I have this code:</p>
  
  <pre><code>var query = "SELECT * FROM Cats";
  
  var conn = new SqlConnection(sqlConnectionString);
  
  conn.Open();
  
  var cmd = new SqlCommand(query);
  var reader = cmd.ExecuteReader();
  
  while (reader.Read())
  {
      var CatName = reader.GetString(0);
      var CatDOB = reader.GetDateTime(1);
      var CatStatus = reader.GetInt32(2);
  }
  </code></pre>
  
  <p>I'd like to pull the rows out into an anonymous type collection, which I'd normally do using LINQ to iterate, but I an not sure if it's possible due to the way you have to call <code>.Read()</code> each time to get the next row.</p>
  
  <p>Is there a way to do this?</p>