public static void Remove_FavoriteItem(FavDataSQL starred) { using (var db = new SQLite.SQLiteConnection(SQLDBPath)) { SQLiteCommand cmd = db.CreateCommand(string.Format("DELETE from FavDataSQL WHERE FavID = {0}", starred.FavID)); List <FavDataSQL> result = cmd.ExecuteQuery <FavDataSQL>(); } }
public static void Insert_FavoriteItem(FavDataSQL fav) { if (SQLDBPath == null) { throw new Exception("SQL is not init yet, please call 'LoadSQLTableData()'."); } using (SQLiteConnection db = new SQLiteConnection(SQLDBPath)) { SQLiteCommand cmd = db.CreateCommand(string.Format("SELECT * from FavDataSQL WHERE FavID='{0}' LIMIT 1", fav.FavID)); List <FavDataSQL> result = cmd.ExecuteQuery <FavDataSQL>(); if (result.Count == 0) { db.RunInTransaction(() => { db.Insert(fav); }); } } }