sqlite3.ca

using System;
using System.Data.SQLite;

public class DatabaseUpdater
{
    private SQLiteConnection sqlite_conn;
    private SQLiteCommand sqlite_cmd;

    public DatabaseUpdater(string connectionString)
    {
        sqlite_conn = new SQLiteConnection(connectionString);
        sqlite_conn.Open();
        sqlite_cmd = sqlite_conn.CreateCommand();
    }

    public void UpdateDatabase(int id, string user, string site, string clientSeed, string clientSeedHash, string serverSeedHash, int nonce, double balance, DateTime created, DateTime updated)
    {
        sqlite_cmd.CommandText = @"UPDATE YourTableName SET
                                    user = @user,
                                    site = @site,
                                    client_seed = @clientSeed,
                                    client_seed_hash = @clientSeedHash,
                                    server_seed_hash = @serverSeedHash,
                                    nonce = @nonce,
                                    balance = @balance,
                                    created = @created,
                                    updated = @updated
                                  WHERE id = @id";

        sqlite_cmd.Parameters.AddWithValue("@id", id);
        sqlite_cmd.Parameters.AddWithValue("@user", user);
        sqlite_cmd.Parameters.AddWithValue("@site", site);
        sqlite_cmd.Parameters.AddWithValue("@clientSeed", clientSeed);
        sqlite_cmd.Parameters.AddWithValue("@clientSeedHash", clientSeedHash);
        sqlite_cmd.Parameters.AddWithValue("@serverSeedHash", serverSeedHash);
        sqlite_cmd.Parameters.AddWithValue("@nonce", nonce);
        sqlite_cmd.Parameters.AddWithValue("@balance", balance);
        sqlite_cmd.Parameters.AddWithValue("@created", created.ToString("s"));
        sqlite_cmd.Parameters.AddWithValue("@updated", updated.ToString("s"));

        sqlite_cmd.ExecuteNonQuery();
    }

    public void CloseConnection()
    {
        sqlite_conn.Close();
    }
}