public bool insertOrUpdate(Kv kv) { string sql = $"insert or replace into {tbName_} (k,v,r) values (:k,:v,:r)"; SQLiteCommand command = new SQLiteCommand(sql, conn_); command.Parameters.Add(new SQLiteParameter(":k", kv.k)); command.Parameters.Add(new SQLiteParameter(":v", kv.v)); command.Parameters.Add(new SQLiteParameter(":r", kv.r)); command.ExecuteNonQuery(); return(true); }
public List <Kv> fuzzyQuery(string k) { string sql = $"select * from {tbName_} where k like :k"; SQLiteCommand cmd = new SQLiteCommand(sql, conn_); cmd.Parameters.Add(new SQLiteParameter(":k", $"%{k}%")); SQLiteDataReader dr = cmd.ExecuteReader(); List <Kv> result = new List <Kv>(); if (dr != null && dr.Read()) { Kv kv = new Kv(); kv.k = dr["k"] as string; kv.v = dr["v"] as string; kv.r = dr["r"] as string; result.Add(kv); } return(result); }