//创建一个数据库
 SQLiteConnection.CreateFile("Database.sqlite");

//创建连接字符串
SQLiteConnection conn = new SQLiteConnection("Data Source=Database.sqlite;Version=3;");
//这是数据库登录密码
conn.SetPassword("1234");
//打开数据库
conn.Open();
string query = "create table table1 (id INTEGER, name VARCHAR)";
//创建命令
SQLiteCommand cmd = new SQLiteCommand(query, conn);
//执行命令
cmd.ExecuteNonQuery();
//释放资源
conn.Close();

SQLiteConnection conn = new SQLiteConnection("Data Source=Database.sqlite;Version=3;");
conn.Open();
string query = "insert into table1 (id,name) values(1,'小明')";
SQLiteCommand cmd = new SQLiteCommand(query, conn);
cmd.ExecuteNonQuery();
conn.Close();
cmd.Dispose();

using (SQLiteConnection conn = new SQLiteConnection("Data Source=Database.sqlite;Version=3;"))
{
  conn.Open();
  string query = "select * from table1";
  SQLiteCommand cmd = new SQLiteCommand(query, conn);
  SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);
  DataTable dt = new DataTable();
  da.Fill(dt);
}

using (SQLiteConnection conn = new SQLiteConnection("Data Source=Database.sqlite;Version=3;"))
{
  conn.Open();
  //设置数据库密码
  conn.ChangePassword("123456");
  conn.Clone();
}

using (SQLiteConnection conn = new SQLiteConnection("Data Source=Database.sqlite;Version=3;"))
{
  conn.SetPassword("123456");
  conn.Open();
  string query = "select * from table1";
  SQLiteCommand cmd = new SQLiteCommand(query, conn);
  SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);
  DataTable dt = new DataTable();
  da.Fill(dt);
  conn.Clone();
}

private bool QueryTran(List<string> queryList)
{
  SQLiteConnection conn = new SQLiteConnection("Data Source=DataBase;Version=3;");
  SQLiteCommand cmd = conn.CreateCommand();
  conn.Open();
  SQLiteTransaction tran = conn.BeginTransaction();
  bool check = false;
  try
  {
    foreach (string item in queryList)
    {
      cmd.CommandText = item;
      cmd.ExecuteNonQuery();
    }
    tran.Commit();
    check = true;
  }
  catch (Exception ex)
  {
    tran.Rollback();
    check = false;
    throw ex;
  }
  finally
  {
    conn.Close();
  }
  return check;
}