Query Xml File for Records using Linq

by

You can do it like this:

var Result = from a in element.Descendants("Page")
             from b in a.Descendants("Type")
             select new
             {
               Page = a.Attribute("Name").Value,
               Type = b.Attribute("TypeID").Value,
               Fields = String.Join(",", b.Elements("Field").Select(x => x.Value))
             };
foreach (var item in Result)
{
  Console.WriteLine(String.Format("Page = {0}:Type={1}:Fields:{2}", item.Page, item.Type, item.Fields));
}

WORKING FIDDLE

Check my this blog article as well for more.

More Related Contents:

  1. Parse Xml response from a get method in C# using Linq
  2. LINQ to read XML
  3. Dynamically generate LINQ queries
  4. XElement namespaces (How to?)
  5. XDocument containing namespaces
  6. The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name
  7. Query an XDocument for elements by name at any depth
  8. Edit specific Element in XDocument
  9. Serialize an object to XElement and Deserialize it in memory
  10. Update XML with C# using Linq
  11. Linq to XML – update/alter the nodes of an XML Document
  12. How/Can I use linq to xml to query huge xml files with reasonable memory consumption?
  13. Case insensitive XML parser in c#
  14. Fluent and Query Expression — Is there any benefit(s) of one over other?
  15. linq case statement
  16. Use own IComparer with Linq OrderBy
  17. How to convert list of arrays into a multidimensional array
  18. How to use the IEqualityComparer
  19. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  20. An expression tree lambda may not contain a null propagating operator
  21. Encoding XPath Expressions with both single and double quotes
  22. LINQ aggregate and group by periods of time
  23. VB.NET equivalent to C# var keyword [duplicate]
  24. How to modify existing XML file with XmlDocument and XmlNode in C#
  25. Conditional xml serialization
  26. Create Items from 3 collections using Linq
  27. The data source does not support server-side data paging
  28. Last and LastOrDefault not supported
  29. Parsing SVG “path” elements with C# – are there libraries out there to do this? [closed]
  30. Convert DataTable to Generic List in C#

Leave a Comment