gistfile1.txt

public static void Archive(this IContent content)
        {
            var h = new UmbracoHelper(UmbracoContext.Current);
            var c = h.TypedContent(content.Id);

            if (c != null)
            {
                var u = c.Url;
                var xml = content.ToXml();

                var archive = new Archive();
                archive.Url = u;
                archive.Id = c.Id;

                var r = xml.CreateReader();
                r.MoveToContent();
                archive.Xml = r.ReadOuterXml();

                var db = ApplicationContext.Current.DatabaseContext.Database;
                db.BeginTransaction();

                var existing = db.SingleOrDefault<Archive>("select * from Archive where Url = @0", archive.Url);

                if (existing == null)
                    db.Insert(archive);
                else
                {
                    db.Execute("update Archive set Xml = @0 where Url = @1", archive.Xml, archive.Url);
                }

                db.CompleteTransaction();

                if (content.HasProperty("archived") && !content.GetValue<bool>("archived"))
                {
                    content.SetValue("archived", true);

                    if(!string.IsNullOrEmpty(content.Name))
                        ApplicationContext.Current.Services.ContentService.Save(content);

                }
            }
        }