LINQ To XML- Part III

最新推荐文章于 2024-04-26 15:31:01 发布

choudanermao

最新推荐文章于 2024-04-26 15:31:01 发布

阅读量337

点赞数

分类专栏： LINQ 文章标签： linq xml structure vb.net namespaces tutorials

LINQ 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

Some Common Operations using LINQ To XML - Part III

In this article, we will explore some common ‘How Do I’ kind of examples using LINQ to XML. This article is the final part of our 3-part LINQ to XML series. I assume you are familiar with LINQ. If not, you can start off with LINQ to XML by checking some tutorials at Getting Ready for .NET 3.5 and LINQ – Exploring C# 3.0 – Part I and over here for VB.NET .

The first two parts of the LINQ to XML Series can be found over here:

Some Common Operations using LINQ To XML - Part I

Some Common Operations using LINQ To XML - Part II

We will be using a sample file called ‘Employees.xml’ for our samples. The mark up will be as follows:

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

<Street>7A Cox Street</Street>

<City>Acampo</City>

</Address>

</Employee>

<Sex>Female</Sex>

</Address>

</Employee>

<Sex>Female</Sex>

<Street>23 Boxen Street</Street>

<City>Milford</City>

</Address>

</Employee>

<Name>Chris</Name>

<Street>124 Kutbay</Street>

<City>Montara</City>

</Address>

</Employee>

</Employees>

The application is a console application targeting .NET 3.5 Framework. I have used query expressions instead of Lambda expression in these samples. It is just a matter of preference and you are free to use any of these. Use the following namespaces while testing the samples: System.IO; System.Collections.Generic; System.Linq; System.Xml.Linq; System.IO;

17. Add a new Element at runtime using LINQ to XML

You can add a new Element to an XML document at runtime by using the Add() method of XElement. The new Element gets added as the last element of the XML document.

XElement xEle = XElement.Load("..//..//Employees.xml");

xEle.Add(new XElement("Employee",

new XElement("EmpId", 5),

new XElement("Name", "George")));

Console.Write(xEle);

18. Add a new Element as the First Child using LINQ to XML

In the previous example, by default the new Element gets added to the end of the XML document. If you want to add the Element as the First Child, use the ‘AddFirst()’ method

XElement xEle = XElement.Load("..//..//Employees.xml");

xEle.AddFirst(new XElement("Employee",

new XElement("EmpId", 5),

new XElement("Name", "George")));

Console.Write(xEle);

19. Add an attribute to an Element using LINQ to XML

To add an attribute to an Element, use the following code:

XElement xEle = XElement.Load("..//..//Employees.xml");

xEle.Add(new XElement("Employee",

new XElement("EmpId", 5),

new XElement("Phone", "423-555-4224", new XAttribute("Type", "Home"))));

Console.Write(xEle);

20. Replace Contents of an Element/Elements using LINQ to XML

Let us say that in the XML file, you want to change the Country from “USA” to “United States of America” for all the Elements. Here’s how to do so:

XElement xEle = XElement.Load("..//..//Employees.xml");

var countries = xEle.Elements("Employee").Elements("Address").Elements("Country").ToList();

foreach (XElement cEle in countries)

cEle.ReplaceNodes("United States Of America");

Console.Write(xEle);

VB.NET

Dim xEle As XElement = XElement.Load("../../Employees.xml")

Dim countries = xEle.Elements("Employee").Elements("Address").Elements("Country").ToList()

For Each cEle As XElement In countries

cEle.ReplaceNodes("United States Of America")

Next cEle

Console.Write(xEle)

21. Remove an attribute from all the Elements using LINQ to XML

Let us say if you want to remove the Type attribute ( <Phone Type=”Home”>) attribute for all the elements, then here’s how to do it.

XElement xEle = XElement.Load("..//..//Employees.xml");

var phone = xEle.Elements("Employee").Elements("Phone").ToList();

foreach (XElement pEle in phone)

pEle.RemoveAttributes();

Console.Write(xEle);

To remove attribute of one Element based on a condition, traverse to that Element and SetAttributeValue("Type", null); You can also use SetAttributeValue(XName,object) to update an attribute value.

22. Delete an Element based on a condition using LINQ to XML

If you want to delete an entire element based on a condition, here’s how to do it. We are deleting the entire Address Element

XElement xEle = XElement.Load("..//..//Employees.xml");

var addr = xEle.Elements("Employee").ToList();

foreach (XElement addEle in addr)

addEle.SetElementValue("Address", null);

Console.Write(xEle);

SetElementValue() can also be used to Update the content of an Element.

23. Remove ‘n’ number of Elements using LINQ to XML

If you have a requirement where you have to remove ‘n’ number of Elements; For E.g. To remove the last 2 Elements, then here’s how to do it

XElement xEle = XElement.Load("..//..//Employees.xml");

var emps = xEle.Descendants("Employee");

emps.Reverse().Take(2).Remove();

Console.Write(xEle);

24. Save/Persists Changes to the XML using LINQ to XML

All the manipulations we have done so far were in the memory and were not persisted in the XML file. If you have been wondering how to persist changes to the XML, once it is modified, then here’s how to do so. It’s quite simple. You just need to call the Save() method. It’s also worth observing that the structure of the code shown below is similar to the structure of the end result (XML document). That’s one of the benefits of LINQ to XML, that it makes life easier for developers by making it so easy to create and structure XML documents.

XElement xEle = XElement.Load("..//..//Employees.xml");

xEle.Add(new XElement("Employee",

new XElement("EmpId", 5),

new XElement("Name", "George"),

new XElement("Sex", "Male"),

new XElement("Phone", "423-555-4224", new XAttribute("Type", "Home")),

new XElement("Phone", "424-555-0545", new XAttribute("Type", "Work")),

new XElement("Address",

new XElement("Street", "Fred Park, East Bay"),

new XElement("City", "Acampo"),

new XElement("State", "CA"),

new XElement("Zip", "95220"),

new XElement("Country", "USA"))));

xEle.Save("..//..//Employees.xml");

Console.WriteLine(xEle);

Console.ReadLine();

Well with that, we conclude the series of some 'more' commonly used 'How Do I' operations while using LINQ to XML. Through this series, we have only attempted to scratch the surface of what can be done using LINQ to XML. LINQ to XML is an amazing API and in the forthcoming articles, we will explore some advanced usages. The entire source code of the article in C# and VB.NET can be downloaded over here. I hope you liked the article and I thank you for viewing it.