Convert a SQLite table to a JSON file

SQLiteTableToJson.cs

using System;
using System.Data.SQLite;
using System.IO;
using System.Text;

using Newtonsoft.Json;

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 string MakeJson(string connectionString, string sql)
        {
            var builder = new StringBuilder();
            var writer = new StringWriter(builder);

            using (var jsonWriter = new JsonTextWriter(writer))
            {
                Execute(connectionString, sql, (SQLiteDataReader reader) =>
                {
                    jsonWriter.WriteStartObject();
                    jsonWriter.WritePropertyName("Results");
                    jsonWriter.WriteStartArray();

                    for (var i = 0; i < reader.FieldCount; ++i)
                    {
                        jsonWriter.WriteStartObject();
                        jsonWriter.WritePropertyName(reader.GetName(i));
                        jsonWriter.WriteValue(reader.GetValue(i));
                        jsonWriter.WriteEndObject();
                    }

                    jsonWriter.WriteEndArray();
                    jsonWriter.WriteEndObject();
                });

                jsonWriter.Flush();
                return builder.ToString();
            }
        }

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

            File.WriteAllText(
                tempJsonFile, 
                MakeJson(allDbConnectionString, "select * from Parts"));

            Console.WriteLine("Done writing output to [" + tempJsonFile + "]");
        }
    }
}