<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
      <Schema Namespace="C1NWindModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityType Name="Categories">
          <Key>
            <PropertyRef Name="CategoryID" />
          </Key>
          <Property Name="CategoryID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="CategoryName" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="Description" Type="nvarchar(max)" />
          <Property Name="Picture" Type="image" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6013: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Category Sales for 1995' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.
        <EntityType Name="Category Sales for 1995">
          <Property Name="CategoryName" Type="nvarchar" MaxLength="15" />
          <Property Name="CategorySales" Type="money" />
        </EntityType>-->
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Current Product List' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Current Product List">
          <Key>
            <PropertyRef Name="ProductID" />
          </Key>
          <Property Name="ProductID" Type="int" Nullable="false" />
          <Property Name="ProductName" Type="nvarchar" MaxLength="40" />
        </EntityType>
        <EntityType Name="Customers">
          <Key>
            <PropertyRef Name="CustomerID" />
          </Key>
          <Property Name="CustomerID" Type="nvarchar" MaxLength="5" Nullable="false" />
          <Property Name="CompanyName" Type="nvarchar" MaxLength="40" Nullable="false" />
          <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>
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Employees' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Employees">
          <Key>
            <PropertyRef Name="EmployeeID" />
            <PropertyRef Name="LastName" />
            <PropertyRef Name="FirstName" />
          </Key>
          <Property Name="EmployeeID" Type="int" Nullable="false" />
          <Property Name="LastName" Type="nvarchar" MaxLength="20" Nullable="false" />
          <Property Name="FirstName" Type="nvarchar" MaxLength="10" Nullable="false" />
          <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="image" />
          <Property Name="Notes" Type="nvarchar(max)" />
          <Property Name="ReportsTo" Type="int" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.EmployeeTerritories' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="EmployeeTerritories">
          <Key>
            <PropertyRef Name="EmployeeID" />
            <PropertyRef Name="TerritoryID" />
          </Key>
          <Property Name="EmployeeID" Type="int" Nullable="false" />
          <Property Name="TerritoryID" Type="nvarchar" MaxLength="20" Nullable="false" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Invoices' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Invoices">
          <Key>
            <PropertyRef Name="OrderID" />
          </Key>
          <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" />
          <Property Name="CustomerID" Type="nvarchar" MaxLength="5" />
          <Property Name="Customers.CompanyName" Type="nvarchar" MaxLength="40" />
          <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="Salesperson" Type="nvarchar" MaxLength="255" />
          <Property Name="OrderID" Type="int" Nullable="false" />
          <Property Name="OrderDate" Type="datetime" />
          <Property Name="RequiredDate" Type="datetime" />
          <Property Name="ShippedDate" Type="datetime" />
          <Property Name="Shippers.CompanyName" Type="nvarchar" MaxLength="40" />
          <Property Name="ProductID" Type="int" />
          <Property Name="ProductName" Type="nvarchar" MaxLength="40" />
          <Property Name="UnitPrice" Type="money" />
          <Property Name="Quantity" Type="smallint" />
          <Property Name="Discount" Type="real" />
          <Property Name="ExtendedPrice" Type="money" />
          <Property Name="Freight" Type="money" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Order Details' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Order Details">
          <Key>
            <PropertyRef Name="ProductID" />
            <PropertyRef Name="UnitPrice" />
            <PropertyRef Name="Quantity" />
            <PropertyRef Name="Discount" />
          </Key>
          <Property Name="OrderID" Type="int" />
          <Property Name="ProductID" Type="int" Nullable="false" />
          <Property Name="UnitPrice" Type="money" Nullable="false" />
          <Property Name="Quantity" Type="smallint" Nullable="false" />
          <Property Name="Discount" Type="real" Nullable="false" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6013: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Order Details Extended' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.
        <EntityType Name="Order Details Extended">
          <Property Name="OrderID" Type="int" />
          <Property Name="ProductID" Type="int" />
          <Property Name="ProductName" Type="nvarchar" MaxLength="40" />
          <Property Name="UnitPrice" Type="money" />
          <Property Name="Quantity" Type="smallint" />
          <Property Name="Discount" Type="real" />
          <Property Name="ExtendedPrice" Type="money" />
        </EntityType>-->
        <!--Errors Found During Generation:
warning 6013: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Order Subtotals' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.
        <EntityType Name="Order Subtotals">
          <Property Name="OrderID" Type="int" />
          <Property Name="Subtotal" Type="money" />
        </EntityType>-->
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Orders' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Orders">
          <Key>
            <PropertyRef Name="OrderID" />
          </Key>
          <Property Name="OrderID" Type="int" Nullable="false" />
          <Property Name="CustomerID" Type="nvarchar" 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>
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Photos' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Photos">
          <Key>
            <PropertyRef Name="PhotoID" />
          </Key>
          <Property Name="PhotoID" Type="int" Nullable="false" />
          <Property Name="Place" Type="nvarchar" MaxLength="50" />
          <Property Name="Photo" Type="image" />
          <Property Name="Author" Type="nvarchar" MaxLength="50" />
          <Property Name="Country" Type="nvarchar" MaxLength="50" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6013: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Product Sales for 1995' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.
        <EntityType Name="Product Sales for 1995">
          <Property Name="CategoryName" Type="nvarchar" MaxLength="15" />
          <Property Name="ProductName" Type="nvarchar" MaxLength="40" />
          <Property Name="ProductSales" Type="money" />
        </EntityType>-->
        <EntityType Name="Products">
          <Key>
            <PropertyRef Name="ProductID" />
          </Key>
          <Property Name="ProductID" Type="int" Nullable="false" />
          <Property Name="ProductName" Type="nvarchar" MaxLength="40" Nullable="false" />
          <Property Name="SupplierID" Type="int" />
          <Property Name="CategoryID" Type="int" />
          <Property Name="QuantityPerUnit" Type="nvarchar" MaxLength="20" />
          <Property Name="UnitPrice" Type="money" />
          <Property Name="UnitsInStock" Type="smallint" />
          <Property Name="UnitsOnOrder" Type="smallint" />
          <Property Name="ReorderLevel" Type="smallint" />
          <Property Name="Discontinued" Type="bit" Nullable="false" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6013: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Products Above Average Price' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.
        <EntityType Name="Products Above Average Price">
          <Property Name="ProductName" Type="nvarchar" MaxLength="40" />
          <Property Name="UnitPrice" Type="money" />
        </EntityType>-->
        <!--Errors Found During Generation:
warning 6013: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Quarterly Orders' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.
        <EntityType Name="Quarterly Orders">
          <Property Name="CustomerID" Type="nvarchar" MaxLength="5" />
          <Property Name="CompanyName" Type="nvarchar" MaxLength="40" />
          <Property Name="City" Type="nvarchar" MaxLength="15" />
          <Property Name="Country" Type="nvarchar" MaxLength="15" />
        </EntityType>-->
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Region' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Region">
          <Key>
            <PropertyRef Name="RegionID" />
            <PropertyRef Name="RegionDescription" />
          </Key>
          <Property Name="RegionID" Type="int" Nullable="false" />
          <Property Name="RegionDescription" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Sales by Category' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Sales by Category">
          <Key>
            <PropertyRef Name="CategoryID" />
          </Key>
          <Property Name="CategoryID" Type="int" Nullable="false" />
          <Property Name="CategoryName" Type="nvarchar" MaxLength="15" />
          <Property Name="ProductName" Type="nvarchar" MaxLength="40" />
          <Property Name="ProductSales" Type="money" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Shippers' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Shippers">
          <Key>
            <PropertyRef Name="ShipperID" />
            <PropertyRef Name="CompanyName" />
          </Key>
          <Property Name="ShipperID" Type="int" Nullable="false" />
          <Property Name="CompanyName" Type="nvarchar" MaxLength="40" Nullable="false" />
          <Property Name="Phone" Type="nvarchar" MaxLength="24" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Suppliers' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Suppliers">
          <Key>
            <PropertyRef Name="SupplierID" />
            <PropertyRef Name="CompanyName" />
          </Key>
          <Property Name="SupplierID" Type="int" Nullable="false" />
          <Property Name="CompanyName" Type="nvarchar" MaxLength="40" Nullable="false" />
          <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(max)" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6013: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Ten Most Expensive Products' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.
        <EntityType Name="Ten Most Expensive Products">
          <Property Name="TenMostExpensiveProducts" Type="nvarchar" MaxLength="40" />
          <Property Name="UnitPrice" Type="money" />
        </EntityType>-->
        <!--Errors Found During Generation:
warning 6002: The table/view '44958BE750E3DD42B200C704ABCABE6D_HOWTO\COLLECTIONVIEW\ASPNETMVCCOLLECTIONVIEW101\ASPNETMVCCOLLECTIONVIEW101\APP_DATA\C1NWIND.MDF.dbo.Territories' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Territories">
          <Key>
            <PropertyRef Name="TerritoryID" />
            <PropertyRef Name="TerritoryDescription" />
            <PropertyRef Name="RegionID" />
          </Key>
          <Property Name="TerritoryID" Type="nvarchar" MaxLength="20" Nullable="false" />
          <Property Name="TerritoryDescription" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="RegionID" Type="int" Nullable="false" />
        </EntityType>
        <EntityContainer Name="C1NWindModelStoreContainer">
          <EntitySet Name="Categories" EntityType="Self.Categories" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Customers" EntityType="Self.Customers" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Products" EntityType="Self.Products" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Current Product List" EntityType="Self.Current Product List" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Current Product List].[ProductID] AS [ProductID], 
    [Current Product List].[ProductName] AS [ProductName]
    FROM [dbo].[Current Product List] AS [Current Product List]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="Employees" EntityType="Self.Employees" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Employees].[EmployeeID] AS [EmployeeID], 
    [Employees].[LastName] AS [LastName], 
    [Employees].[FirstName] AS [FirstName], 
    [Employees].[Title] AS [Title], 
    [Employees].[TitleOfCourtesy] AS [TitleOfCourtesy], 
    [Employees].[BirthDate] AS [BirthDate], 
    [Employees].[HireDate] AS [HireDate], 
    [Employees].[Address] AS [Address], 
    [Employees].[City] AS [City], 
    [Employees].[Region] AS [Region], 
    [Employees].[PostalCode] AS [PostalCode], 
    [Employees].[Country] AS [Country], 
    [Employees].[HomePhone] AS [HomePhone], 
    [Employees].[Extension] AS [Extension], 
    [Employees].[Photo] AS [Photo], 
    [Employees].[Notes] AS [Notes], 
    [Employees].[ReportsTo] AS [ReportsTo]
    FROM [dbo].[Employees] AS [Employees]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="EmployeeTerritories" EntityType="Self.EmployeeTerritories" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [EmployeeTerritories].[EmployeeID] AS [EmployeeID], 
    [EmployeeTerritories].[TerritoryID] AS [TerritoryID]
    FROM [dbo].[EmployeeTerritories] AS [EmployeeTerritories]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="Invoices" EntityType="Self.Invoices" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Invoices].[ShipName] AS [ShipName], 
    [Invoices].[ShipAddress] AS [ShipAddress], 
    [Invoices].[ShipCity] AS [ShipCity], 
    [Invoices].[ShipRegion] AS [ShipRegion], 
    [Invoices].[ShipPostalCode] AS [ShipPostalCode], 
    [Invoices].[ShipCountry] AS [ShipCountry], 
    [Invoices].[CustomerID] AS [CustomerID], 
    [Invoices].[Customers.CompanyName] AS [Customers.CompanyName], 
    [Invoices].[Address] AS [Address], 
    [Invoices].[City] AS [City], 
    [Invoices].[Region] AS [Region], 
    [Invoices].[PostalCode] AS [PostalCode], 
    [Invoices].[Country] AS [Country], 
    [Invoices].[Salesperson] AS [Salesperson], 
    [Invoices].[OrderID] AS [OrderID], 
    [Invoices].[OrderDate] AS [OrderDate], 
    [Invoices].[RequiredDate] AS [RequiredDate], 
    [Invoices].[ShippedDate] AS [ShippedDate], 
    [Invoices].[Shippers.CompanyName] AS [Shippers.CompanyName], 
    [Invoices].[ProductID] AS [ProductID], 
    [Invoices].[ProductName] AS [ProductName], 
    [Invoices].[UnitPrice] AS [UnitPrice], 
    [Invoices].[Quantity] AS [Quantity], 
    [Invoices].[Discount] AS [Discount], 
    [Invoices].[ExtendedPrice] AS [ExtendedPrice], 
    [Invoices].[Freight] AS [Freight]
    FROM [dbo].[Invoices] AS [Invoices]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="Order Details" EntityType="Self.Order Details" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Order Details].[OrderID] AS [OrderID], 
    [Order Details].[ProductID] AS [ProductID], 
    [Order Details].[UnitPrice] AS [UnitPrice], 
    [Order Details].[Quantity] AS [Quantity], 
    [Order Details].[Discount] AS [Discount]
    FROM [dbo].[Order Details] AS [Order Details]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="Orders" EntityType="Self.Orders" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Orders].[OrderID] AS [OrderID], 
    [Orders].[CustomerID] AS [CustomerID], 
    [Orders].[EmployeeID] AS [EmployeeID], 
    [Orders].[OrderDate] AS [OrderDate], 
    [Orders].[RequiredDate] AS [RequiredDate], 
    [Orders].[ShippedDate] AS [ShippedDate], 
    [Orders].[ShipVia] AS [ShipVia], 
    [Orders].[Freight] AS [Freight], 
    [Orders].[ShipName] AS [ShipName], 
    [Orders].[ShipAddress] AS [ShipAddress], 
    [Orders].[ShipCity] AS [ShipCity], 
    [Orders].[ShipRegion] AS [ShipRegion], 
    [Orders].[ShipPostalCode] AS [ShipPostalCode], 
    [Orders].[ShipCountry] AS [ShipCountry]
    FROM [dbo].[Orders] AS [Orders]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="Photos" EntityType="Self.Photos" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Photos].[PhotoID] AS [PhotoID], 
    [Photos].[Place] AS [Place], 
    [Photos].[Photo] AS [Photo], 
    [Photos].[Author] AS [Author], 
    [Photos].[Country] AS [Country]
    FROM [dbo].[Photos] AS [Photos]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="Region" EntityType="Self.Region" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Region].[RegionID] AS [RegionID], 
    [Region].[RegionDescription] AS [RegionDescription]
    FROM [dbo].[Region] AS [Region]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="Sales by Category" EntityType="Self.Sales by Category" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Sales by Category].[CategoryID] AS [CategoryID], 
    [Sales by Category].[CategoryName] AS [CategoryName], 
    [Sales by Category].[ProductName] AS [ProductName], 
    [Sales by Category].[ProductSales] AS [ProductSales]
    FROM [dbo].[Sales by Category] AS [Sales by Category]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="Shippers" EntityType="Self.Shippers" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Shippers].[ShipperID] AS [ShipperID], 
    [Shippers].[CompanyName] AS [CompanyName], 
    [Shippers].[Phone] AS [Phone]
    FROM [dbo].[Shippers] AS [Shippers]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="Suppliers" EntityType="Self.Suppliers" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Suppliers].[SupplierID] AS [SupplierID], 
    [Suppliers].[CompanyName] AS [CompanyName], 
    [Suppliers].[ContactName] AS [ContactName], 
    [Suppliers].[ContactTitle] AS [ContactTitle], 
    [Suppliers].[Address] AS [Address], 
    [Suppliers].[City] AS [City], 
    [Suppliers].[Region] AS [Region], 
    [Suppliers].[PostalCode] AS [PostalCode], 
    [Suppliers].[Country] AS [Country], 
    [Suppliers].[Phone] AS [Phone], 
    [Suppliers].[Fax] AS [Fax], 
    [Suppliers].[HomePage] AS [HomePage]
    FROM [dbo].[Suppliers] AS [Suppliers]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="Territories" EntityType="Self.Territories" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [Territories].[TerritoryID] AS [TerritoryID], 
    [Territories].[TerritoryDescription] AS [TerritoryDescription], 
    [Territories].[RegionID] AS [RegionID]
    FROM [dbo].[Territories] AS [Territories]</DefiningQuery>
          </EntitySet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="C1NWindModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityType Name="Category">
          <Key>
            <PropertyRef Name="CategoryID" />
          </Key>
          <Property Name="CategoryID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="CategoryName" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="Customer">
          <Key>
            <PropertyRef Name="CustomerID" />
          </Key>
          <Property Name="CustomerID" Type="String" MaxLength="5" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="CompanyName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="ContactName" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="ContactTitle" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="Address" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
          <Property Name="City" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="Region" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="PostalCode" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Country" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="Phone" Type="String" MaxLength="24" FixedLength="false" Unicode="true" />
          <Property Name="Fax" Type="String" MaxLength="24" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="Product">
          <Key>
            <PropertyRef Name="ProductID" />
          </Key>
          <Property Name="ProductID" Type="Int32" Nullable="false" />
          <Property Name="ProductName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="SupplierID" Type="Int32" />
          <Property Name="CategoryID" Type="Int32" />
          <Property Name="QuantityPerUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="UnitPrice" Type="Decimal" Precision="19" Scale="4" />
          <Property Name="UnitsInStock" Type="Int16" />
          <Property Name="UnitsOnOrder" Type="Int16" />
          <Property Name="ReorderLevel" Type="Int16" />
          <Property Name="Discontinued" Type="Boolean" Nullable="false" />
        </EntityType>
        <EntityType Name="Current_Product_List">
          <Key>
            <PropertyRef Name="ProductID" />
          </Key>
          <Property Name="ProductID" Type="Int32" Nullable="false" />
          <Property Name="ProductName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="Employee">
          <Key>
            <PropertyRef Name="EmployeeID" />
            <PropertyRef Name="LastName" />
            <PropertyRef Name="FirstName" />
          </Key>
          <Property Name="EmployeeID" Type="Int32" Nullable="false" />
          <Property Name="LastName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="FirstName" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Title" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="TitleOfCourtesy" Type="String" MaxLength="25" FixedLength="false" Unicode="true" />
          <Property Name="BirthDate" Type="DateTime" Precision="3" />
          <Property Name="HireDate" Type="DateTime" Precision="3" />
          <Property Name="Address" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
          <Property Name="City" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="Region" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="PostalCode" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Country" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="HomePhone" Type="String" MaxLength="24" FixedLength="false" Unicode="true" />
          <Property Name="Extension" Type="String" MaxLength="4" FixedLength="false" Unicode="true" />
          <Property Name="Photo" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="Notes" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="ReportsTo" Type="Int32" />
        </EntityType>
        <EntityType Name="EmployeeTerritory">
          <Key>
            <PropertyRef Name="EmployeeID" />
            <PropertyRef Name="TerritoryID" />
          </Key>
          <Property Name="EmployeeID" Type="Int32" Nullable="false" />
          <Property Name="TerritoryID" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="Invoice">
          <Key>
            <PropertyRef Name="OrderID" />
          </Key>
          <Property Name="ShipName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
          <Property Name="ShipAddress" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
          <Property Name="ShipCity" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="ShipRegion" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="ShipPostalCode" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="ShipCountry" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="CustomerID" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
          <Property Name="Customers_CompanyName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
          <Property Name="Address" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
          <Property Name="City" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="Region" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="PostalCode" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Country" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="Salesperson" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="OrderID" Type="Int32" Nullable="false" />
          <Property Name="OrderDate" Type="DateTime" Precision="3" />
          <Property Name="RequiredDate" Type="DateTime" Precision="3" />
          <Property Name="ShippedDate" Type="DateTime" Precision="3" />
          <Property Name="Shippers_CompanyName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
          <Property Name="ProductID" Type="Int32" />
          <Property Name="ProductName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
          <Property Name="UnitPrice" Type="Decimal" Precision="19" Scale="4" />
          <Property Name="Quantity" Type="Int16" />
          <Property Name="Discount" Type="Single" />
          <Property Name="ExtendedPrice" Type="Decimal" Precision="19" Scale="4" />
          <Property Name="Freight" Type="Decimal" Precision="19" Scale="4" />
        </EntityType>
        <EntityType Name="Order_Detail">
          <Key>
            <PropertyRef Name="ProductID" />
            <PropertyRef Name="UnitPrice" />
            <PropertyRef Name="Quantity" />
            <PropertyRef Name="Discount" />
          </Key>
          <Property Name="OrderID" Type="Int32" />
          <Property Name="ProductID" Type="Int32" Nullable="false" />
          <Property Name="UnitPrice" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
          <Property Name="Quantity" Type="Int16" Nullable="false" />
          <Property Name="Discount" Type="Single" Nullable="false" />
        </EntityType>
        <EntityType Name="Order">
          <Key>
            <PropertyRef Name="OrderID" />
          </Key>
          <Property Name="OrderID" Type="Int32" Nullable="false" />
          <Property Name="CustomerID" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
          <Property Name="EmployeeID" Type="Int32" />
          <Property Name="OrderDate" Type="DateTime" Precision="3" />
          <Property Name="RequiredDate" Type="DateTime" Precision="3" />
          <Property Name="ShippedDate" Type="DateTime" Precision="3" />
          <Property Name="ShipVia" Type="Int32" />
          <Property Name="Freight" Type="Decimal" Precision="19" Scale="4" />
          <Property Name="ShipName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
          <Property Name="ShipAddress" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
          <Property Name="ShipCity" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="ShipRegion" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="ShipPostalCode" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="ShipCountry" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="Photo">
          <Key>
            <PropertyRef Name="PhotoID" />
          </Key>
          <Property Name="PhotoID" Type="Int32" Nullable="false" />
          <Property Name="Place" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Photo1" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="Author" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Country" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="Region">
          <Key>
            <PropertyRef Name="RegionID" />
            <PropertyRef Name="RegionDescription" />
          </Key>
          <Property Name="RegionID" Type="Int32" Nullable="false" />
          <Property Name="RegionDescription" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="Sales_by_Category">
          <Key>
            <PropertyRef Name="CategoryID" />
          </Key>
          <Property Name="CategoryID" Type="Int32" Nullable="false" />
          <Property Name="CategoryName" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="ProductName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
          <Property Name="ProductSales" Type="Decimal" Precision="19" Scale="4" />
        </EntityType>
        <EntityType Name="Shipper">
          <Key>
            <PropertyRef Name="ShipperID" />
            <PropertyRef Name="CompanyName" />
          </Key>
          <Property Name="ShipperID" Type="Int32" Nullable="false" />
          <Property Name="CompanyName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Phone" Type="String" MaxLength="24" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="Supplier">
          <Key>
            <PropertyRef Name="SupplierID" />
            <PropertyRef Name="CompanyName" />
          </Key>
          <Property Name="SupplierID" Type="Int32" Nullable="false" />
          <Property Name="CompanyName" Type="String" MaxLength="40" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="ContactName" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="ContactTitle" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="Address" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
          <Property Name="City" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="Region" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="PostalCode" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Country" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="Phone" Type="String" MaxLength="24" FixedLength="false" Unicode="true" />
          <Property Name="Fax" Type="String" MaxLength="24" FixedLength="false" Unicode="true" />
          <Property Name="HomePage" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="Territory">
          <Key>
            <PropertyRef Name="TerritoryID" />
            <PropertyRef Name="TerritoryDescription" />
            <PropertyRef Name="RegionID" />
          </Key>
          <Property Name="TerritoryID" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="TerritoryDescription" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="RegionID" Type="Int32" Nullable="false" />
        </EntityType>
        <EntityContainer Name="C1NWindEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Categories" EntityType="Self.Category" />
          <EntitySet Name="Customers" EntityType="Self.Customer" />
          <EntitySet Name="Products" EntityType="Self.Product" />
          <EntitySet Name="Current_Product_Lists" EntityType="Self.Current_Product_List" />
          <EntitySet Name="Employees" EntityType="Self.Employee" />
          <EntitySet Name="EmployeeTerritories" EntityType="Self.EmployeeTerritory" />
          <EntitySet Name="Invoices" EntityType="Self.Invoice" />
          <EntitySet Name="Order_Details" EntityType="Self.Order_Detail" />
          <EntitySet Name="Orders" EntityType="Self.Order" />
          <EntitySet Name="Photos" EntityType="Self.Photo" />
          <EntitySet Name="Regions" EntityType="Self.Region" />
          <EntitySet Name="Sales_by_Categories" EntityType="Self.Sales_by_Category" />
          <EntitySet Name="Shippers" EntityType="Self.Shipper" />
          <EntitySet Name="Suppliers" EntityType="Self.Supplier" />
          <EntitySet Name="Territories" EntityType="Self.Territory" />
        </EntityContainer>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="C1NWindModelStoreContainer" CdmEntityContainer="C1NWindEntities">
          <EntitySetMapping Name="Categories">
            <EntityTypeMapping TypeName="C1NWindModel.Category">
              <MappingFragment StoreEntitySet="Categories">
                <ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
                <ScalarProperty Name="CategoryName" ColumnName="CategoryName" />
                <ScalarProperty Name="Description" ColumnName="Description" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Customers">
            <EntityTypeMapping TypeName="C1NWindModel.Customer">
              <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="Products">
            <EntityTypeMapping TypeName="C1NWindModel.Product">
              <MappingFragment StoreEntitySet="Products">
                <ScalarProperty Name="ProductID" ColumnName="ProductID" />
                <ScalarProperty Name="ProductName" ColumnName="ProductName" />
                <ScalarProperty Name="SupplierID" ColumnName="SupplierID" />
                <ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
                <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" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Current_Product_Lists">
            <EntityTypeMapping TypeName="C1NWindModel.Current_Product_List">
              <MappingFragment StoreEntitySet="Current Product List">
                <ScalarProperty Name="ProductID" ColumnName="ProductID" />
                <ScalarProperty Name="ProductName" ColumnName="ProductName" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Employees">
            <EntityTypeMapping TypeName="C1NWindModel.Employee">
              <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="ReportsTo" ColumnName="ReportsTo" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeTerritories">
            <EntityTypeMapping TypeName="C1NWindModel.EmployeeTerritory">
              <MappingFragment StoreEntitySet="EmployeeTerritories">
                <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
                <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Invoices">
            <EntityTypeMapping TypeName="C1NWindModel.Invoice">
              <MappingFragment StoreEntitySet="Invoices">
                <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" />
                <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
                <ScalarProperty Name="Customers_CompanyName" ColumnName="Customers.CompanyName" />
                <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="Salesperson" ColumnName="Salesperson" />
                <ScalarProperty Name="OrderID" ColumnName="OrderID" />
                <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
                <ScalarProperty Name="RequiredDate" ColumnName="RequiredDate" />
                <ScalarProperty Name="ShippedDate" ColumnName="ShippedDate" />
                <ScalarProperty Name="Shippers_CompanyName" ColumnName="Shippers.CompanyName" />
                <ScalarProperty Name="ProductID" ColumnName="ProductID" />
                <ScalarProperty Name="ProductName" ColumnName="ProductName" />
                <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
                <ScalarProperty Name="Quantity" ColumnName="Quantity" />
                <ScalarProperty Name="Discount" ColumnName="Discount" />
                <ScalarProperty Name="ExtendedPrice" ColumnName="ExtendedPrice" />
                <ScalarProperty Name="Freight" ColumnName="Freight" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Order_Details">
            <EntityTypeMapping TypeName="C1NWindModel.Order_Detail">
              <MappingFragment StoreEntitySet="Order Details">
                <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="C1NWindModel.Order">
              <MappingFragment StoreEntitySet="Orders">
                <ScalarProperty Name="OrderID" ColumnName="OrderID" />
                <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
                <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
                <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
                <ScalarProperty Name="RequiredDate" ColumnName="RequiredDate" />
                <ScalarProperty Name="ShippedDate" ColumnName="ShippedDate" />
                <ScalarProperty Name="ShipVia" ColumnName="ShipVia" />
                <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="Photos">
            <EntityTypeMapping TypeName="C1NWindModel.Photo">
              <MappingFragment StoreEntitySet="Photos">
                <ScalarProperty Name="PhotoID" ColumnName="PhotoID" />
                <ScalarProperty Name="Place" ColumnName="Place" />
                <ScalarProperty Name="Photo1" ColumnName="Photo" />
                <ScalarProperty Name="Author" ColumnName="Author" />
                <ScalarProperty Name="Country" ColumnName="Country" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Regions">
            <EntityTypeMapping TypeName="C1NWindModel.Region">
              <MappingFragment StoreEntitySet="Region">
                <ScalarProperty Name="RegionID" ColumnName="RegionID" />
                <ScalarProperty Name="RegionDescription" ColumnName="RegionDescription" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Sales_by_Categories">
            <EntityTypeMapping TypeName="C1NWindModel.Sales_by_Category">
              <MappingFragment StoreEntitySet="Sales by Category">
                <ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
                <ScalarProperty Name="CategoryName" ColumnName="CategoryName" />
                <ScalarProperty Name="ProductName" ColumnName="ProductName" />
                <ScalarProperty Name="ProductSales" ColumnName="ProductSales" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Shippers">
            <EntityTypeMapping TypeName="C1NWindModel.Shipper">
              <MappingFragment StoreEntitySet="Shippers">
                <ScalarProperty Name="ShipperID" ColumnName="ShipperID" />
                <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
                <ScalarProperty Name="Phone" ColumnName="Phone" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Suppliers">
            <EntityTypeMapping TypeName="C1NWindModel.Supplier">
              <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="C1NWindModel.Territory">
              <MappingFragment StoreEntitySet="Territories">
                <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
                <ScalarProperty Name="TerritoryDescription" ColumnName="TerritoryDescription" />
                <ScalarProperty Name="RegionID" ColumnName="RegionID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="true" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>