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.
<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.
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 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).
(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.
03/06/2008 - 20:02
Really nice info. I've got to check deeply this whole new addition named LINQ. It seems truly powerful.
Thanks for the post.
05/27/2008 - 00:02
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
08/06/2008 - 03:18
Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Initial Catalog=mySQLServerDBName;" & _
"User ID=myUsername;" & _
"Password=myPassword"
08/14/2008 - 08:42
From Argentine.. Thanks! great article!
10/15/2008 - 19:04
Really good tutorial. It saved lot of my time
10/25/2008 - 08:31
Truely simple and very helpful article.
It helped me to start up with xlinq very quickly.
Thanks for this. :)..
06/10/2009 - 11:00
Very well done, I appreciate the help.
02/02/2010 - 23:32
This is the shortest and well explained first-step tutorial for LINQ I have ever seen.
Thank you!