public static void ExtractEntitiesFromUrl(interaction_url interaction_url, string url, Repository tycheRepo)
        {
            AlchemyAPI.AlchemyAPI alchemyObj = new AlchemyAPI.AlchemyAPI();
            alchemyObj.SetAPIKey(ConfigurationManager.AppSettings["AlchemyAPIKey"]);

            string xml;
            XDocument xdoc;

            try
            {
                xml = alchemyObj.URLGetRankedNamedEntities(url);
            }
            catch
            {
                xml = "";
            }

            if (xml != "")
            {
                xdoc = XDocument.Load(new StringReader(xml));
                foreach (XElement e in xdoc.Descendants("entity"))
                {
                    interaction_url_entity entity = new interaction_url_entity();
                    entity.interaction_url_id = interaction_url.id;
                    entity.entity = e.Element("text").Value;
                    entity.entity_count = int.Parse(e.Element("count").Value);
                    entity.entity_relevance = decimal.Parse(e.Element("relevance").Value);
                    entity.entity_sentiment = e.Element("sentiment").Element("type").Value;
                    if (e.Element("sentiment").Element("score") != null)
                        entity.entity_sentiment_score = decimal.Parse(e.Element("sentiment").Element("score").Value);
                    else
                        entity.entity_sentiment_score = 0;
                    tycheRepo.Add(entity);
                }

                tycheRepo.Save();

                Thread.Sleep(12);
            }
        }
		private void detach_interaction_url_entities(interaction_url_entity entity)
		{
			this.SendPropertyChanging();
			entity.interaction_url = null;
		}
 partial void Updateinteraction_url_entity(interaction_url_entity instance);
 partial void Deleteinteraction_url_entity(interaction_url_entity instance);
 partial void Insertinteraction_url_entity(interaction_url_entity instance);