C# LINQ to XML: Parsing and Manipulating XML Documents

Apr 4, 2023 | .NET, C#

In this article, we will dive deep into the world of XML processing using C# LINQ to XML. We will explore how to parse, create, and manipulate XML documents effectively with LINQ, making your XML handling tasks a breeze. The topics covered in this article include parsing XML documents, querying XML data, modifying XML elements and attributes, and creating XML documents from scratch. So, let’s get started!

Parsing XML Documents with LINQ

In this section, we will learn how to parse XML documents using LINQ to XML, and explore various techniques to read and extract information from XML data. The following topics will be covered in this section:

  • Loading XML documents
  • Accessing elements and attributes
  • Navigating XML trees

Loading XML Documents

There are several ways to load XML data into a LINQ to XML object. You can load XML from a file, a string, or an XmlReader object. Here are some examples of how to load XML data using different sources:

// Load XML from a file
XDocument xmlDoc1 = XDocument.Load("path/to/your/xmlfile.xml");

// Load XML from a string
string xmlData = "<root><element>value</element></root>";
XDocument xmlDoc2 = XDocument.Parse(xmlData);

// Load XML from an XmlReader
using (XmlReader reader = XmlReader.Create("path/to/your/xmlfile.xml"))
{
    XDocument xmlDoc3 = XDocument.Load(reader);
}

Accessing Elements and Attributes

Once you have loaded the XML data, you can begin to access its elements and attributes using LINQ queries. Here’s an example of how to access elements and attributes in an XML document:

string xmlData = @"
<books>
  <book id='1'>
    <title>Book One</title>
    <author>Author One</author>
  </book>
  <book id='2'>
    <title>Book Two</title>
    <author>Author Two</author>
  </book>
</books>";

XDocument xmlDoc = XDocument.Parse(xmlData);

// Access the 'books' element
XElement booksElement = xmlDoc.Element("books");

// Access the 'book' elements
IEnumerable<XElement> bookElements = booksElement.Elements("book");

// Access the 'id' attribute of the first 'book' element
XAttribute idAttribute = bookElements.First().Attribute("id");

Navigating XML Trees

LINQ to XML provides various methods to navigate and traverse XML trees, such as Elements, Descendants, Ancestors, and Parent. Here are some examples of navigating XML trees using these methods:

string xmlData = @"
<books>
  <book id='1'>
    <title>Book One</title>
    <author>Author One</author>
  </book>
  <book id='2'>
    <title>Book Two</title>
    <author>Author Two</author>
  </book>
</books>";

XDocument xmlDoc = XDocument.Parse(xmlData);

// Get all 'title' elements within the 'books' element
IEnumerable<XElement> titleElements = xmlDoc.Element("books").Elements("book").Elements("title");

// Get all 'author' elements in the XML document
IEnumerable<XElement> authorElements = xmlDoc.Descendants("author");

// Get the parent element of the first 'author' element
XElement parentElement = authorElements.First().Parent;

// Get all ancestor elements of the first 'title' element
IEnumerable<XElement> ancestorElements = titleElements.First().Ancestors();

Querying XML Data with LINQ

In this section, we will explore how to query XML data using LINQ queries, making it easy to filter, sort, and project XML data. We will cover the following topics:

  • Filtering elements and attributes
  • Sorting elements and attributes
  • Projecting XML data into objects

Filtering Elements and Attributes

You can use LINQ queries to filter XML elements and attributes based on specific conditions. Here’s an example of filtering XML data using a LINQ query:

string xmlData = @"
<books>
  <book id='1'>
    <title>Book One</title>
    <author>Author One</author>
    <price>10</price>
  </book>
  <book id='2'>
    <title>Book Two</title>
    <author>Author Two</author>
    <price>20</price>
  </book>
</books>";

XDocument xmlDoc = XDocument.Parse(xmlData);

// Filter books with a price less than 15
IEnumerable<XElement> cheapBooks = xmlDoc.Descendants("book")
    .Where(book => (int)book.Element("price") < 15);

Sorting Elements and Attributes

LINQ queries can also be used to sort XML elements and attributes based on specific criteria. Here’s an example of sorting XML data using a LINQ query:

string xmlData = @"
<books>
  <book id='1'>
    <title>Book One</title>
    <author>Author One</author>
    <price>10</price>
  </book>
  <book id='2'>
    <title>Book Two</title>
    <author>Author Two</author>
    <price>20</price>
  </book>
</books>";

XDocument xmlDoc = XDocument.Parse(xmlData);

// Sort books by price in ascending order
IEnumerable<XElement> sortedBooks = xmlDoc.Descendants("book")
    .OrderBy(book => (int)book.Element("price"));

Projecting XML Data into Objects

LINQ queries can project XML data into objects, making it easier to work with the data in your C# code. Here’s an example of projecting XML data into objects using a LINQ query:

string xmlData = @"
<books>
  <book id='1'>
    <title>Book One</title>
    <author>Author One</author>
    <price>10</price>
  </book>
  <book id='2'>
    <title>Book Two</title>
    <author>Author Two</author>
    <price>20</price>
  </book>
</books>";

XDocument xmlDoc = XDocument.Parse(xmlData);

// Project XML data into Book objects
var bookObjects = xmlDoc.Descendants("book")
    .Select(book => new
    {
        Id = (int)book.Attribute("id"),
        Title = (string)book.Element("title"),
        Author = (string)book.Element("author"),
        Price = (int)book.Element("price")
    });

Modifying XML Elements and Attributes

In this section, we will learn how to modify XML elements and attributes using LINQ to XML. We will cover the following topics:

  • Adding elements and attributes
  • Updating elements and attributes
  • Removing elements and attributes

Adding Elements and Attributes

You can add new elements and attributes to an XML document using the Add method. Here’s an example of adding elements and attributes to an XML document:

string xmlData = @"
<books>
  <book id='1'>
    <title>Book One</title>
    <author>Author One</author>
    <price>10</price>
  </book>
  <book id='2'>
    <title>Book Two</title>
    <author>Author Two</author>
    <price>20</price>
  </book>
</books>";

XDocument xmlDoc = XDocument.Parse(xmlData);

// Add a new 'book' element with child elements and attributes
xmlDoc.Element("books").Add(new XElement("book",
    new XAttribute("id", 3),
    new XElement("title", "Book Three"),
    new XElement("author", "Author Three"),
    new XElement("price", 30)
));

// Add a new 'publisher' attribute to the first 'book' element
xmlDoc.Descendants("book").First().Add(new XAttribute("publisher", "PublisherOne"));

// Add a new 'publisher' element to the first 'book' element
xmlDoc.Descendants("book").First().Add(new XElement("publisher", "Publisher One"));

Updating Elements and Attributes

You can update the values of elements and attributes in an XML document using simple assignment statements. Here’s an example of updating elements and attributes in an XML document:

string xmlData = @"
<books>
  <book id='1'>
    <title>Book One</title>
    <author>Author One</author>
    <price>10</price>
  </book>
  <book id='2'>
    <title>Book Two</title>
    <author>Author Two</author>
    <price>20</price>
  </book>
</books>";

XDocument xmlDoc = XDocument.Parse(xmlData);

// Update the 'title' element of the first 'book' element
xmlDoc.Descendants("book").First().Element("title").Value = "Updated Book One";

// Update the 'id' attribute of the first 'book' element
xmlDoc.Descendants("book").First().Attribute("id").Value = "100";

Removing Elements and Attributes

You can remove elements and attributes from an XML document using the Remove method. Here’s an example of removing elements and attributes from an XML document:

string xmlData = @"
<books>
  <book id='1'>
    <title>Book One</title>
    <author>Author One</author>
    <price>10</price>
  </book>
  <book id='2'>
    <title>Book Two</title>
    <author>Author Two</author>
    <price>20</price>
  </book>
</books>";

XDocument xmlDoc = XDocument.Parse(xmlData);

// Remove the 'author' element from the first 'book' element
xmlDoc.Descendants("book").First().Element("author").Remove();

// Remove the 'id' attribute from the first 'book' element
xmlDoc.Descendants("book").First().Attribute("id").Remove();

Creating XML Documents from Scratch

In this section, we will learn how to create XML documents from scratch using LINQ to XML. You can create an XML document by creating XDocument, XElement, and XAttribute objects and adding them together. Here’s an example of creating an XML document from scratch:

XDocument newXmlDoc = new XDocument(
    new XElement("books",
        new XElement("book",
            new XAttribute("id", 1),
            new XElement("title", "Book One"),
            new XElement("author", "Author One"),
            new XElement("price", 10)
        ),
        new XElement("book",
            new XAttribute("id", 2),
            new XElement("title", "Book Two"),
            new XElement("author", "Author Two"),
            new XElement("price", 20)
        )
    )
);

// Save the XML document to a file
newXmlDoc.Save("path/to/your/newxmlfile.xml");

In summary, we have explored various techniques to parse, create, and manipulate XML documents using C# LINQ to XML. By understanding and applying these concepts, you can easily handle complex XML tasks in your C# applications. Don’t forget to experiment with these techniques to gain a deeper understanding of LINQ to XML capabilities and improve your XML processing skills. Happy coding!

You May Also Like

Sign up For Our Newsletter

Weekly .NET Capsules: Short reads for busy devs.

  • NLatest .NET tips and tricks
  • NQuick 5-minute reads
  • NPractical code snippets
.