V7.4.3 building a Back Office "Relations Manager" plugin which I hope to release as a package. The very last step is to update the umbracoRelation table. I have the query which works when run independently. I can call the controller, but I can't quite get the syntax for the db to actually update. Any nudge in the right direction would be appreciated. Here's what I have atm which fails at db.Update(query);:-

    // Update the relevant site's parentId
    public bool SaveSite(int newParentId, int siteId) {
        //get the database
        var db = UmbracoContext.Application.DatabaseContext.Database;
        //build a query to update the umbracoRelation table
        var query = "UPDATE umbracoRelation SET parentId = '" + newParentId + "' WHERE childId = '" + siteId + "'";
        //update data in DB with the query and return true if complete
        try {
            db.Update(query);
            return true;
        } catch {
            return false;
        }
    }

Thnx,

Craig