C#中应用sqlite数据库

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));
                }
            }