Click here to Skip to main content
Click here to Skip to main content

Reading XML using LINQ

By , 5 Feb 2013
 

Introduction

We have different ways of reading XML, i.e., legacy approach of using a DOM object to read XML or other approaches.

Background

Let us assume that we have a custom created XML that has a series of tags and we want to go through the XML and get the value for further processing.

Using the code

The below lines of code explains the usage of LINQ and also the advantages of using LINQ compared to a legacy approach. The code is shared below (the legacy code has been commented out). The method reads the XML data/file using LINQ. Below is the code snippet that I am sharing. As I said this has two versions: LINQ and Latest. 

The result will be stored in the Anonymous Class FileToWatch. Then this will be executed as a set of objects for looping through the items that we have read from the XML. 

//Note: Below one is using the LINQ to XML
var path = Assembly.GetExecutingAssembly().Location;
path = path.Substring(0, path.LastIndexOf('\\')) + "\\" + "LocationsToWatch.xml";
XDocument xmlDoc = XDocument.Load(path);
files = (from x in xmlDoc.Root.Elements("location")
select
new FileToWatch
{
    Server = (string)x.Element("server").Value ?? string.Empty,
    Drive = (string)x.Element("drive").Value ?? string.Empty,
    Folder = (string)x.Element("folder").Value ?? string.Empty,
    FileName = (string)x.Element("filename").Value ?? string.Empty,
    SendMail = (string)x.Element("sendmail").Value ?? string.Empty,
    FullPath = x.Element("folder").Value + x.Element("filename").Value
}).ToList();

Legacy approach, using the DOM object.

//Note: below code is legacy method of writing code to read XML in to Object
var xmlDoc = new XmlDocument();
xmlDoc.Load("LocationsToWatch.xml");
var itemNodes = xmlDoc.SelectNodes("locations");
foreach (XmlNode node in itemNodes)
{
    var location = node.SelectNodes("location");
    foreach (XmlNode loc in location)
    {
        var server = loc.SelectSingleNode("server").InnerText;
        var drive = loc.SelectSingleNode("drive").InnerText;
        var folder = loc.SelectSingleNode("folder").InnerText;
        var filename = loc.SelectSingleNode("filename").InnerText;
    } 
}

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

KameshKannan
Software Developer (Senior)
India India
Member
No Biography provided

Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
Hint: For improved responsiveness ensure Javascript is enabled and choose 'Normal' from the Layout dropdown and hit 'Update'.
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page   
GeneralSomething like this may work too using NavigatormemberAshish Basran17 Jan '13 - 20:16 
GeneralRe: Something like this may work too using NavigatormemberKameshKannan29 Jan '13 - 1:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Permalink | Advertise | Privacy | Mobile
Web04 | 2.6.130523.1 | Last Updated 5 Feb 2013
Article Copyright 2013 by KameshKannan
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid