System.Data.Sqlite 上手指南

System.Data.Sqlite入手。。。
首先import/using：

 

代码

using System.Data.SQLite;

Connection和Command:

代码

private SQLiteConnection conn;

        private SQLiteCommand cmd;

连接db：

代码

conn = new SQLiteConnection("Data Source=c:\\test.db");
                conn.Open();

INSERT/UPDATE:

 

代码

cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO user(email,name) VALUES ('email','name')";
cmd.ExecuteNonQuery();

cmd.CommandText = "UPDATE userSET name = 'Codelicious' WHERE ID = 1";
cmd.ExecuteNonQuery();

SELECT:

 

代码

cmd.CommandText = "SELECT ID, name FROM user";
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
            {
                while (reader.Read())
                {
                    Console.WriteLine("ID: " + reader.GetInt16(0));
                    Console.WriteLine("name: " + reader.GetString(1));
                }
            }