{"id":4453,"date":"2008-04-25T14:19:00","date_gmt":"2008-04-25T14:19:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/vbteam\/2008\/04\/25\/vb-xml-cookbook-recipe-3-identity-transforms-doug-rothaus\/"},"modified":"2024-07-05T14:25:53","modified_gmt":"2024-07-05T21:25:53","slug":"vb-xml-cookbook-recipe-3-identity-transforms-doug-rothaus","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/vbteam\/vb-xml-cookbook-recipe-3-identity-transforms-doug-rothaus\/","title":{"rendered":"VB XML Cookbook, Recipe 3: Identity Transforms (Doug Rothaus)"},"content":{"rendered":"

An identity transform in XSLT does just what the name implies: replace the identity of an element or attribute with a new identity. Identity transforms are especially critical when dealing with XML markup that is less rigid in its structure. Consider a documentation structure for news articles. Whenever a title is referred to within an article, it is highlighted with italics. However, the XML schema for the article does not specify italics, it specifies that the term is some type of title so that different transforms can handle the term in their own fashion. When you transform XML such as this into a readable format, such as HTML, you need to preserve the structure of the text around the highlighted term so that the original intent remains intact. That is…<\/font><\/p>\n

<Paragraph sequenceID=”1”><\/span>This week a remastered version of the movie <title type=”movie”>Raider’s of the Lost Ark<\/title> was released.<\/Paragraph><\/p>\n

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

becomes…<\/font><\/p>\n

<p>This week a remastered version of the movie <i>Raider’s of the Lost Ark<\/i> was released.<\/p><\/p>\n

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

In a browser you see…<\/font><\/p>\n

This week a remastered version of the movie Raider’s of the Lost Ark<\/i> was released.<\/span><\/p>\n

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

(Note: I have no idea if they are really releasing a remastered version of Raider’s of the Lost Ark, I just typed the first thing that popped into my head).<\/p>\n

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

You can perform an identity transform using Visual Basic and XML Literals by combining <\/font>XML Axis properties<\/font><\/a> and the <\/font>ReplaceWith<\/font><\/a> method for LINQ to XML objects.<\/font><\/p>\n

Let’s look at a more complete example. In the AdventureWorks contacts source document that we used in previous recipes (you can download the XML document and related schemas from the <\/font>Recipe 1<\/font><\/a> post), there is an <\/font><AdditionalContactInfo><\/span><\/span> element that contains information about the contact such as phone numbers, shipping and billing addresses, and so on. To keep things simple, we’ll just look at the <\/font><eMail><\/span> element. The <\/font><eMail><\/span> element can show up in a number of places in the contents of the <\/font><AdditionalContactInfo><\/span> element. As a result, you can use the <\/font>XML Descendant axis property<\/font><\/a> discussed in <\/font>Recipe 2<\/font><\/a> to retrieve all of the references to <\/font><eMail><\/span> elements. You can then iterate through the query results and call the ReplaceWith method for each <\/font><eMail><\/span> element and replace it with a new identity. For example:<\/font><\/p>\n

  <\/span>Dim<\/span> emails = (From<\/span> email In<\/span> _<\/p>\n

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

    <\/span>xmlDoc.<<\/span>Contacts><\/span>.<<\/span>Contact><\/span>.<<\/span>aci:AdditionalContactInfo><\/span>…<<\/span>act:eMail><\/span>).ToList()<\/p>\n

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

<\/p>\n

 <\/p>\n

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

  <\/span>For<\/span> Each<\/span> email In<\/span> emails<\/p>\n

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

    <\/span>TransformEmail(email)<\/p>\n

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

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

In this example, the output is HTML and the <\/font><eMail><\/span> element is replaced with an anchor element that specifies a mailto: link to the e-mail address. The previous code snippet passes the <\/font><eMail><\/span> XElement<\/b> object to the function TransformEmail<\/b>, which does the actual replacing.<\/font><\/p>\n

  <\/span>Private<\/span> Sub<\/span> TransformEmail(ByVal<\/span> email As<\/span> XElement)<\/p>\n

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

    <\/span>Dim<\/span> emailHtml = <<\/span>div<\/span> class<\/span>=<\/span>“<\/span>Email<\/span>“<\/span>><\/p>\n

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

                      <\/span><<\/span>a<\/span> href<\/span>=<\/span><%=<\/span> “mailto:”<\/span> & email.<<\/span>act:eMailAddress><\/span>.Value %><\/span>><\/p>\n

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

                        <\/span><%=<\/span> email.<<\/span>act:eMailAddress><\/span>.Value %><\/p>\n

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

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

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

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

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

<\/p>\n

 <\/p>\n

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

    <\/span>email.ReplaceWith(emailHtml)<\/p>\n

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

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

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

<\/font> <\/p>\n

A simple class that creates the HTML document using these samples is shown here.<\/font><\/p>\n

Imports<\/span> <<\/span>xmlns<\/span>=<\/span>“<\/span>http:\/\/SampleSchema\/AWContacts<\/span>“<\/span>><\/p>\n

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

Imports<\/span> <<\/span>xmlns:aci<\/span>=<\/span>“<\/span>http:\/\/schemas.microsoft.com\/sqlserver\/2004\/07\/adventure-works\/ContactInfo<\/span>“<\/span>><\/p>\n

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

Imports<\/span> <<\/span>xmlns:act<\/span>=<\/span>“<\/span>http:\/\/schemas.microsoft.com\/sqlserver\/2004\/07\/adventure-works\/ContactTypes<\/span>“<\/span>><\/p>\n

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

<\/p>\n

 <\/p>\n

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

Public Class <\/span>Recipe3<\/p>\n

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

<\/p>\n

 <\/p>\n

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

  <\/span>Public<\/span> Function<\/span> GetContactsHtml(ByVal<\/span> xmlDoc As<\/span> XDocument) As<\/span> XElement<\/p>\n

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

    <\/span>‘ Replace e-mail address tags with mailto links.<\/p>\n

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

    <\/span>Dim<\/span> emails = (From<\/span> email In<\/span> xmlDoc.<<\/span>Contacts><\/span>.<<\/span>Contact><\/span>.<<\/span>aci:AdditionalContactInfo><\/span>…<<\/span>act:eMail><\/span>).ToList()<\/p>\n

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

<\/p>\n

 <\/p>\n

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

    <\/span>For<\/span> Each<\/span> email In<\/span> emails<\/p>\n

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

      <\/span>TransformEmail(email)<\/p>\n

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

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

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

<\/p>\n

 <\/p>\n

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

    <\/span>‘ Create the HTML document<\/p>\n

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

    <\/span>Return<\/span> <<\/span>html<\/span>><\/p>\n

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

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

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

               <\/span><<\/span>table<\/span> border<\/span>=<\/span>“<\/span>1<\/span>“<\/span>><\/p>\n

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

                 <\/span><%=<\/span> From<\/span> contact In<\/span> xmlDoc.<<\/span>Contacts><\/span>.<<\/span>Contact><\/span> _<\/p>\n

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

                     <\/span>Select<\/span> <<\/span>tr<\/span>><\/p>\n

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

                              <\/span><<\/span>td<\/span> valign<\/span>=<\/span>“<\/span>top<\/span>“<\/span>><\/p>\n

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

                                <\/span><%=<\/span> contact.<<\/span>FirstName><\/span>.Value & ” “<\/span> & contact.<<\/span>LastName><\/span>.Value %><\/p>\n

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

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

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

                              <\/span><<\/span>td<\/span> valign<\/span>=<\/span>“<\/span>top<\/span>“<\/span>><\/p>\n

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

                                <\/span><%=<\/span> contact.<<\/span>aci:AdditionalContactInfo><\/span> %><\/p>\n

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

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

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

                            <\/span><\/<\/span>tr<\/span>><\/span> _<\/p>\n

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

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

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

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

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

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

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

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

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

  <\/span>End<\/span> Function<\/p>\n

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

<\/p>\n

 <\/p>\n

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

<\/p>\n

 <\/p>\n

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

  <\/span>Private<\/span> Sub<\/span> TransformEmail(ByVal<\/span> email As<\/span> XElement)<\/p>\n

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

    <\/span>Dim<\/span> emailHtml = <<\/span>div<\/span> class<\/span>=<\/span>“<\/span>Email<\/span>“<\/span>><\/p>\n

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

                      <\/span><<\/span>a<\/span> href<\/span>=<\/span><%=<\/span> “mailto:”<\/span> & email.<<\/span>act:eMailAddress><\/span>.Value %><\/span>><\/p>\n

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

                        <\/span><%=<\/span> email.<<\/span>act:eMailAddress><\/span>.Value %><\/p>\n

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

<\/span><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

An identity transform in XSLT does just what the name implies: replace the identity of an element or attribute with a new identity. Identity transforms are especially critical when dealing with XML markup that is less rigid in its structure. Consider a documentation structure for news articles. Whenever a title is referred to within an […]<\/p>\n","protected":false},"author":260,"featured_media":8818,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[192,195],"tags":[59,94,117,163,166,185],"class_list":["post-4453","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-featured","category-visual-basic","tag-doug-rothaus","tag-linqvb9","tag-orcas","tag-vb-xml-cookbook","tag-vb2008","tag-xml"],"acf":[],"blog_post_summary":"

An identity transform in XSLT does just what the name implies: replace the identity of an element or attribute with a new identity. Identity transforms are especially critical when dealing with XML markup that is less rigid in its structure. Consider a documentation structure for news articles. Whenever a title is referred to within an […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/4453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/users\/260"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/comments?post=4453"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/4453\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media\/8818"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media?parent=4453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/categories?post=4453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/tags?post=4453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}