code_junkie

How do I access the XML data in my column using LINQ to XML?

Nov 11th, 2011
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. <keywords>
  2. <keyword name="First Name" value="|FIRSTNAME|" display="Jack" />
  3. <keyword name="Last Name" value="|LASTNAME|" display="Jones" />
  4. <keyword name="City" value="|CITY|" display="Anytown" />
  5. <keyword name="State" value="|STATE|" display="MD" />
  6. </keywords>
  7.  
  8. GeneratedArticle ga = db.GeneratedArticles.Single(p => p.GeneratedArticleId == generatedArticleId);
  9.  
  10. var keywords = from k in ga.ArticleKeywords.Elements("Keywords")
  11. select k;
  12.  
  13. foreach (var keyword in keywords)
  14. {
  15. //what goes here?
  16. }
  17.  
  18. // IEnumerable sequence with keywords data
  19. var keywords = from kw in ga.ArticleKeywords.Elements("keyword")
  20. select new {
  21. Name = (string)kw.Attribute("name"),
  22. Value = (string)kw.Attribute("value"),
  23. Display = (string)kw.Attribute("display")
  24. };
  25.  
  26.  
  27. foreach (var keyword in keywords)
  28. {
  29. var kw = "Name: " + keyword.Name +
  30. " Value: " + keyword.Value +
  31. " Display: " + keyword.Display;
  32. Console.WriteLine(kw);
  33. }
  34.  
  35. var keywords = from kw in ga.ArticleKeywords.Element("keywords").Elements()
  36.  
  37. var keywords = from kw in ga.ArticleKeywords.Element("keywords").Elements("keyword")
  38.  
  39. var keywords = from kw in ga.ArticleKeywords.Descendants("keyword")
  40.  
  41. var keywordData = from k in ga.ArticleKeywords.Elements("Keywords")
  42. select new { Value = k.Attributes["value"].Value,
  43. Display = k.Attributes["display"].Value};
Add Comment
Please, Sign In to add comment