Read SQLite table columns

ReadSqliteTableColumns.cs

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

namespace Sqlite3ToJson
{
    class Program
    {
        static void Execute(string connectionString, string sql, Action<SQLiteDataReader> action)
        {
            using (var connection = new SQLiteConnection(connectionString))
            using (var command = connection.CreateCommand())
            {
                connection.Open();

                command.CommandText = sql;
                command.CommandType = System.Data.CommandType.Text;

                using (var reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        action(reader);
                    }
                }

                connection.Close();
            }
        }

        static Dictionary<string, string> GetColumns(string connectionString, string table)
        {
            var query = "pragma table_info(" + table + ")";
            var columns = new Dictionary<string, string>();

            Execute(connectionString, query, (SQLiteDataReader reader) =>
            {
                columns[reader[1] as string] = reader[2] as string;
            });

            return columns;
        }

        static void Main(string[] args)
        {
            var allDbConnectionString = @"Data Source=..\..\data\alldb.sqlite3;Version=3;";

            foreach (var c in GetColumns(allDbConnectionString, "Parts"))
            {
                Console.WriteLine(c.Key + " => " + c.Value);
            }
        }
    }
}