Parsing batch of T-SQL statements via IDataReader

I wasn’t aware of it, until now anyway…       

using (SqlConnection conn = new SqlConnection(“your-connection-string”))
{
   string query = “SELECT * FROM T1; SELECT * FROM T2;”;
   SqlCommand cmd = new SqlCommand(query, conn);
   
   conn.Open();
   SqlDataReader reader = cmd.ExecuteReader();
   do
   {
      while(reader.Read())
      {
         // read each row in the statement results.
      }
   }
   while(reader.NextResult()); // jump to the next statement results.
}