C# -如何将表中所有列的名称插入到列表中。SQLITE

using System;
using System.Collections.Generic;
using System.Data.SQLite;

namespace SQLiteExample
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Data Source=database.db;Version=3;";
            using (SQLiteConnection connection = new SQLiteConnection(connectionString))
            {
                connection.Open();

                string tableName = "your_table_name";
                List<string> columnNames = new List<string>();

                using (SQLiteCommand command = new SQLiteCommand($"PRAGMA table_info({tableName})", connection))
                {
                    using (SQLiteDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            string columnName = reader["name"].ToString();
                            columnNames.Add(columnName);
                        }
                    }
                }

                foreach (string columnName in columnNames)
                {
                    Console.WriteLine(columnName);
                }
            }
        }
    }
}