<?xml version="1.0" encoding="utf-8"?>
<!--
/********************************************************
* ADO.NET 2.0 Data Provider for SQLite Version 3.X
* Written by Robert Simpson (robert@blackcastlesoft.com)
*
* Released to the public domain, use at your own risk!
********************************************************/
-->
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
<!-- EF Runtime content -->
<edmx:Runtime>
<!-- SSDL content -->
<edmx:StorageModels>
<Schema Namespace="northwindEFModel.Store" Alias="Self" Provider="System.Data.SQLite.Linq" ProviderManifestToken="ISO8601" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
<EntityContainer Name="northwindEFModelStoreContainer">
<EntitySet Name="Categories" EntityType="northwindEFModel.Store.Categories" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="Customers" EntityType="northwindEFModel.Store.Customers" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="Employees" EntityType="northwindEFModel.Store.Employees" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="EmployeesTerritories" EntityType="northwindEFModel.Store.EmployeesTerritories" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="InternationalOrders" EntityType="northwindEFModel.Store.InternationalOrders" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="OrderDetails" EntityType="northwindEFModel.Store.OrderDetails" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="Orders" EntityType="northwindEFModel.Store.Orders" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="PreviousEmployees" EntityType="northwindEFModel.Store.PreviousEmployees" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="Products" EntityType="northwindEFModel.Store.Products" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="Regions" EntityType="northwindEFModel.Store.Regions" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="Suppliers" EntityType="northwindEFModel.Store.Suppliers" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="Territories" EntityType="northwindEFModel.Store.Territories" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<AssociationSet Name="FK_EmployeesTerritories_EmployeeID_EmployeeID" Association="northwindEFModel.Store.FK_EmployeesTerritories_EmployeeID_EmployeeID">
<End Role="Employees" EntitySet="Employees" />
<End Role="EmployeesTerritories" EntitySet="EmployeesTerritories" />
</AssociationSet>
<AssociationSet Name="FK_EmployeesTerritories_TerritoryID_TerritoryID" Association="northwindEFModel.Store.FK_EmployeesTerritories_TerritoryID_TerritoryID">
<End Role="Territories" EntitySet="Territories" />
<End Role="EmployeesTerritories" EntitySet="EmployeesTerritories" />
</AssociationSet>
<AssociationSet Name="FK_InternationalOrders_OrderID_OrderID" Association="northwindEFModel.Store.FK_InternationalOrders_OrderID_OrderID">
<End Role="Orders" EntitySet="Orders" />
<End Role="InternationalOrders" EntitySet="InternationalOrders" />
</AssociationSet>
<AssociationSet Name="FK_OrderDetails_OrderID_OrderID" Association="northwindEFModel.Store.FK_OrderDetails_OrderID_OrderID">
<End Role="Orders" EntitySet="Orders" />
<End Role="OrderDetails" EntitySet="OrderDetails" />
</AssociationSet>
<AssociationSet Name="FK_OrderDetails_ProductID_ProductID" Association="northwindEFModel.Store.FK_OrderDetails_ProductID_ProductID">
<End Role="Products" EntitySet="Products" />
<End Role="OrderDetails" EntitySet="OrderDetails" />
</AssociationSet>
<AssociationSet Name="FK_Orders_CustomerID_CustomerID" Association="northwindEFModel.Store.FK_Orders_CustomerID_CustomerID">
<End Role="Customers" EntitySet="Customers" />
<End Role="Orders" EntitySet="Orders" />
</AssociationSet>
<AssociationSet Name="FK_Products_CategoryID_CategoryID" Association="northwindEFModel.Store.FK_Products_CategoryID_CategoryID">
<End Role="Categories" EntitySet="Categories" />
<End Role="Products" EntitySet="Products" />
</AssociationSet>
<AssociationSet Name="FK_Products_SupplierID_SupplierID" Association="northwindEFModel.Store.FK_Products_SupplierID_SupplierID">
<End Role="Suppliers" EntitySet="Suppliers" />
<End Role="Products" EntitySet="Products" />
</AssociationSet>
<AssociationSet Name="FK_Territories_RegionID_RegionID" Association="northwindEFModel.Store.FK_Territories_RegionID_RegionID">
<End Role="Regions" EntitySet="Regions" />
<End Role="Territories" EntitySet="Territories" />
</AssociationSet>
</EntityContainer>
<EntityType Name="Categories">
<Key>
<PropertyRef Name="CategoryID" />
</Key>
<Property Name="CategoryID" Type="integer" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="CategoryName" Type="nvarchar" Nullable="false" MaxLength="15" />
<Property Name="Description" Type="nvarchar" />
<Property Name="Picture" Type="blob" />
</EntityType>
<EntityType Name="Customers">
<Key>
<PropertyRef Name="CustomerID" />
</Key>
<Property Name="CustomerID" Type="nvarchar" 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="Employees">
<Key>
<PropertyRef Name="EmployeeID" />
</Key>
<Property Name="EmployeeID" Type="integer" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="LastName" Type="nvarchar" Nullable="false" MaxLength="20" />
<Property Name="FirstName" Type="nvarchar" Nullable="false" MaxLength="10" />
<Property Name="Title" Type="nvarchar" MaxLength="30" />
<Property Name="TitleOfCourtesy" Type="nvarchar" MaxLength="25" />
<Property Name="BirthDate" Type="datetime" />
<Property Name="HireDate" Type="datetime" />
<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="HomePhone" Type="nvarchar" MaxLength="24" />
<Property Name="Extension" Type="nvarchar" MaxLength="4" />
<Property Name="Photo" Type="blob" />
<Property Name="Notes" Type="nvarchar" />
<Property Name="PhotoPath" Type="nvarchar" MaxLength="255" />
</EntityType>
<EntityType Name="EmployeesTerritories">
<Key>
<PropertyRef Name="EmployeeID" />
<PropertyRef Name="TerritoryID" />
</Key>
<Property Name="EmployeeID" Type="integer" Nullable="false" />
<Property Name="TerritoryID" Type="integer" Nullable="false" />
</EntityType>
<EntityType Name="InternationalOrders">
<Key>
<PropertyRef Name="OrderID" />
</Key>
<Property Name="OrderID" Type="integer" Nullable="false" />
<Property Name="CustomsDescription" Type="nvarchar" Nullable="false" MaxLength="100" />
<Property Name="ExciseTax" Type="decimal" Nullable="false" Precision="53" />
</EntityType>
<EntityType Name="OrderDetails">
<Key>
<PropertyRef Name="OrderID" />
<PropertyRef Name="ProductID" />
</Key>
<Property Name="OrderID" Type="integer" Nullable="false" />
<Property Name="ProductID" Type="integer" Nullable="false" />
<Property Name="UnitPrice" Type="decimal" Nullable="false" Precision="53" />
<Property Name="Quantity" Type="smallint" Nullable="false" />
<Property Name="Discount" Type="real" Nullable="false" />
</EntityType>
<EntityType Name="Orders">
<Key>
<PropertyRef Name="OrderID" />
</Key>
<Property Name="OrderID" Type="integer" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="CustomerID" Type="nvarchar" MaxLength="5" />
<Property Name="EmployeeID" Type="integer" />
<Property Name="OrderDate" Type="datetime" />
<Property Name="RequiredDate" Type="datetime" />
<Property Name="ShippedDate" Type="datetime" />
<Property Name="Freight" Type="decimal" Precision="53" />
<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>
<EntityType Name="PreviousEmployees">
<Key>
<PropertyRef Name="EmployeeID" />
</Key>
<Property Name="EmployeeID" Type="integer" Nullable="false" />
<Property Name="LastName" Type="nvarchar" Nullable="false" MaxLength="20" />
<Property Name="FirstName" Type="nvarchar" Nullable="false" MaxLength="10" />
<Property Name="Title" Type="nvarchar" MaxLength="30" />
<Property Name="TitleOfCourtesy" Type="nvarchar" MaxLength="25" />
<Property Name="BirthDate" Type="datetime" />
<Property Name="HireDate" Type="datetime" />
<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="HomePhone" Type="nvarchar" MaxLength="24" />
<Property Name="Extension" Type="nvarchar" MaxLength="4" />
<Property Name="Photo" Type="blob" />
<Property Name="Notes" Type="nvarchar" />
<Property Name="PhotoPath" Type="nvarchar" MaxLength="255" />
</EntityType>
<EntityType Name="Products">
<Key>
<PropertyRef Name="ProductID" />
</Key>
<Property Name="ProductID" Type="integer" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
<Property Name="SupplierID" Type="integer" />
<Property Name="CategoryID" Type="integer" />
<Property Name="QuantityPerUnit" Type="nvarchar" MaxLength="20" />
<Property Name="UnitPrice" Type="decimal" Precision="53" />
<Property Name="UnitsInStock" Type="smallint" />
<Property Name="UnitsOnOrder" Type="smallint" />
<Property Name="ReorderLevel" Type="smallint" />
<Property Name="Discontinued" Type="bit" Nullable="false" />
<Property Name="DiscontinuedDate" Type="datetime" />
</EntityType>
<EntityType Name="Regions">
<Key>
<PropertyRef Name="RegionID" />
</Key>
<Property Name="RegionID" Type="integer" Nullable="false" />
<Property Name="RegionDescription" Type="nvarchar" Nullable="false" MaxLength="50" />
</EntityType>
<EntityType Name="Suppliers">
<Key>
<PropertyRef Name="SupplierID" />
</Key>
<Property Name="SupplierID" Type="integer" Nullable="false" StoreGeneratedPattern="Identity" />
<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" />
<Property Name="HomePage" Type="nvarchar" />
</EntityType>
<EntityType Name="Territories">
<Key>
<PropertyRef Name="TerritoryID" />
</Key>
<Property Name="TerritoryID" Type="integer" Nullable="false" />
<Property Name="TerritoryDescription" Type="nvarchar" Nullable="false" MaxLength="50" />
<Property Name="RegionID" Type="integer" Nullable="false" />
</EntityType>
<Association Name="FK_EmployeesTerritories_EmployeeID_EmployeeID">
<End Role="Employees" Type="northwindEFModel.Store.Employees" Multiplicity="1" />
<End Role="EmployeesTerritories" Type="northwindEFModel.Store.EmployeesTerritories" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Employees">
<PropertyRef Name="EmployeeID" />
</Principal>
<Dependent Role="EmployeesTerritories">
<PropertyRef Name="EmployeeID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_EmployeesTerritories_TerritoryID_TerritoryID">
<End Role="Territories" Type="northwindEFModel.Store.Territories" Multiplicity="1" />
<End Role="EmployeesTerritories" Type="northwindEFModel.Store.EmployeesTerritories" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Territories">
<PropertyRef Name="TerritoryID" />
</Principal>
<Dependent Role="EmployeesTerritories">
<PropertyRef Name="TerritoryID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_InternationalOrders_OrderID_OrderID">
<End Role="Orders" Type="northwindEFModel.Store.Orders" Multiplicity="1" />
<End Role="InternationalOrders" Type="northwindEFModel.Store.InternationalOrders" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Orders">
<PropertyRef Name="OrderID" />
</Principal>
<Dependent Role="InternationalOrders">
<PropertyRef Name="OrderID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_OrderDetails_OrderID_OrderID">
<End Role="Orders" Type="northwindEFModel.Store.Orders" Multiplicity="1" />
<End Role="OrderDetails" Type="northwindEFModel.Store.OrderDetails" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Orders">
<PropertyRef Name="OrderID" />
</Principal>
<Dependent Role="OrderDetails">
<PropertyRef Name="OrderID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_OrderDetails_ProductID_ProductID">
<End Role="Products" Type="northwindEFModel.Store.Products" Multiplicity="1" />
<End Role="OrderDetails" Type="northwindEFModel.Store.OrderDetails" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Products">
<PropertyRef Name="ProductID" />
</Principal>
<Dependent Role="OrderDetails">
<PropertyRef Name="ProductID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Orders_CustomerID_CustomerID">
<End Role="Customers" Type="northwindEFModel.Store.Customers" Multiplicity="0..1" />
<End Role="Orders" Type="northwindEFModel.Store.Orders" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Customers">
<PropertyRef Name="CustomerID" />
</Principal>
<Dependent Role="Orders">
<PropertyRef Name="CustomerID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Products_CategoryID_CategoryID">
<End Role="Categories" Type="northwindEFModel.Store.Categories" Multiplicity="0..1" />
<End Role="Products" Type="northwindEFModel.Store.Products" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Categories">
<PropertyRef Name="CategoryID" />
</Principal>
<Dependent Role="Products">
<PropertyRef Name="CategoryID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Products_SupplierID_SupplierID">
<End Role="Suppliers" Type="northwindEFModel.Store.Suppliers" Multiplicity="0..1" />
<End Role="Products" Type="northwindEFModel.Store.Products" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Suppliers">
<PropertyRef Name="SupplierID" />
</Principal>
<Dependent Role="Products">
<PropertyRef Name="SupplierID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Territories_RegionID_RegionID">
<End Role="Regions" Type="northwindEFModel.Store.Regions" Multiplicity="1" />
<End Role="Territories" Type="northwindEFModel.Store.Territories" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Regions">
<PropertyRef Name="RegionID" />
</Principal>
<Dependent Role="Territories">
<PropertyRef Name="RegionID" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema></edmx:StorageModels>
<!-- CSDL content -->
<edmx:ConceptualModels>
<Schema Namespace="northwindEFModel" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
<EntityContainer Name="northwindEFEntities">
<EntitySet Name="Categories" EntityType="northwindEFModel.Categories" />
<EntitySet Name="Customers" EntityType="northwindEFModel.Customers" />
<EntitySet Name="Employees" EntityType="northwindEFModel.Employees" />
<EntitySet Name="InternationalOrders" EntityType="northwindEFModel.InternationalOrders" />
<EntitySet Name="OrderDetails" EntityType="northwindEFModel.OrderDetails" />
<EntitySet Name="Orders" EntityType="northwindEFModel.Orders" />
<EntitySet Name="PreviousEmployees" EntityType="northwindEFModel.PreviousEmployees" />
<EntitySet Name="Products" EntityType="northwindEFModel.Products" />
<EntitySet Name="Regions" EntityType="northwindEFModel.Regions" />
<EntitySet Name="Suppliers" EntityType="northwindEFModel.Suppliers" />
<EntitySet Name="Territories" EntityType="northwindEFModel.Territories" />
<AssociationSet Name="FK_Products_CategoryID_CategoryID" Association="northwindEFModel.FK_Products_CategoryID_CategoryID">
<End Role="Categories" EntitySet="Categories" />
<End Role="Products" EntitySet="Products" />
</AssociationSet>
<AssociationSet Name="FK_Orders_CustomerID_CustomerID" Association="northwindEFModel.FK_Orders_CustomerID_CustomerID">
<End Role="Customers" EntitySet="Customers" />
<End Role="Orders" EntitySet="Orders" />
</AssociationSet>
<AssociationSet Name="FK_InternationalOrders_OrderID_OrderID" Association="northwindEFModel.FK_InternationalOrders_OrderID_OrderID">
<End Role="Orders" EntitySet="Orders" />
<End Role="InternationalOrders" EntitySet="InternationalOrders" />
</AssociationSet>
<AssociationSet Name="FK_OrderDetails_OrderID_OrderID" Association="northwindEFModel.FK_OrderDetails_OrderID_OrderID">
<End Role="Orders" EntitySet="Orders" />
<End Role="OrderDetails" EntitySet="OrderDetails" />
</AssociationSet>
<AssociationSet Name="FK_OrderDetails_ProductID_ProductID" Association="northwindEFModel.FK_OrderDetails_ProductID_ProductID">
<End Role="Products" EntitySet="Products" />
<End Role="OrderDetails" EntitySet="OrderDetails" />
</AssociationSet>
<AssociationSet Name="FK_Products_SupplierID_SupplierID" Association="northwindEFModel.FK_Products_SupplierID_SupplierID">
<End Role="Suppliers" EntitySet="Suppliers" />
<End Role="Products" EntitySet="Products" />
</AssociationSet>
<AssociationSet Name="FK_Territories_RegionID_RegionID" Association="northwindEFModel.FK_Territories_RegionID_RegionID">
<End Role="Regions" EntitySet="Regions" />
<End Role="Territories" EntitySet="Territories" />
</AssociationSet>
<AssociationSet Name="EmployeesTerritories" Association="northwindEFModel.EmployeesTerritories">
<End Role="Employees" EntitySet="Employees" />
<End Role="Territories" EntitySet="Territories" />
</AssociationSet>
</EntityContainer>
<EntityType Name="Categories">
<Key>
<PropertyRef Name="CategoryID" />
</Key>
<Property Name="CategoryID" Type="Int64" Nullable="false" />
<Property Name="CategoryName" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="Description" Type="String" MaxLength="2147483647" Unicode="true" FixedLength="false" />
<Property Name="Picture" Type="Binary" MaxLength="2147483647" FixedLength="false" />
<NavigationProperty Name="Products" Relationship="northwindEFModel.FK_Products_CategoryID_CategoryID" FromRole="Categories" ToRole="Products" />
</EntityType>
<EntityType Name="Customers">
<Key>
<PropertyRef Name="CustomerID" />
</Key>
<Property Name="CustomerID" Type="String" Nullable="false" MaxLength="5" Unicode="true" FixedLength="false" />
<Property Name="CompanyName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
<Property Name="ContactName" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="ContactTitle" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="Phone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
<Property Name="Fax" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
<NavigationProperty Name="Orders" Relationship="northwindEFModel.FK_Orders_CustomerID_CustomerID" FromRole="Customers" ToRole="Orders" />
</EntityType>
<EntityType Name="Employees">
<Key>
<PropertyRef Name="EmployeeID" />
</Key>
<Property Name="EmployeeID" Type="Int64" Nullable="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="20" Unicode="true" FixedLength="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Title" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="TitleOfCourtesy" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="BirthDate" Type="DateTime" />
<Property Name="HireDate" Type="DateTime" />
<Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="HomePhone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
<Property Name="Extension" Type="String" MaxLength="4" Unicode="true" FixedLength="false" />
<Property Name="Photo" Type="Binary" MaxLength="2147483647" FixedLength="false" />
<Property Name="Notes" Type="String" MaxLength="2147483647" Unicode="true" FixedLength="false" />
<Property Name="PhotoPath" Type="String" MaxLength="255" Unicode="true" FixedLength="false" />
<NavigationProperty Name="Territories" Relationship="northwindEFModel.EmployeesTerritories" FromRole="Employees" ToRole="Territories" />
</EntityType>
<EntityType Name="InternationalOrders">
<Key>
<PropertyRef Name="OrderID" />
</Key>
<Property Name="OrderID" Type="Int64" Nullable="false" />
<Property Name="CustomsDescription" Type="String" Nullable="false" MaxLength="100" Unicode="true" FixedLength="false" />
<Property Name="ExciseTax" Type="Decimal" Nullable="false" Precision="53" Scale="0" />
<NavigationProperty Name="Orders" Relationship="northwindEFModel.FK_InternationalOrders_OrderID_OrderID" FromRole="InternationalOrders" ToRole="Orders" />
</EntityType>
<EntityType Name="OrderDetails">
<Key>
<PropertyRef Name="OrderID" />
<PropertyRef Name="ProductID" />
</Key>
<Property Name="OrderID" Type="Int64" Nullable="false" />
<Property Name="ProductID" Type="Int64" Nullable="false" />
<Property Name="UnitPrice" Type="Decimal" Nullable="false" Precision="53" Scale="0" />
<Property Name="Quantity" Type="Int16" Nullable="false" />
<Property Name="Discount" Type="Single" Nullable="false" />
<NavigationProperty Name="Orders" Relationship="northwindEFModel.FK_OrderDetails_OrderID_OrderID" FromRole="OrderDetails" ToRole="Orders" />
<NavigationProperty Name="Products" Relationship="northwindEFModel.FK_OrderDetails_ProductID_ProductID" FromRole="OrderDetails" ToRole="Products" />
</EntityType>
<EntityType Name="Orders">
<Key>
<PropertyRef Name="OrderID" />
</Key>
<Property Name="OrderID" Type="Int64" Nullable="false" />
<Property Name="EmployeeID" Type="Int64" />
<Property Name="OrderDate" Type="DateTime" />
<Property Name="RequiredDate" Type="DateTime" />
<Property Name="ShippedDate" Type="DateTime" />
<Property Name="Freight" Type="Decimal" Precision="53" Scale="0" />
<Property Name="ShipName" Type="String" MaxLength="40" Unicode="true" FixedLength="false" />
<Property Name="ShipAddress" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="ShipCity" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="ShipRegion" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="ShipPostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="ShipCountry" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<NavigationProperty Name="Customers" Relationship="northwindEFModel.FK_Orders_CustomerID_CustomerID" FromRole="Orders" ToRole="Customers" />
<NavigationProperty Name="InternationalOrders" Relationship="northwindEFModel.FK_InternationalOrders_OrderID_OrderID" FromRole="Orders" ToRole="InternationalOrders" />
<NavigationProperty Name="OrderDetails" Relationship="northwindEFModel.FK_OrderDetails_OrderID_OrderID" FromRole="Orders" ToRole="OrderDetails" />
</EntityType>
<EntityType Name="PreviousEmployees">
<Key>
<PropertyRef Name="EmployeeID" />
</Key>
<Property Name="EmployeeID" Type="Int64" Nullable="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="20" Unicode="true" FixedLength="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Title" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="TitleOfCourtesy" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="BirthDate" Type="DateTime" />
<Property Name="HireDate" Type="DateTime" />
<Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="HomePhone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
<Property Name="Extension" Type="String" MaxLength="4" Unicode="true" FixedLength="false" />
<Property Name="Photo" Type="Binary" MaxLength="2147483647" FixedLength="false" />
<Property Name="Notes" Type="String" MaxLength="2147483647" Unicode="true" FixedLength="false" />
<Property Name="PhotoPath" Type="String" MaxLength="255" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="Products">
<Key>
<PropertyRef Name="ProductID" />
</Key>
<Property Name="ProductID" Type="Int64" Nullable="false" />
<Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
<Property Name="QuantityPerUnit" Type="String" MaxLength="20" Unicode="true" FixedLength="false" />
<Property Name="UnitPrice" Type="Decimal" Precision="53" Scale="0" />
<Property Name="UnitsInStock" Type="Int16" />
<Property Name="UnitsOnOrder" Type="Int16" />
<Property Name="ReorderLevel" Type="Int16" />
<Property Name="Discontinued" Type="Boolean" Nullable="false" />
<Property Name="DiscontinuedDate" Type="DateTime" />
<NavigationProperty Name="Categories" Relationship="northwindEFModel.FK_Products_CategoryID_CategoryID" FromRole="Products" ToRole="Categories" />
<NavigationProperty Name="OrderDetails" Relationship="northwindEFModel.FK_OrderDetails_ProductID_ProductID" FromRole="Products" ToRole="OrderDetails" />
<NavigationProperty Name="Suppliers" Relationship="northwindEFModel.FK_Products_SupplierID_SupplierID" FromRole="Products" ToRole="Suppliers" />
</EntityType>
<EntityType Name="Regions">
<Key>
<PropertyRef Name="RegionID" />
</Key>
<Property Name="RegionID" Type="Int64" Nullable="false" />
<Property Name="RegionDescription" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<NavigationProperty Name="Territories" Relationship="northwindEFModel.FK_Territories_RegionID_RegionID" FromRole="Regions" ToRole="Territories" />
</EntityType>
<EntityType Name="Suppliers">
<Key>
<PropertyRef Name="SupplierID" />
</Key>
<Property Name="SupplierID" Type="Int64" Nullable="false" />
<Property Name="CompanyName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
<Property Name="ContactName" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="ContactTitle" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="Phone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
<Property Name="Fax" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
<Property Name="HomePage" Type="String" MaxLength="2147483647" Unicode="true" FixedLength="false" />
<NavigationProperty Name="Products" Relationship="northwindEFModel.FK_Products_SupplierID_SupplierID" FromRole="Suppliers" ToRole="Products" />
</EntityType>
<EntityType Name="Territories">
<Key>
<PropertyRef Name="TerritoryID" />
</Key>
<Property Name="TerritoryID" Type="Int64" Nullable="false" />
<Property Name="TerritoryDescription" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<NavigationProperty Name="Regions" Relationship="northwindEFModel.FK_Territories_RegionID_RegionID" FromRole="Territories" ToRole="Regions" />
<NavigationProperty Name="Employees" Relationship="northwindEFModel.EmployeesTerritories" FromRole="Territories" ToRole="Employees" />
</EntityType>
<Association Name="FK_Products_CategoryID_CategoryID">
<End Role="Categories" Type="northwindEFModel.Categories" Multiplicity="0..1" />
<End Role="Products" Type="northwindEFModel.Products" Multiplicity="*" />
</Association>
<Association Name="FK_Orders_CustomerID_CustomerID">
<End Role="Customers" Type="northwindEFModel.Customers" Multiplicity="0..1" />
<End Role="Orders" Type="northwindEFModel.Orders" Multiplicity="*" />
</Association>
<Association Name="FK_InternationalOrders_OrderID_OrderID">
<End Role="Orders" Type="northwindEFModel.Orders" Multiplicity="1" />
<End Role="InternationalOrders" Type="northwindEFModel.InternationalOrders" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Orders">
<PropertyRef Name="OrderID" />
</Principal>
<Dependent Role="InternationalOrders">
<PropertyRef Name="OrderID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_OrderDetails_OrderID_OrderID">
<End Role="Orders" Type="northwindEFModel.Orders" Multiplicity="1" />
<End Role="OrderDetails" Type="northwindEFModel.OrderDetails" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Orders">
<PropertyRef Name="OrderID" />
</Principal>
<Dependent Role="OrderDetails">
<PropertyRef Name="OrderID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_OrderDetails_ProductID_ProductID">
<End Role="Products" Type="northwindEFModel.Products" Multiplicity="1" />
<End Role="OrderDetails" Type="northwindEFModel.OrderDetails" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Products">
<PropertyRef Name="ProductID" />
</Principal>
<Dependent Role="OrderDetails">
<PropertyRef Name="ProductID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Products_SupplierID_SupplierID">
<End Role="Suppliers" Type="northwindEFModel.Suppliers" Multiplicity="0..1" />
<End Role="Products" Type="northwindEFModel.Products" Multiplicity="*" />
</Association>
<Association Name="FK_Territories_RegionID_RegionID">
<End Role="Regions" Type="northwindEFModel.Regions" Multiplicity="1" />
<End Role="Territories" Type="northwindEFModel.Territories" Multiplicity="*" />
</Association>
<Association Name="EmployeesTerritories">
<End Role="Employees" Type="northwindEFModel.Employees" Multiplicity="*" />
<End Role="Territories" Type="northwindEFModel.Territories" Multiplicity="*" />
</Association>
</Schema>
</edmx:ConceptualModels>
<!-- C-S mapping content -->
<edmx:Mappings>
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
<EntityContainerMapping StorageEntityContainer="northwindEFModelStoreContainer" CdmEntityContainer="northwindEFEntities">
<EntitySetMapping Name="Categories">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Categories)">
<MappingFragment StoreEntitySet="Categories">
<ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
<ScalarProperty Name="CategoryName" ColumnName="CategoryName" />
<ScalarProperty Name="Description" ColumnName="Description" />
<ScalarProperty Name="Picture" ColumnName="Picture" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="Customers">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Customers)">
<MappingFragment StoreEntitySet="Customers">
<ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
<ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
<ScalarProperty Name="ContactName" ColumnName="ContactName" />
<ScalarProperty Name="ContactTitle" ColumnName="ContactTitle" />
<ScalarProperty Name="Address" ColumnName="Address" />
<ScalarProperty Name="City" ColumnName="City" />
<ScalarProperty Name="Region" ColumnName="Region" />
<ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
<ScalarProperty Name="Country" ColumnName="Country" />
<ScalarProperty Name="Phone" ColumnName="Phone" />
<ScalarProperty Name="Fax" ColumnName="Fax" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="Employees">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Employees)">
<MappingFragment StoreEntitySet="Employees">
<ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
<ScalarProperty Name="LastName" ColumnName="LastName" />
<ScalarProperty Name="FirstName" ColumnName="FirstName" />
<ScalarProperty Name="Title" ColumnName="Title" />
<ScalarProperty Name="TitleOfCourtesy" ColumnName="TitleOfCourtesy" />
<ScalarProperty Name="BirthDate" ColumnName="BirthDate" />
<ScalarProperty Name="HireDate" ColumnName="HireDate" />
<ScalarProperty Name="Address" ColumnName="Address" />
<ScalarProperty Name="City" ColumnName="City" />
<ScalarProperty Name="Region" ColumnName="Region" />
<ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
<ScalarProperty Name="Country" ColumnName="Country" />
<ScalarProperty Name="HomePhone" ColumnName="HomePhone" />
<ScalarProperty Name="Extension" ColumnName="Extension" />
<ScalarProperty Name="Photo" ColumnName="Photo" />
<ScalarProperty Name="Notes" ColumnName="Notes" />
<ScalarProperty Name="PhotoPath" ColumnName="PhotoPath" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="InternationalOrders">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.InternationalOrders)">
<MappingFragment StoreEntitySet="InternationalOrders">
<ScalarProperty Name="OrderID" ColumnName="OrderID" />
<ScalarProperty Name="CustomsDescription" ColumnName="CustomsDescription" />
<ScalarProperty Name="ExciseTax" ColumnName="ExciseTax" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="OrderDetails">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.OrderDetails)">
<MappingFragment StoreEntitySet="OrderDetails">
<ScalarProperty Name="OrderID" ColumnName="OrderID" />
<ScalarProperty Name="ProductID" ColumnName="ProductID" />
<ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
<ScalarProperty Name="Quantity" ColumnName="Quantity" />
<ScalarProperty Name="Discount" ColumnName="Discount" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="Orders">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Orders)">
<MappingFragment StoreEntitySet="Orders">
<ScalarProperty Name="OrderID" ColumnName="OrderID" />
<ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
<ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
<ScalarProperty Name="RequiredDate" ColumnName="RequiredDate" />
<ScalarProperty Name="ShippedDate" ColumnName="ShippedDate" />
<ScalarProperty Name="Freight" ColumnName="Freight" />
<ScalarProperty Name="ShipName" ColumnName="ShipName" />
<ScalarProperty Name="ShipAddress" ColumnName="ShipAddress" />
<ScalarProperty Name="ShipCity" ColumnName="ShipCity" />
<ScalarProperty Name="ShipRegion" ColumnName="ShipRegion" />
<ScalarProperty Name="ShipPostalCode" ColumnName="ShipPostalCode" />
<ScalarProperty Name="ShipCountry" ColumnName="ShipCountry" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="PreviousEmployees">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.PreviousEmployees)">
<MappingFragment StoreEntitySet="PreviousEmployees">
<ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
<ScalarProperty Name="LastName" ColumnName="LastName" />
<ScalarProperty Name="FirstName" ColumnName="FirstName" />
<ScalarProperty Name="Title" ColumnName="Title" />
<ScalarProperty Name="TitleOfCourtesy" ColumnName="TitleOfCourtesy" />
<ScalarProperty Name="BirthDate" ColumnName="BirthDate" />
<ScalarProperty Name="HireDate" ColumnName="HireDate" />
<ScalarProperty Name="Address" ColumnName="Address" />
<ScalarProperty Name="City" ColumnName="City" />
<ScalarProperty Name="Region" ColumnName="Region" />
<ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
<ScalarProperty Name="Country" ColumnName="Country" />
<ScalarProperty Name="HomePhone" ColumnName="HomePhone" />
<ScalarProperty Name="Extension" ColumnName="Extension" />
<ScalarProperty Name="Photo" ColumnName="Photo" />
<ScalarProperty Name="Notes" ColumnName="Notes" />
<ScalarProperty Name="PhotoPath" ColumnName="PhotoPath" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="Products">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Products)">
<MappingFragment StoreEntitySet="Products">
<ScalarProperty Name="ProductID" ColumnName="ProductID" />
<ScalarProperty Name="ProductName" ColumnName="ProductName" />
<ScalarProperty Name="QuantityPerUnit" ColumnName="QuantityPerUnit" />
<ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
<ScalarProperty Name="UnitsInStock" ColumnName="UnitsInStock" />
<ScalarProperty Name="UnitsOnOrder" ColumnName="UnitsOnOrder" />
<ScalarProperty Name="ReorderLevel" ColumnName="ReorderLevel" />
<ScalarProperty Name="Discontinued" ColumnName="Discontinued" />
<ScalarProperty Name="DiscontinuedDate" ColumnName="DiscontinuedDate" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="Regions">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Regions)">
<MappingFragment StoreEntitySet="Regions">
<ScalarProperty Name="RegionID" ColumnName="RegionID" />
<ScalarProperty Name="RegionDescription" ColumnName="RegionDescription" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="Suppliers">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Suppliers)">
<MappingFragment StoreEntitySet="Suppliers">
<ScalarProperty Name="SupplierID" ColumnName="SupplierID" />
<ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
<ScalarProperty Name="ContactName" ColumnName="ContactName" />
<ScalarProperty Name="ContactTitle" ColumnName="ContactTitle" />
<ScalarProperty Name="Address" ColumnName="Address" />
<ScalarProperty Name="City" ColumnName="City" />
<ScalarProperty Name="Region" ColumnName="Region" />
<ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
<ScalarProperty Name="Country" ColumnName="Country" />
<ScalarProperty Name="Phone" ColumnName="Phone" />
<ScalarProperty Name="Fax" ColumnName="Fax" />
<ScalarProperty Name="HomePage" ColumnName="HomePage" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="Territories">
<EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Territories)">
<MappingFragment StoreEntitySet="Territories">
<ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
<ScalarProperty Name="TerritoryDescription" ColumnName="TerritoryDescription" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<AssociationSetMapping Name="FK_Products_CategoryID_CategoryID" TypeName="northwindEFModel.FK_Products_CategoryID_CategoryID" StoreEntitySet="Products">
<EndProperty Name="Categories">
<ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
</EndProperty>
<EndProperty Name="Products">
<ScalarProperty Name="ProductID" ColumnName="ProductID" />
</EndProperty>
<Condition ColumnName="CategoryID" IsNull="false" />
</AssociationSetMapping>
<AssociationSetMapping Name="FK_Orders_CustomerID_CustomerID" TypeName="northwindEFModel.FK_Orders_CustomerID_CustomerID" StoreEntitySet="Orders">
<EndProperty Name="Customers">
<ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
</EndProperty>
<EndProperty Name="Orders">
<ScalarProperty Name="OrderID" ColumnName="OrderID" />
</EndProperty>
<Condition ColumnName="CustomerID" IsNull="false" />
</AssociationSetMapping>
<AssociationSetMapping Name="FK_InternationalOrders_OrderID_OrderID" TypeName="northwindEFModel.FK_InternationalOrders_OrderID_OrderID" StoreEntitySet="InternationalOrders">
<EndProperty Name="Orders">
<ScalarProperty Name="OrderID" ColumnName="OrderID" />
</EndProperty>
<EndProperty Name="InternationalOrders">
<ScalarProperty Name="OrderID" ColumnName="OrderID" />
</EndProperty>
</AssociationSetMapping>
<AssociationSetMapping Name="FK_OrderDetails_OrderID_OrderID" TypeName="northwindEFModel.FK_OrderDetails_OrderID_OrderID" StoreEntitySet="OrderDetails">
<EndProperty Name="Orders">
<ScalarProperty Name="OrderID" ColumnName="OrderID" />
</EndProperty>
<EndProperty Name="OrderDetails">
<ScalarProperty Name="OrderID" ColumnName="OrderID" />
<ScalarProperty Name="ProductID" ColumnName="ProductID" />
</EndProperty>
</AssociationSetMapping>
<AssociationSetMapping Name="FK_OrderDetails_ProductID_ProductID" TypeName="northwindEFModel.FK_OrderDetails_ProductID_ProductID" StoreEntitySet="OrderDetails">
<EndProperty Name="Products">
<ScalarProperty Name="ProductID" ColumnName="ProductID" />
</EndProperty>
<EndProperty Name="OrderDetails">
<ScalarProperty Name="OrderID" ColumnName="OrderID" />
<ScalarProperty Name="ProductID" ColumnName="ProductID" />
</EndProperty>
</AssociationSetMapping>
<AssociationSetMapping Name="FK_Products_SupplierID_SupplierID" TypeName="northwindEFModel.FK_Products_SupplierID_SupplierID" StoreEntitySet="Products">
<EndProperty Name="Suppliers">
<ScalarProperty Name="SupplierID" ColumnName="SupplierID" />
</EndProperty>
<EndProperty Name="Products">
<ScalarProperty Name="ProductID" ColumnName="ProductID" />
</EndProperty>
<Condition ColumnName="SupplierID" IsNull="false" />
</AssociationSetMapping>
<AssociationSetMapping Name="FK_Territories_RegionID_RegionID" TypeName="northwindEFModel.FK_Territories_RegionID_RegionID" StoreEntitySet="Territories">
<EndProperty Name="Regions">
<ScalarProperty Name="RegionID" ColumnName="RegionID" />
</EndProperty>
<EndProperty Name="Territories">
<ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
</EndProperty>
</AssociationSetMapping>
<AssociationSetMapping Name="EmployeesTerritories" TypeName="northwindEFModel.EmployeesTerritories" StoreEntitySet="EmployeesTerritories">
<EndProperty Name="Employees">
<ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
</EndProperty>
<EndProperty Name="Territories">
<ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
</EndProperty>
</AssociationSetMapping>
</EntityContainerMapping>
</Mapping>
</edmx:Mappings>
</edmx:Runtime>
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
<edmx:Designer>
<edmx:Connection>
<DesignerInfoPropertySet xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
</DesignerInfoPropertySet>
</edmx:Connection>
<edmx:Options>
<DesignerInfoPropertySet xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
<DesignerProperty Name="ValidateOnBuild" Value="true" />
</DesignerInfoPropertySet>
</edmx:Options>
<!-- Diagram content (shape and connector positions) -->
<edmx:Diagrams>
<Diagram Name="NorthwindModel" xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
<EntityTypeShape EntityType="northwindEFModel.Categories" Width="1.5" PointX="0.75" PointY="1.625" Height="1.9802864583333335" IsExpanded="true" />
<EntityTypeShape EntityType="northwindEFModel.Customers" Width="1.5" PointX="0.75" PointY="9.625" Height="3.3263964843749996" IsExpanded="true" />
<EntityTypeShape EntityType="northwindEFModel.Employees" Width="1.5" PointX="2.75" PointY="14.625" Height="4.4802050781250014" IsExpanded="true" />
<EntityTypeShape EntityType="northwindEFModel.InternationalOrders" Width="1.5" PointX="5.25" PointY="10.375" Height="1.7879850260416674" IsExpanded="true" />
<EntityTypeShape EntityType="northwindEFModel.OrderDetails" Width="1.5" PointX="5.25" PointY="1.5" Height="2.3648893229166656" IsExpanded="true" />
<EntityTypeShape EntityType="northwindEFModel.Orders" Width="1.5" PointX="3" PointY="9.25" Height="3.9033007812499996" IsExpanded="true" />
<EntityTypeShape EntityType="northwindEFModel.PreviousEmployees" Width="1.5" PointX="7.75" PointY="0.75" Height="4.2879036458333317" IsExpanded="true" />
<EntityTypeShape EntityType="northwindEFModel.Products" Width="1.5" PointX="3" PointY="1" Height="3.3263964843749996" IsExpanded="true" />
<EntityTypeShape EntityType="northwindEFModel.Regions" Width="1.5" PointX="2.75" PointY="6" Height="1.5956835937499996" IsExpanded="true" />
<EntityTypeShape EntityType="northwindEFModel.Suppliers" Width="1.5" PointX="0.75" PointY="4.875" Height="3.5186979166666656" IsExpanded="true" />
<EntityTypeShape EntityType="northwindEFModel.Territories" Width="1.5" PointX="5" PointY="5.875" Height="1.7879850260416674" IsExpanded="true" />
<AssociationConnector Association="northwindEFModel.FK_Products_CategoryID_CategoryID" ManuallyRouted="false">
<ConnectorPoint PointX="2.25" PointY="2.6151432291666667" />
<ConnectorPoint PointX="3" PointY="2.6151432291666667" /></AssociationConnector>
<AssociationConnector Association="northwindEFModel.FK_Orders_CustomerID_CustomerID" ManuallyRouted="false">
<ConnectorPoint PointX="2.25" PointY="11.2881982421875" />
<ConnectorPoint PointX="3" PointY="11.2881982421875" /></AssociationConnector>
<AssociationConnector Association="northwindEFModel.FK_InternationalOrders_OrderID_OrderID" ManuallyRouted="false">
<ConnectorPoint PointX="4.5" PointY="11.268992513020834" />
<ConnectorPoint PointX="5.010416666666667" PointY="11.268992513020834" />
<ConnectorPoint PointX="5.177083333333333" PointY="11.268992513020834" />
<ConnectorPoint PointX="5.25" PointY="11.268992513020834" /></AssociationConnector>
<AssociationConnector Association="northwindEFModel.FK_OrderDetails_OrderID_OrderID" ManuallyRouted="false">
<ConnectorPoint PointX="3.75" PointY="9.25" />
<ConnectorPoint PointX="3.75" PointY="7.84568359375" />
<ConnectorPoint PointX="4.75" PointY="7.84568359375" />
<ConnectorPoint PointX="4.75" PointY="2.6824446614583328" />
<ConnectorPoint PointX="5.25" PointY="2.6824446614583328" /></AssociationConnector>
<AssociationConnector Association="northwindEFModel.FK_OrderDetails_ProductID_ProductID" ManuallyRouted="false">
<ConnectorPoint PointX="4.5" PointY="2.0287223307291664" />
<ConnectorPoint PointX="5.25" PointY="2.0287223307291664" /></AssociationConnector>
<AssociationConnector Association="northwindEFModel.FK_Products_SupplierID_SupplierID" ManuallyRouted="false">
<ConnectorPoint PointX="2.25" PointY="5.40625" />
<ConnectorPoint PointX="4.40625" PointY="5.40625" />
<ConnectorPoint PointX="4.40625" PointY="4.326396484375" /></AssociationConnector>
<AssociationConnector Association="northwindEFModel.FK_Territories_RegionID_RegionID" ManuallyRouted="false">
<ConnectorPoint PointX="4.25" PointY="6.797841796875" />
<ConnectorPoint PointX="4.666666666666667" PointY="6.7978417968749989" />
<ConnectorPoint PointX="4.833333333333333" PointY="6.797841796875" />
<ConnectorPoint PointX="5" PointY="6.797841796875" /></AssociationConnector>
<AssociationConnector Association="northwindEFModel.EmployeesTerritories" ManuallyRouted="false">
<ConnectorPoint PointX="4.25" PointY="16.8651025390625" />
<ConnectorPoint PointX="5.09375" PointY="16.8651025390625" />
<ConnectorPoint PointX="5.09375" PointY="7.6629850260416674" /></AssociationConnector>
</Diagram></edmx:Diagrams>
</edmx:Designer>
</edmx:Edmx>
