title: Running multiline SQL query from C#
body: <p>Currently I am running SQL queries like this:</p>
  
  <pre><code>SqlConnection conn = new SqlConnection(SQLCONNECTION);
  var databases = new List&lt;string&gt;();
  
  using (var comm = new SqlCommand(SQLQUERY, conn))
  {
      conn.Open();
  
      using (var reader = comm.ExecuteReader())
      {
          while (reader.Read())
              databases.Add(reader.GetString(0));
      }
      conn.Close();
  }
  </code></pre>
  
  <p>But now I want to run an SQL Query like this (I have tested it in SQL Server Management Studio):</p>
  
  <pre><code>USE DATABASE
  GO
  SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
  </code></pre>
  
  <p>How do I run a multiline query like this via the C# methods I've been using?</p>