home *** CD-ROM | disk | FTP | other *** search
/ Visual Basic .NET - Read Less - Learn More / Visual_Basic.NET_Read_Less_Learn_More_Richard_Bowman_Visual_2002.iso / Resources / Code / Ch9-CreateDataRelation / DsNorthwind.xsd < prev    next >
Text File  |  2001-08-23  |  3KB  |  58 lines
  1. <xsd:schema id="DsNorthwind" targetNamespace="http://www.tempuri.org/DsNorthwind.xsd" xmlns="http://www.tempuri.org/DsNorthwind.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  2.     <xsd:element name="DsNorthwind" msdata:IsDataSet="true">
  3.         <xsd:complexType>
  4.             <xsd:choice maxOccurs="unbounded">
  5.                 <xsd:element name="Customers">
  6.                     <xsd:complexType>
  7.                         <xsd:sequence>
  8.                             <xsd:element name="CustomerID" type="xsd:string" />
  9.                             <xsd:element name="CompanyName" type="xsd:string" />
  10.                             <xsd:element name="ContactName" type="xsd:string" minOccurs="0" />
  11.                             <xsd:element name="ContactTitle" type="xsd:string" minOccurs="0" />
  12.                             <xsd:element name="Address" type="xsd:string" minOccurs="0" />
  13.                             <xsd:element name="City" type="xsd:string" minOccurs="0" />
  14.                             <xsd:element name="Region" type="xsd:string" minOccurs="0" />
  15.                             <xsd:element name="PostalCode" type="xsd:string" minOccurs="0" />
  16.                             <xsd:element name="Country" type="xsd:string" minOccurs="0" />
  17.                             <xsd:element name="Phone" type="xsd:string" minOccurs="0" />
  18.                             <xsd:element name="Fax" type="xsd:string" minOccurs="0" />
  19.                         </xsd:sequence>
  20.                     </xsd:complexType>
  21.                 </xsd:element>
  22.                 <xsd:element name="Orders">
  23.                     <xsd:complexType>
  24.                         <xsd:sequence>
  25.                             <xsd:element name="OrderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xsd:int" />
  26.                             <xsd:element name="CustomerID" type="xsd:string" minOccurs="0" />
  27.                             <xsd:element name="EmployeeID" type="xsd:int" minOccurs="0" />
  28.                             <xsd:element name="OrderDate" type="xsd:dateTime" minOccurs="0" />
  29.                             <xsd:element name="RequiredDate" type="xsd:dateTime" minOccurs="0" />
  30.                             <xsd:element name="ShippedDate" type="xsd:dateTime" minOccurs="0" />
  31.                             <xsd:element name="ShipVia" type="xsd:int" minOccurs="0" />
  32.                             <xsd:element name="Freight" type="xsd:decimal" minOccurs="0" />
  33.                             <xsd:element name="ShipName" type="xsd:string" minOccurs="0" />
  34.                             <xsd:element name="ShipAddress" type="xsd:string" minOccurs="0" />
  35.                             <xsd:element name="ShipCity" type="xsd:string" minOccurs="0" />
  36.                             <xsd:element name="ShipRegion" type="xsd:string" minOccurs="0" />
  37.                             <xsd:element name="ShipPostalCode" type="xsd:string" minOccurs="0" />
  38.                             <xsd:element name="ShipCountry" type="xsd:string" minOccurs="0" />
  39.                         </xsd:sequence>
  40.                     </xsd:complexType>
  41.                 </xsd:element>
  42.             </xsd:choice>
  43.         </xsd:complexType>
  44.         <xsd:unique name="Constraint1" msdata:PrimaryKey="true">
  45.             <xsd:selector xpath=".//Customers" />
  46.             <xsd:field xpath="CustomerID" />
  47.         </xsd:unique>
  48.         <xsd:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  49.             <xsd:selector xpath=".//Orders" />
  50.             <xsd:field xpath="OrderID" />
  51.         </xsd:unique>
  52.         <xsd:keyref name="CustomersOrders" refer="Constraint1">
  53.             <xsd:selector xpath=".//Orders" />
  54.             <xsd:field xpath="CustomerID" />
  55.         </xsd:keyref>
  56.     </xsd:element>
  57. </xsd:schema>
  58.