LINQ to XML Tutorial

Part 3 Querying xml document using linq to xml

In Parts 1 and 2 of LINQ to XML tutorial, we discussed creating XML documents using LINQ to XML.

Text version of the video
http://csharp-video-tutorials.blogspot.com/2014/08/part-3-querying-xml-document-using-linq.html

Slides
http://csharp-video-tutorials.blogspot.com/2014/08/part-3-querying-xml-document-using-linq_20.html

LINQ to SQL Tutorial – All Text Articles & Slides
http://csharp-video-tutorials.blogspot.com/2014/08/linq-to-xml-tutorial.html

LINQ to XML Tutorial Playlist

Dot Net, SQL, Angular, JavaScript, jQuery and Bootstrap complete courses
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

In this video, we will discuss how to query xml document using linq to xml. We want to retrieve all the student names who has TotalMarks greater than 800. Students names should be sorted by TotalMarks in descending order.

IEnumerable[string] names = from student in XDocument.Load(@”C:DemoDemoData.xml”).Descendants(“Student”)
where (int)student.Element(“TotalMarks”) ] 800
orderby (int)student.Element(“TotalMarks”) descending
select student.Element(“Name”).Value;

foreach (string name in names)
{
Console.WriteLine(name);
}

Alternate way of writing the above query.
IEnumerable[string] names = from student in XDocument.Load(@”C:DemoDemoData.xml”).Element(“Students”).Elements(“Student”)
where (int)student.Element(“TotalMarks”) ] 800
orderby (int)student.Element(“TotalMarks”) descending
select student.Element(“Name”).Value;