如何获取包含在MySQL数据库中的所有表名的List<string>
?
我想将完整的数据库加载到DataSet中,但据我所知,似乎MySqlDataAdapter.Fill()只能操作单个表格,是吗?这就是我想使用表格字符串集合的原因。
编辑:
I look for the correct query: The following returns 59 different items despite the database only holding 3 tables:
MySqlCommand command = new MySqlCommand("SELECT table_name FROM information_schema.tables where table_type = 'BASE TABLE'", connection); var result = command.ExecuteReader();
I look for C# code to parse the result of the query into a
List<string>
.