Using XSLT to Append Attributes to an XSD File

[David Elliott]

I wrote an application to scrape a database and create an XSD file which will be annotated
by a map file in order to create a Typed DataSet. I was wondering if I could do the annotation
using XSLT.

Here is background on Typed DataSet:
Using Annotations with a Typed DataSet
http://msdn.microsoft.com/library/de...pedDataSet.asp

I need to append an attribute a specific XML node.

Change
<xs:element name="column_1" msdata:ReadOnly ="true" minOccurs="0" type="xs:short" />
<xs:element name="column_2" msdata:ReadOnly ="true" minOccurs="0" type="xs:int" />
to
<xs:element name="column_1" msdata:ReadOnly ="true" minOccurs="0" type="xs:short" msprop:typedNam e="ID" />
<xs:element name="column_2" msdata:ReadOnly ="true" minOccurs="0" type="xs:int" msprop:typedNam e="Name" />
I have included an XSD file that was returned as a result of my application before it is annotated.

Any thoughts would be appreciated.

Cheers,
Dave

=============== =============== =============== ============

<?xml version="1.0" standalone="yes "?>
<xs:schema id="DsStoredPro c" xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="DsStoredP roc" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice maxOccurs="unbo unded">
<xs:element name="Table">
<xs:complexType >
<xs:sequence>
<xs:element name="column_1" msdata:ReadOnly ="true" minOccurs="0" type="xs:short" />
<xs:element name="column_2" msdata:ReadOnly ="true" minOccurs="0" type="xs:int" />
<xs:element name="column_3" msdata:ReadOnly ="true" minOccurs="0" type="xs:int" />
<xs:element name="column_4" msdata:ReadOnly ="true" minOccurs="0" type="xs:short" />
<xs:element name="column_5" msdata:ReadOnly ="true" minOccurs="0" type="xs:int" />
<xs:element name="column_6" msdata:ReadOnly ="true" minOccurs="0" type="xs:short" />
<xs:element name="column_7" msdata:ReadOnly ="true" minOccurs="0" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Table1">
<xs:complexType >
<xs:sequence>
<xs:element name="column_8" minOccurs="0" type="xs:short" />
<xs:element name="column_9" minOccurs="0" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Table2">
<xs:complexType >
<xs:sequence>
<xs:element name="column_10 " type="xs:int" />
<xs:element name="column_11 " type="xs:short" />
<xs:element name="column_12 " type="xs:int" />
<xs:element name="column_13 " type="xs:short" />
<xs:element name="column_14 " type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>

[Kevin Yu [MSFT]]

Hi David,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to add annotation to your
typed dataset schema. If there is any misunderstandin g, please feel free to
let me know.

As far as I know, the annotation is added to the .XSD files directly. So I
think we needn't use any programs to add them automatically. Although we
can use an XSLT to add, I think it will be more easier to add the
annotations manually to the schema.

HTH. If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[Oleg Tkachenko [MVP]]

David Elliott wrote:

I wrote an application to scrape a database and create an XSD file which will be annotated
by a map file in order to create a Typed DataSet. I was wondering if I could do the annotation
using XSLT.

Here is background on Typed DataSet:
Using Annotations with a Typed DataSet
http://msdn.microsoft.com/library/de...pedDataSet.asp

I need to append an attribute a specific XML node.

Change
<xs:element name="column_1" msdata:ReadOnly ="true" minOccurs="0" type="xs:short" />
<xs:element name="column_2" msdata:ReadOnly ="true" minOccurs="0" type="xs:int" />
to
<xs:element name="column_1" msdata:ReadOnly ="true" minOccurs="0" type="xs:short" msprop:typedNam e="ID" />
<xs:element name="column_2" msdata:ReadOnly ="true" minOccurs="0" type="xs:int" msprop:typedNam e="Name" />

That's piece of cake in XSLT, here is the idea:

<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msprop="m sprop namespace">
<xsl:template match="@*|node( )">
<xsl:copy>
<xsl:apply-templates select="@*|node ()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="xs:eleme nt[@name='column_1 ']">
<xsl:copy>
<xsl:attribut e name="msprop:ty pedName">ID</xsl:attribute>
<xsl:apply-templates select="@*|node ()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com

[David Elliott]

Thanks.

Dave
On Tue, 13 Jul 2004 14:47:46 +0200, "Oleg Tkachenko [MVP]" <oleg@NO!SPAM!P LEASEtkachenko. com> wrote:

David Elliott wrote:

I wrote an application to scrape a database and create an XSD file which will be annotated
by a map file in order to create a Typed DataSet. I was wondering if I could do the annotation
using XSLT.

Here is background on Typed DataSet:
Using Annotations with a Typed DataSet
http://msdn.microsoft.com/library/de...pedDataSet.asp

I need to append an attribute a specific XML node.

Change
<xs:element name="column_1" msdata:ReadOnly ="true" minOccurs="0" type="xs:short" />
<xs:element name="column_2" msdata:ReadOnly ="true" minOccurs="0" type="xs:int" />
to
<xs:element name="column_1" msdata:ReadOnly ="true" minOccurs="0" type="xs:short" msprop:typedNam e="ID" />
<xs:element name="column_2" msdata:ReadOnly ="true" minOccurs="0" type="xs:int" msprop:typedNam e="Name" />

That's piece of cake in XSLT, here is the idea:

<xsl:styleshee t version="1.0"
xmlns:xsl="htt p://www.w3.org/1999/XSL/Transform"
xmlns:xs="http ://www.w3.org/2001/XMLSchema" xmlns:msprop="m sprop namespace">
<xsl:template match="@*|node( )">
<xsl:copy>
<xsl:apply-templates select="@*|node ()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="xs:eleme nt[@name='column_1 ']">
<xsl:copy>
<xsl:attribut e name="msprop:ty pedName">ID</xsl:attribute>
<xsl:apply-templates select="@*|node ()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>