{"id":68,"date":"2009-03-02T00:11:04","date_gmt":"2009-03-01T22:11:04","guid":{"rendered":"http:\/\/www.idwaikat.me\/?p=68"},"modified":"2009-07-14T00:34:42","modified_gmt":"2009-07-13T22:34:42","slug":"linq-to-xml","status":"publish","type":"post","link":"http:\/\/www.idwaikat.me\/?p=68","title":{"rendered":"LINQ To XML"},"content":{"rendered":"

Language Integrated Query<\/strong> (LINQ<\/strong>, pronounced “link<\/em>“) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages.(#<\/a>)<\/p>\n

LINQ to XML is a built-in LINQ data provider that is implemented within the “System.Xml.Linq” namespace in .NET 3.5.<\/p>\n

As Microsoft says, LINQ to XML provides a clean programming model that enables you to read, construct and write XML data. LINQ to XML can be used to perform LINQ queries over XML to retrieve from your local server or from a remote HTTP URL or web-service, or from any in-memory XML content.<\/p>\n

They says that LINQ to XML provides much richer (and easier) querying and data shaping support than the low-level XmlReader\/XmlWriter API in .NET. It also ends up being much more efficient (and uses much less memory) than the DOM API that XmlDocument provides.<\/p>\n

Today I will give a simple example that uses LINQ to XML (VB.NET and C#)<\/p>\n

First we create new ASP.NET 3.5 website using Visual Studio 2008 or any IDE that supports ASP.NET 3.5.<\/p>\n

Then we will create XML file, we assumed that the file contains info about websites, lets say, website name and website link (url), website node contains lang <\/em>attribute, which contains the language of the site, also we can add it as a node if we want, the XML file appears as follows:<\/p>\n

\n

<?<\/span>xml<\/span> <\/span>version<\/span>=<\/span>“1.0<\/span>“ <\/span>encoding<\/span>=<\/span>“utf-8<\/span>“ ?><\/span><\/span><\/p>\n

<<\/span>Websites<\/span>><\/span><\/p>\n

<<\/span>Website<\/span> <\/span>lang<\/span>=<\/span>“en<\/span>“><\/span><\/span><\/p>\n

<<\/span>Name<\/span>><\/span>Ibrahim Dwaikat<\/<\/span>Name<\/span>><\/span><\/span><\/p>\n

<<\/span>Url<\/span>><\/span>http:\/\/www.idwaikat.me<\/<\/span>Url<\/span>><\/span><\/span><\/p>\n

<\/<\/span>Website<\/span>><\/span><\/p>\n

<<\/span>Website<\/span> <\/span>lang<\/span>=<\/span>“en<\/span>“><\/span><\/span><\/p>\n

<<\/span>Name<\/span>><\/span>Yahoo<\/<\/span>Name<\/span>><\/span><\/span><\/p>\n

<<\/span>Url<\/span>><\/span>http:\/\/www.Yahoo.com<\/<\/span>Url<\/span>><\/span><\/span><\/p>\n

<\/<\/span>Website<\/span>><\/span><\/p>\n

<<\/span>Website<\/span> <\/span>lang<\/span>=<\/span>“ar<\/span>“><\/span><\/span><\/p>\n

<<\/span>Name<\/span>><\/span>Balata-Albalad<\/<\/span>Name<\/span>><\/span><\/span><\/p>\n

<<\/span>Url<\/span>><\/span>http:\/\/www.balata-albalad.org<\/<\/span>Url<\/span>><\/span><\/span><\/p>\n

<\/<\/span>Website<\/span>><\/span><\/p>\n

<<\/span>Website<\/span> <\/span>lang<\/span>=<\/span>“ar<\/span>“><\/span><\/span><\/p>\n

<<\/span>Name<\/span>><\/span>Google Jordan<\/<\/span>Name<\/span>><\/span><\/span><\/p>\n

<<\/span>Url<\/span>><\/span>http:\/\/www.google.jo<\/<\/span>Url<\/span>><\/span><\/span><\/p>\n

<\/<\/span>Website<\/span>> <\/span><\/p>\n

<\/<\/span>Websites<\/span>><\/span><\/p>\n<\/blockquote>\n

<\/blockquote>\n

I think the XML clearify itself … no need for more details about its schema.<\/p>\n

Now we save the XML in the root <\/em>folder of our website, named : XMLFile.xml<\/em><\/p>\n

In Page_Load <\/em>we write the following code (VB.NET) – after a moments I will write C# code too, very similar,<\/p>\n

\n

Protected<\/span> Sub<\/span> Page_Load(ByVal<\/span> sender As<\/span> Object<\/span>, ByVal<\/span> e As<\/span> System.EventArgs) Handles<\/span> Me<\/span>.Load<\/span><\/p>\n

Dim<\/span> xmlDoc As<\/span> XDocument = XDocument.Load(Server.MapPath(“XMLFile.xml”<\/span>))<\/span><\/p>\n

<\/span><\/p>\n

Dim<\/span> xmlData = From<\/span> webSite In<\/span> xmlDoc.Descendants(“Website”<\/span>) _<\/span><\/p>\n

Where<\/span> (webSite.Attribute(“lang”<\/span>).Value = “ar”<\/span>) _<\/span><\/p>\n

Select<\/span> Name = webSite.Element(“Name”<\/span>).Value, _<\/span><\/p>\n

Url = webSite.Element(“Url”<\/span>).Value<\/span><\/p>\n

<\/span><\/p>\n

For<\/span> Each<\/span> item In<\/span> xmlData<\/span><\/p>\n

Response.Write(“<a href='”<\/span> & item.Url & “‘>”<\/span> & item.Name & “<\/a> <br \/>”<\/span>)<\/span><\/p>\n

Next<\/span><\/span><\/p>\n

<\/span><\/p>\n

End<\/span> Sub<\/span><\/span><\/p>\n<\/blockquote>\n

\n

Now I will talk about the code line by line.<\/p>\n

\n

Dim<\/span> xmlDoc As<\/span> XDocument = XDocument.Load(Server.MapPath(“XMLFile.xml”<\/span>))<\/span><\/p>\n<\/blockquote>\n

Here I created an instance form XDocument (which belongs to System.XML.Linq namespace), and using the method load, I loaded the previous XML file which named XMLFile.XML<\/em>, here I used Server.MapPath helper method which returns the correct path of the XML file, because sometimes when we didn’t use it, the relative path can be not as we expected.<\/p>\n

\n

The next step is making a query that returns Website Name and URL, the condition is that the language is Arabic (ar).<\/p>\n

\n

Dim<\/span> xmlData = From<\/span> webSite In<\/span> xmlDoc.Descendants(“Website”<\/span>) _<\/span><\/p>\n<\/blockquote>\n

we define a variable (generic collection, typeless here) that will contain the query result (xmlData), and we start the Linq by the keyword: From<\/em>, followed by XElement <\/em>which is here website<\/em>, followed by In xDocument.Descendants<\/em>, which takesSystem.XML.Linq.XName, and returns a filtered collection of the descendant elements for this document or element in document order, only elements that have a matching System.XML.Linq.XName are included in the returned collection.<\/p>\n

\n

Where<\/span> (webSite.Attribute(“lang”<\/span>).Value = “ar”<\/span>) _<\/span><\/p>\n<\/blockquote>\n

Where represents the condition, linq condition supports many comparisons like =, <>, is, IsNot … etc.
\n<\/span><\/p>\n

\n

\n

Select<\/span> Name = webSite.Element(“Name”<\/span>).Value, _<\/span><\/p>\n

Url = webSite.Element(“Url”<\/span>).Value<\/span><\/p>\n<\/blockquote>\n

\n

Here we specify what the query will return, we will return the Name, and the URL, if you know the basics of DOM API in .NET its easier to understand the meaning of this.<\/span><\/p>\n

\n

\n

For<\/span> Each<\/span> item In<\/span> xmlData<\/span><\/p>\n<\/blockquote>\n

now we make a For Each loop to get the records in the xmlData collection.<\/span><\/p>\n

\n

Response.Write(“<a href='”<\/span> & item.Url & “‘>”<\/span> & item.Name & “<\/a> <br \/>”<\/span>)<\/span><\/p>\n

\n

Now we use Response.Write to write the results in the page, as a conventional href : <a href=’URL’>TEXT<\/a> and we put new line..<\/span><\/p>\n

Finally we close the for each loop using Next, and when we run the application we will get:<\/span><\/p>\n

Balata-Albalad<\/a>
\nGoogle Jordan<\/a><\/p>\n

\n

Here is the same code in C#<\/p>\n

\n

\n

\n

protected<\/span> void<\/span> Page_Load(object<\/span> sender, EventArgs<\/span> e)<\/span><\/p>\n

<\/span>{<\/span><\/p>\n

<\/span><\/p>\n

<\/span>XDocument<\/span> xmlDoc = XDocument<\/span>.Load(Server.MapPath(“XMLFile.xml”<\/span>));<\/span><\/p>\n

<\/span><\/p>\n

<\/span>var<\/span> xmlData = from<\/span> webSite in<\/span> xmlDoc.Descendants(“Website”<\/span>) <\/span><\/p>\n

<\/span>where<\/span> (webSite.Attribute(“lang”<\/span>).Value == “ar”<\/span>) <\/span><\/p>\n

<\/span>select<\/span> new<\/span> <\/span><\/p>\n

<\/span>{ <\/span><\/p>\n

<\/span>Name = webSite.Element(“Name”<\/span>).Value, <\/span><\/p>\n

<\/span>Url = webSite.Element(“Url”<\/span>).Value <\/span><\/p>\n

<\/span>} ;<\/span><\/p>\n

<\/span><\/p>\n

<\/span>foreach<\/span> (var<\/span> item in<\/span> xmlData)<\/span><\/p>\n

<\/span>{<\/span><\/p>\n

<\/span>Response.Write(“<a href='”<\/span> <\/span>+ item.Url + “‘>”<\/span> + item.Name + “<\/a> <br \/>”<\/span>);<\/span><\/p>\n

<\/span>}<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/span><\/p>\n

<\/span>}<\/span><\/p>\n<\/blockquote>\n

\n

\n

\n

\n

That was a very simple example, for more information you can visit the following links or you can send me a comment about your question..<\/span><\/p>\n