title: How to get `List<string>` of table names from MySQL db?
body: <p>How can I get <code>List&lt;string&gt;</code> of all table names contained in a MySQL database?</p>
  
  <p>I want to load a complete database into a DataSet but from my understanding it seems that MySqlDataAdapter.Fill() only operates on single tables, correct? That is what I want to use the table string collection for. </p>
  
  <p>EDIT: </p>
  
  <ol>
  <li><p>I look for the correct query: The following returns 59 different items despite the database only holding 3 tables:</p>
  
  <pre><code>    MySqlCommand command = new MySqlCommand("SELECT table_name FROM information_schema.tables where table_type = 'BASE TABLE'", connection);
      var result = command.ExecuteReader();
  </code></pre></li>
  <li><p>I look for C# code to parse the result of the query into a <code>List&lt;string&gt;</code>.</p></li>
  </ol>