why does ReadXmlSchema create extra “ID” column

Bigbossman

New Member
Given an XSD file, code like the following produces an extra (and unwanted) column in both DataTables in the returned DataSet.\[code\]ds.ReadXmlSchema(s);\[/code\]Both DataTables have an Order_Id column; other columns perfectly match the XSD.Has anyone else seen this before?XSD file below:\[code\]<?xml version="1.0" encoding="utf-8"?><xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="http://stackoverflow.com/questions/12572439/urn:schemas-microsoft-com:xml-msdata"> <xs:element name="Order"> <xs:complexType> <xs:sequence> <xs:element name="Item" minOccurs="0" maxOccurs="unbounded"> <xs:complexType msdata:AutoIncrement="false"> <xs:attribute name="itemId" type="xs:unsignedInt" /> <xs:attribute name="stockCode" type="xs:string" /> <xs:attribute name="stockCodeType" type="xs:string" /> <xs:attribute name="Quantity" type="xs:unsignedLong" /> <xs:attribute name="ProductIdX" type="xs:unsignedInt" /> <xs:attribute name="legalEntity" type="xs:string" /> <xs:attribute name="countryOfIssue" type="xs:string" /> <xs:attribute name="branchSystem" type="xs:string" /> <xs:attribute name="accountId" type="xs:string" /> <xs:attribute name="settlementDate" type="xs:string" /> <xs:attribute name="tradeDate" type="xs:string" /> <xs:attribute name="partyCode" type="xs:string" /> <xs:attribute name="userId" type="xs:string" /> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="OrderId" type="xs:unsignedInt" /> <xs:attribute name="StrategyId" type="xs:string" /> <xs:attribute name="ActivityId" type="xs:string" /> </xs:complexType> </xs:element></xs:schema>\[/code\]
 
Back
Top