using System;

using System.Data.SQLite;

public class Program

{

    public static void Main()

    {

        string cs = "Data Source=database.sqlite;Cache Size=0";

        using(var con = new SQLiteConnection(cs))

        {

            con.Open();

            using (SQLiteCommand command = con.CreateCommand())

            {

                command.CommandText = "CREATE TABLE Test (NAME TEXT NOT NULL)";

                command.ExecuteNonQuery();

            }

        }

        using(var con = new SQLiteConnection(cs))

        {

            con.Open();

            using (SQLiteCommand command = con.CreateCommand())

            {

                command.CommandText = "INSERT INTO Test (NAME) VALUES ('marcOcram')";

                command.ExecuteNonQuery();

            }

        }

        using(var con = new SQLiteConnection(cs))

        {

            con.Open();

            using (SQLiteCommand command = con.CreateCommand())

            {

                command.CommandText = "SELECT NAME FROM Test";

                using (SQLiteDataReader dataReader = command.ExecuteReader())

                {

                    while (dataReader.Read())

                    {

                        Console.WriteLine(dataReader["NAME"]);  

                    }

                }

            }

        }

        using(var con = new SQLiteConnection(cs))

        {

            con.Open();

            using (SQLiteCommand command = con.CreateCommand())

            {

                command.CommandText = "UPDATE Test SET NAME = 'Kokujou' WHERE NAME = 'marcOcram'";

                command.ExecuteNonQuery();

            }

        }

        using(var con = new SQLiteConnection(cs))

        {

            con.Open();

            using (SQLiteCommand command = con.CreateCommand())

            {

                command.CommandText = "SELECT NAME FROM Test";

                using (SQLiteDataReader dataReader = command.ExecuteReader())

                {

                    while (dataReader.Read())

                    {

                        Console.WriteLine(dataReader["NAME"]);  

                    }

                }

            }

        }

    }

}