test.exe

        static void Main(string[] args)
        {
            Console.WriteLine(".NET Version (" + Environment.Version + ") running on (" + Environment.OSVersion + ").");
            Console.WriteLine();
            Console.WriteLine("SQLite Database Access...");
            SqliteConnection sqlcon;
            SqliteCommand sqlcmd;
            SqliteDataAdapter DB;
            DataSet DS = new DataSet();
            DataTable DT = new DataTable();
            SqliteDataReader RDR;
            sqlcon = new SqliteConnection("Data Source=:memory:;New=True;Compress=False;");
            sqlcon.Open();
            Console.WriteLine(" - Connection established.");
            sqlcmd = sqlcon.CreateCommand();
            sqlcmd.CommandText = "CREATE TABLE blah(one varchar(10), two smallint)";
            sqlcmd.ExecuteNonQuery();
            Console.WriteLine(" - Table CREATEd.");
            sqlcmd.CommandText = "INSERT INTO blah values ('hello!', 10)";
            sqlcmd.ExecuteNonQuery();
            sqlcmd.CommandText = "INSERT INTO blah values ('goodbye!', 20)";
            sqlcmd.ExecuteNonQuery();
            Console.WriteLine(" - Data INSERTed..");
            sqlcmd.CommandText = "SELECT * FROM blah";
            Console.WriteLine(" - Data SELECTed.");
            RDR = sqlcmd.ExecuteReader();
            while (RDR.Read())
            {
                Console.WriteLine(RDR["two"].ToString());
            }
            RDR.Close();
            sqlcon.Close();
            Console.WriteLine(" - Connection closed. Press any key.");
            Console.ReadKey();