Every programmer has had to parse an XML file. If you're trying to tell me you haven't, then you're lying and you just don't remember it. You probably shouldn't even call yourself a programmer.
If you don't remember the history of reading an XML document, here's the Cliffs Notes version. In the beginning there was line-by-line parsing. It was hard, error prone, and usually sucked. After a little while of this, light started shining onto our dark corner of the world. .NET introduced the XmlTextReader class, and things were good - for a while. And then, as if Microsoft heard the prayers of a million programmers, LINQ was integrated into .NET 3.5 and again, things are good.
It's the anonymous types and methods introduced into .NET 3.5 that makes LINQ possible. If you haven't messed with anonymous types yet, I would highly recommend it. MSDN has some good documentation.
Let's start out this tutorial by looking at some XML code. I've created a small document that outlines some of the tutorials we've created.
<?xml version="1.0" encoding="utf-8" ?>
<Tutorials>
<Tutorial>
<Author>The Reddest</Author>
<Title>
Creating an XP Style WPF Button with Silverlight
</Title>
<Date>2/20/2008</Date>
</Tutorial>
<Tutorial>
<Author>The Fattest</Author>
<Title>
Flex And Yahoo Maps
</Title>
<Date>2/12/2007</Date>
</Tutorial>
<Tutorial>
<Author>The Tallest</Author>
<Title>
WPF Tutorial - Creating A Custom Panel Control
</Title>
<Date>2/18/2008</Date>
</Tutorial>
</Tutorials>
First, we're going to use some simple LINQ syntax to create some anonymous objects with the properties, Author, Title, and Date.
XDocument xmlDoc = XDocument.Load("TestFile.xml");
var tutorials = from tutorial in xmlDoc.Descendants("Tutorial")
select new
{
Author = tutorial.Element("Author").Value,
Title = tutorial.Element("Title").Value,
Date = tutorial.Element("Date").Value,
};
The result of this code will be an IEnumerable collection filled with anonymous objects. What's nice about Visual Studio is that you'll even get dot completion for anonymous types.
Anonymous objects are well and good, but usually I want something a
little better defined to pass around my application. Let's look at how
to create a List of Tutorial objects.
public class Tutorial
{
public string Author { get; set; }
public string Title { get; set; }
public DateTime Date { get; set; }
}
...
List<Tutorial> tutorials =
(from tutorial in xmlDoc.Descendants("Tutorial")
select new Tutorial
{
Author = tutorial.Element("Author").Value,
Title = tutorial.Element("Title").Value,
Date = DateTime.Parse(tutorial.Element("Date").Value),
}).ToList<Tutorial>();
At this point, you're probably floored at how quickly I was just able to
parse that XML document into my collection - I know I am. Let's look at
one simple piece I haven't mentioned yet, the where clause. Just like
SQL, LINQ has the ability to filter results using the where keyword.
Let's filter down my collection to only tutorials written by The Tallest
(his are always the best anyway).
List<Tutorial> tutorials =
(from tutorial in xmlDoc.Descendants("Tutorial")
where tutorial.Element("Author").Value == "The Tallest"
select new Tutorial
{
Author = tutorial.Element("Author").Value,
Title = tutorial.Element("Title").Value,
Date = DateTime.Parse(tutorial.Element("Date").Value),
}).ToList<Tutorial>();
Now my list of tutorials will only contain those written by The Tallest.
I think that's enough for the first part of this tutorial. LINQ is incredibly powerful and deserves several tutorials to cover even a small portion of it. LINQ can be used for databases just as easily as it was used here on XML. You can even write an entire ray tracer, if you're deranged enough.
Really nice info. I've got to check deeply this whole new addition named LINQ. It seems truly powerful.
Thanks for the post.
Its really cool and very easy to understand tutorial. So simple that a novice can start up just going through ur tutorial.
hope for few more in future
take care
Data Source=xxx.xxx.xxx.xxx,1433;" & _ "Initial Catalog=mySQLServerDBName;" & _ "User ID=myUsername;" & _ "Password=myPassword"
From Argentine.. Thanks! great article!
Really good tutorial. It saved lot of my time
Truely simple and very helpful article. It helped me to start up with xlinq very quickly. Thanks for this. :)..
Very well done, I appreciate the help.
This is the shortest and well explained first-step tutorial for LINQ I have ever seen.
Thank you!
Thanks for the good article. I like LINQ very much and am trying to use it whenever possible. My one concern is the performance. Do you know how LINQ performs compared with the traditional approach? For example, your example xml could be loaded through xml serialization. How does it perform compared with the LINQ?
Thanks for wonderful tutorial. Good job
This example is AMAZING! Exactly what I needed. Thank you so much :)
very helpful...
I like it. You saved me a lot of time. Thanks!
This is great but what do you do when you don't know the structure of the xml when you write the code? Linq doesn't work in this case. Back to parsing it line by line, character by character.
hallo all could any body help me to read this xml with using VS08 I need to creat a sample code :
thats it . I waiting for ur helpniss, thanxxx
gar mereche.ei code ekhon k ghatbe..!!
This is very helpful for me and you saved me a lot of time. Thanks for wonderful tutorial.
Good one
what if we want to retrieve attributes of the tags???
Use the Attribute method.
http://msdn.microsoft.com/en-us/library/system.xml.linq.xelement.attribute
I used this code, does not work at all, I dont know how did you guys have this to work?
Thanks for the turorial. really helped out. i need some help.. how can you retrive the information for multiple date.. for example The Reddest Creating an XP Style WPF Button with Silverlight 2007 12 2010 1
good read.
thx
I am starting to love this site.
I am new to C#, WPF, LINQ....programming in general.
Worse, I have been learning on my own. I have seen so many examples that don't work, too trivial, or far too complex for me to grasp at this point.
Thank you very much!
Nothing like a good basic tutorial to make things clear... Thank you!