How do I define an XML schema to support a GUID primary key?

[PeteJ]

Greeting to all,
A newbie question.
I would like to model an XML schema to match a sql table that uses the GUID
"uniqueidentifier" data type. There is no similar data type on the XML side.
What XML data type should I use for this? Can this be done?
Thanks
-Pete

 

[Cor Ligthert]

Hi Pete,

Why not open your IDE, add new item dataset, open your server explorer and
drag the table you want to use on the workscreen. All will exactly be showed
how it has to be.

I hope this helps?

Cor

 

[PeteJ]

Thanks, Cor. I'll give it a shot.

Hi Pete,

Why not open your IDE, add new item dataset, open your server explorer and
drag the table you want to use on the workscreen. All will exactly be showed
how it has to be.

I hope this helps?

Cor

 

[Jack]

Here is the xml representation of Guid:

<xs:element name="ID" msdataataType="System.Guid, mscorlib,
Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"type="xs:string" minOccurs="0" />

Good Luck

 

[PeteJ]

Thanks, Jack.

Here is the xml representation of Guid:

<xs:element name="ID" msdataataType="System.Guid, mscorlib,
Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"type="xs:string" minOccurs="0" />

Good Luck