public void SetNoteRead(long noteId) { using (var conn = this.Connection) using (var cmd = new UpdateCommand("UPDATE `notes` SET {0} WHERE `noteId` = @noteId", conn)) { cmd.Set("read", true); cmd.AddParameter("@noteId", noteId); cmd.Execute(); } }