<Schema Namespace="NorthwindModel.Store" Alias="Self"
ProviderManifestToken="09.00.3042"
xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">
<EntityContainer Name="dbo">
<EntitySet Name="Customers"
					EntityType="NorthwindModel.Store.Customers" />
<EntitySet Name="Orders" EntityType="NorthwindModel.Store.Orders" />
<AssociationSet Name="FK_Orders_Customers"
					Association="NorthwindModel.Store.FK_Orders_Customers">
<End Role="Customers" EntitySet="Customers" />
<End Role="Orders" EntitySet="Orders" />
</AssociationSet>
</EntityContainer>
<EntityType Name="Customers">
<Key>
	<PropertyRef Name="CustomerID" />
</Key>
<Property Name="CustomerID" Type="nchar" Nullable="false" MaxLength="5" />
<Property Name="CompanyName" Type="nvarchar" Nullable="false" MaxLength="40" />
<Property Name="ContactName" Type="nvarchar" MaxLength="30" />
<Property Name="ContactTitle" Type="nvarchar" MaxLength="30" />
<Property Name="Address" Type="nvarchar" MaxLength="60" />
<Property Name="City" Type="nvarchar" MaxLength="15" /
<Property Name="Region" Type="nvarchar" MaxLength="15" />
<Property Name="PostalCode" Type="nvarchar" MaxLength="10" />
<Property Name="Country" Type="nvarchar" MaxLength="15" />
<Property Name="Phone" Type="nvarchar" MaxLength="24" />
<Property Name="Fax" Type="nvarchar" MaxLength="24" />
</EntityType>
<EntityType Name="Orders">
<Key>
	<PropertyRef Name="OrderID" />
</Key>
<Property Name="OrderID" Type="int" Nullable="false"
				StoreGeneratedPattern="Identity" />
<Property Name="CustomerID" Type="nchar" MaxLength="5" />
<Property Name="EmployeeID" Type="int" />
<Property Name="OrderDate" Type="datetime" />
<Property Name="RequiredDate" Type="datetime" />
<Property Name="ShippedDate" Type="datetime" />
<Property Name="ShipVia" Type="int" />
<Property Name="Freight" Type="money" />
<Property Name="ShipName" Type="nvarchar" MaxLength="40" />
<Property Name="ShipAddress" Type="nvarchar" MaxLength="60" />
<Property Name="ShipCity" Type="nvarchar" MaxLength="15" />
<Property Name="ShipRegion" Type="nvarchar" MaxLength="15" />
<Property Name="ShipPostalCode" Type="nvarchar" MaxLength="10" />
<Property Name="ShipCountry" Type="nvarchar" MaxLength="15" />
</EntityType>
<Association Name="FK_Orders_Customers">
<End Role="Customers" Type="NorthwindModel.Store.Customers"
	Multiplicity="0..1" />
<End Role="Orders" Type="NorthwindModel.Store.Orders"
	Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Customers">
	<PropertyRef Name="CustomerID" />
</Principal>
<Dependent Role="Orders">
	<PropertyRef Name="CustomerID" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema>
