Part 7 - Transform one XML format to another XML format using linq to xml

Suggested Videos
Part 4 - Modifying xml document using linq to xml
Part 5 - Transforming XML to CSV using LINQ to XML
Part 6 - Transforming XML to HTML table using LINQ to XML



In Part 5, we discussed, tranforming XML to CSV
In Part 6, we discussed, tranforming XML to HTML

In this video, we will discuss transforming one XML format to another XML format



We want to tranform the following XML format to a different format

<?xml version="1.0" encoding="utf-8"?>

<Students>

  <Student Country="USA">

    <Name>Mark</Name>

    <Gender>Male</Gender>

    <TotalMarks>800</TotalMarks>

  </Student>

  <Student Country="USA">

    <Name>Rosy</Name>

    <Gender>Female</Gender>

    <TotalMarks>900</TotalMarks>

  </Student>

  <Student Country="India">

    <Name>Pam</Name>

    <Gender>Female</Gender>

    <TotalMarks>850</TotalMarks>

  </Student>

  <Student Country="India">

    <Name>John</Name>

    <Gender>Male</Gender>

    <TotalMarks>950</TotalMarks>

  </Student>

</Students>

The tranformed XML format should be as shown below.

<?xml version="1.0" encoding="utf-8"?>

<Students>

  <USA>

    <Student>

      <Name>Mark</Name>

      <Gender>Male</Gender>

      <TotalMarks>800</TotalMarks>

    </Student>

    <Student>

      <Name>Rosy</Name>

      <Gender>Female</Gender>

      <TotalMarks>900</TotalMarks>

    </Student>

  </USA>

  <India>

    <Student>

      <Name>Pam</Name>

      <Gender>Female</Gender>

      <TotalMarks>850</TotalMarks>

    </Student>

    <Student>

      <Name>John</Name>

      <Gender>Male</Gender>

      <TotalMarks>950</TotalMarks>

    </Student>

  </India>

</Students>

Code to transform XML to a different format

XDocument xmlDocument = XDocument.Load(@"C:\Demo\Demo\Data.xml");

XDocument result = new XDocument(

        new XElement("Students",

            new XElement("USA",

                from s in xmlDocument.Descendants("Student")

                where s.Attribute("Country").Value == "USA"

                select new XElement("Student",

                    new XElement("Name", s.Element("Name").Value),

                    new XElement("Gender", s.Element("Gender").Value),

                    new XElement("TotalMarks", s.Element("TotalMarks").Value))),

            new XElement("India",

                from s in xmlDocument.Descendants("Student")

                where s.Attribute("Country").Value == "India"

                select new XElement("Student",

                    new XElement("Name", s.Element("Name").Value),

                    new XElement("Gender", s.Element("Gender").Value),

                    new XElement("TotalMarks", s.Element("TotalMarks").Value)))));

result.Save(@"C:\Demo\Demo\Result.xml");