Create an XML schema form a DataSet

Create an XML schema form a DataSet

You can store the schema definition with data from a DataSet within XML file by passing XmlWriteMode.WriteSchema as the second parameter of the WriteXml method  of DataSet. XmlWriteMode enumeration specifies how to write XML data and a relational schema from a DataSet.  

The following code shows how generates the schema definition within the XML file

string strFileName = @"..\..\Customer.xml";

string strConnectString = "Data Source=(local);Integrated security=SSPI;Initial Catalog=AdventureWorks;";

string strText = "SELECT Top 2 * FROM Sales.Customer Order By ModifiedDate Desc";

// Create and fill a DataSet using a data adapter

SqlDataAdapter objDataAdapter = new SqlDataAdapter(strText, strConnectString);

DataSet objDataSet = new DataSet("CustomerData");

// Fill DataSet with customer record

objDataAdapter.Fill(objDataSet,"Customer");

// Write the xml schema for the DataSet

objDataSet.WriteXml(strFileName, XmlWriteMode.WriteSchema);

 

The resulting XML schema file contents will look like this :

 

<?xml version="1.0" standalone="yes"?>

<CustomerData>

  <xs:schema id="CustomerData" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

    <xs:element name="CustomerData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">

      <xs:complexType>

        <xs:choice minOccurs="0" maxOccurs="unbounded">

          <xs:element name="Customer">

            <xs:complexType>

              <xs:sequence>

                <xs:element name="CustomerID" type="xs:int" minOccurs="0" />

                <xs:element name="TerritoryID" type="xs:int" minOccurs="0" />

                <xs:element name="AccountNumber" type="xs:string" minOccurs="0" />

                <xs:element name="CustomerType" type="xs:string" minOccurs="0" />

                <xs:element name="rowguid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" minOccurs="0" />

                <xs:element name="ModifiedDate" type="xs:dateTime" minOccurs="0" />

              </xs:sequence>

            </xs:complexType>

          </xs:element>

        </xs:choice>

      </xs:complexType>

    </xs:element>

  </xs:schema>

  <Customer>

    <CustomerID>3</CustomerID>

    <TerritoryID>4</TerritoryID>

    <AccountNumber>AW00000003</AccountNumber>

    <CustomerType>S</CustomerType>

    <rowguid>130774b1-db21-4ef3-98c8-c104bcd6ed6d</rowguid>

    <ModifiedDate>2004-10-13T11:15:07.263+05:30</ModifiedDate>

  </Customer>

  <Customer>

    <CustomerID>2</CustomerID>

    <TerritoryID>1</TerritoryID>

    <AccountNumber>AW00000002</AccountNumber>

    <CustomerType>S</CustomerType>

    <rowguid>e552f657-a9af-4a7d-a645-c429d6e02491</rowguid>

    <ModifiedDate>2004-10-13T11:15:07.263+05:30</ModifiedDate>

  </Customer>

</CustomerData>