How to use LINQ query in XML data souce

Here I share the usage of LINQ in xml.Normally xml has been to store the data like a database. By using LINQ query we can easily search or retrieve the data from XML.

In a previous article I explained, How LINQ query used in List Collection. For your reference I have mention URL as below.

http://www.dotnetcode.in/2013/02/how-to-use-linq-in-list-collection.html

Now here I explain how to use LINQ query on XML

Take xml file like as structure as below………

Stud.xml

<students> <student Group="A"> <name>raju</name> <class>10th</class> </student> <student Group="A"> <name>raju</name> <class>10th</class> </student> <student Group="B"> <name>raju</name> <class>5th</class> </student> <student Group="C"> <name>rahman</name> <class>5th</class> </student> <student Group="A"> <name>sekhar</name> <class>7th</class> </student> <student Group="B"> <name>rahuk</name> <class>8th</class> </student> </s</students>

First we need to add namespace to use XML class in LINQ.

using System.Xml.Linq;

then we need to use XDOCUMENT class to load XML file to apply LINQ query.

In First query I am going to search the name contains “Raju” bu using LINQ query

XDocument xd=XDocument.Load(Server .MapPath ("stud.xml"));         var xmldata = from xm in xd.Descendants("student") where xm.Element ("name").Value .Equals ("raju")                       select new                       {                           name = xm.Element("name").Value,                           studclass = xm.Element("class").Value                       };         foreach (var post in xmldata)         {             Response.Write(post.name);             Response.Write(post.studclass);         }

Output:

1raju10th raju10th raju5th

In a second process now we can filter by group…

var xmldata1 = from xm1 in xd.Descendants("student")                        where xm1.Attribute("Group").Value.Equals("A")                        select new                        {                            name = xm1.Element("name").Value,                            studclass = xm1.Element("class").Value                        };         foreach (var post1 in xmldata1)         {             Response.Write(post1.name);             Response.Write(post1.studclass + "</br>" );         }

Output:

raju10th raju10th sekhar7th

I hope now you have got an idea to LINQ in xml