public static void UpdateDBChannel(Channel parChan)
        {
            XmlReader reader = XmlReader.Create(parChan.url);
            SyndicationFeed feed = SyndicationFeed.Load(reader);

            using (var db = new ServerDataContext())
            {
                var chanToUpdate = (from chan in db.Channels where chan.id == parChan.id select chan).SingleOrDefault();
                // Mandatory section
                chanToUpdate.title = feed.Title.Text;
                chanToUpdate.link = feed.Links[0].Uri.AbsoluteUri;
                chanToUpdate.description = feed.Description.Text;

                // Not mandatory
                chanToUpdate.lastBuildDate = feed.LastUpdatedTime.DateTime;
                chanToUpdate.image = feed.ImageUrl != null ? feed.ImageUrl.ToString() : null;

                db.SubmitChanges();
            }
            if (feed == null)
                return;
            foreach (SyndicationItem item in feed.Items)
            {
                CreateDbItem(item, parChan);
            }
        }
        private static void CreateDbItem(SyndicationItem item, Channel chan)
        {
            using (var db = new ServerDataContext())
            {
                Item dbItem = null;
                string guid = item.Id;
                bool isNewItem = false;

                if (guid != null)
                {

                    var dbitems = from obj in db.Items where obj.Channel.id == chan.id && obj.guid == guid select obj;
                    if (dbitems.Count() >= 1)
                    {
                        Assert.AreEqual(dbitems.Count(), 1);
                        dbItem = dbitems.Single();
                    }

                }

                if (dbItem == null)
                {
                    isNewItem = true;
                    dbItem = new Item();
                }

                dbItem.id_channel = chan.id;
                dbItem.title = item.Title != null ? item.Title.Text : "";
                dbItem.link = item.Links.Count > 0 ? item.Links[0].Uri.AbsoluteUri : "";
                var date = item.LastUpdatedTime > item.PublishDate ? item.LastUpdatedTime : item.PublishDate;
                dbItem.pubDate = date;
                dbItem.description = item.Summary != null ? item.Summary.Text : "";
                dbItem.guid = item.Id != null ? item.Id : "";
                dbItem.author = item.Authors.Count > 0 ? item.Authors[0].Email : "";
                dbItem.category = item.Categories.Count > 0 ? item.Categories[0].Name : "";
                dbItem.comments = "";

                if (isNewItem)
                    db.Items.InsertOnSubmit(dbItem);
                db.SubmitChanges();
            }
        }
        private static Channel CreateDBChannelWithUri(Uri uri)
        {
            XmlReader reader = XmlReader.Create(uri.ToString());
            SyndicationFeed feed = SyndicationFeed.Load(reader);

            if (feed == null)
                return null;

            Channel chan = new Channel()
            {
                // Mandatory section
                title = feed.Title.Text,
                link = feed.Links[0].Uri.AbsoluteUri,
                description = feed.Description.Text,
                url = uri.AbsoluteUri,

                // Not mandatory
                lastBuildDate = feed.LastUpdatedTime.DateTime,
                image = feed.ImageUrl != null ? feed.ImageUrl.ToString() : null,
            };

            using (var db = new ServerDataContext())
            {
                db.Channels.InsertOnSubmit(chan);
                db.SubmitChanges();
            }

            foreach (SyndicationItem item in feed.Items)
            {
                CreateDbItem(item, chan);
            }

            return chan;
        }