0
+ − 1 <?xml version="1.0" encoding="utf-8"?>
+ − 2 <edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
+ − 3 <!-- EF Runtime content -->
+ − 4 <edmx:Runtime>
+ − 5 <!-- SSDL content -->
+ − 6 <edmx:StorageModels>
+ − 7 <Schema Namespace="NorthwindModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
+ − 8 <EntityContainer Name="NorthwindModelStoreContainer">
+ − 9 <EntitySet Name="Categories" EntityType="NorthwindModel.Store.Categories" store:Type="Tables" Schema="dbo" />
+ − 10 <EntitySet Name="CustomerCustomerDemo" EntityType="NorthwindModel.Store.CustomerCustomerDemo" store:Type="Tables" Schema="dbo" />
+ − 11 <EntitySet Name="CustomerDemographics" EntityType="NorthwindModel.Store.CustomerDemographics" store:Type="Tables" Schema="dbo" />
+ − 12 <EntitySet Name="Customers" EntityType="NorthwindModel.Store.Customers" store:Type="Tables" Schema="dbo" />
+ − 13 <EntitySet Name="Employees" EntityType="NorthwindModel.Store.Employees" store:Type="Tables" Schema="dbo" />
+ − 14 <EntitySet Name="EmployeeTerritories" EntityType="NorthwindModel.Store.EmployeeTerritories" store:Type="Tables" Schema="dbo" />
+ − 15 <EntitySet Name="Order Details" EntityType="NorthwindModel.Store.Order Details" store:Type="Tables" Schema="dbo" />
+ − 16 <EntitySet Name="Orders" EntityType="NorthwindModel.Store.Orders" store:Type="Tables" Schema="dbo" />
+ − 17 <EntitySet Name="Products" EntityType="NorthwindModel.Store.Products" store:Type="Tables" Schema="dbo" />
+ − 18 <EntitySet Name="Region" EntityType="NorthwindModel.Store.Region" store:Type="Tables" Schema="dbo" />
+ − 19 <EntitySet Name="Shippers" EntityType="NorthwindModel.Store.Shippers" store:Type="Tables" Schema="dbo" />
+ − 20 <EntitySet Name="Suppliers" EntityType="NorthwindModel.Store.Suppliers" store:Type="Tables" Schema="dbo" />
+ − 21 <EntitySet Name="sysdiagrams" EntityType="NorthwindModel.Store.sysdiagrams" store:Type="Tables" Schema="dbo" />
+ − 22 <EntitySet Name="Territories" EntityType="NorthwindModel.Store.Territories" store:Type="Tables" Schema="dbo" />
+ − 23 <EntitySet Name="Alphabetical list of products" EntityType="NorthwindModel.Store.Alphabetical list of products" store:Type="Views" store:Schema="dbo" store:Name="Alphabetical list of products">
+ − 24 <DefiningQuery>SELECT
+ − 25 [Alphabetical list of products].[ProductID] AS [ProductID],
+ − 26 [Alphabetical list of products].[ProductName] AS [ProductName],
+ − 27 [Alphabetical list of products].[SupplierID] AS [SupplierID],
+ − 28 [Alphabetical list of products].[CategoryID] AS [CategoryID],
+ − 29 [Alphabetical list of products].[QuantityPerUnit] AS [QuantityPerUnit],
+ − 30 [Alphabetical list of products].[UnitPrice] AS [UnitPrice],
+ − 31 [Alphabetical list of products].[UnitsInStock] AS [UnitsInStock],
+ − 32 [Alphabetical list of products].[UnitsOnOrder] AS [UnitsOnOrder],
+ − 33 [Alphabetical list of products].[ReorderLevel] AS [ReorderLevel],
+ − 34 [Alphabetical list of products].[Discontinued] AS [Discontinued],
+ − 35 [Alphabetical list of products].[CategoryName] AS [CategoryName]
+ − 36 FROM [dbo].[Alphabetical list of products] AS [Alphabetical list of products]</DefiningQuery>
+ − 37 </EntitySet>
+ − 38 <EntitySet Name="Category Sales for 1997" EntityType="NorthwindModel.Store.Category Sales for 1997" store:Type="Views" store:Schema="dbo" store:Name="Category Sales for 1997">
+ − 39 <DefiningQuery>SELECT
+ − 40 [Category Sales for 1997].[CategoryName] AS [CategoryName],
+ − 41 [Category Sales for 1997].[CategorySales] AS [CategorySales]
+ − 42 FROM [dbo].[Category Sales for 1997] AS [Category Sales for 1997]</DefiningQuery>
+ − 43 </EntitySet>
+ − 44 <EntitySet Name="Current Product List" EntityType="NorthwindModel.Store.Current Product List" store:Type="Views" store:Schema="dbo" store:Name="Current Product List">
+ − 45 <DefiningQuery>SELECT
+ − 46 [Current Product List].[ProductID] AS [ProductID],
+ − 47 [Current Product List].[ProductName] AS [ProductName]
+ − 48 FROM [dbo].[Current Product List] AS [Current Product List]</DefiningQuery>
+ − 49 </EntitySet>
+ − 50 <EntitySet Name="Customer and Suppliers by City" EntityType="NorthwindModel.Store.Customer and Suppliers by City" store:Type="Views" store:Schema="dbo" store:Name="Customer and Suppliers by City">
+ − 51 <DefiningQuery>SELECT
+ − 52 [Customer and Suppliers by City].[City] AS [City],
+ − 53 [Customer and Suppliers by City].[CompanyName] AS [CompanyName],
+ − 54 [Customer and Suppliers by City].[ContactName] AS [ContactName],
+ − 55 [Customer and Suppliers by City].[Relationship] AS [Relationship]
+ − 56 FROM [dbo].[Customer and Suppliers by City] AS [Customer and Suppliers by City]</DefiningQuery>
+ − 57 </EntitySet>
+ − 58 <EntitySet Name="Invoices" EntityType="NorthwindModel.Store.Invoices" store:Type="Views" store:Schema="dbo" store:Name="Invoices">
+ − 59 <DefiningQuery>SELECT
+ − 60 [Invoices].[ShipName] AS [ShipName],
+ − 61 [Invoices].[ShipAddress] AS [ShipAddress],
+ − 62 [Invoices].[ShipCity] AS [ShipCity],
+ − 63 [Invoices].[ShipRegion] AS [ShipRegion],
+ − 64 [Invoices].[ShipPostalCode] AS [ShipPostalCode],
+ − 65 [Invoices].[ShipCountry] AS [ShipCountry],
+ − 66 [Invoices].[CustomerID] AS [CustomerID],
+ − 67 [Invoices].[CustomerName] AS [CustomerName],
+ − 68 [Invoices].[Address] AS [Address],
+ − 69 [Invoices].[City] AS [City],
+ − 70 [Invoices].[Region] AS [Region],
+ − 71 [Invoices].[PostalCode] AS [PostalCode],
+ − 72 [Invoices].[Country] AS [Country],
+ − 73 [Invoices].[Salesperson] AS [Salesperson],
+ − 74 [Invoices].[OrderID] AS [OrderID],
+ − 75 [Invoices].[OrderDate] AS [OrderDate],
+ − 76 [Invoices].[RequiredDate] AS [RequiredDate],
+ − 77 [Invoices].[ShippedDate] AS [ShippedDate],
+ − 78 [Invoices].[ShipperName] AS [ShipperName],
+ − 79 [Invoices].[ProductID] AS [ProductID],
+ − 80 [Invoices].[ProductName] AS [ProductName],
+ − 81 [Invoices].[UnitPrice] AS [UnitPrice],
+ − 82 [Invoices].[Quantity] AS [Quantity],
+ − 83 [Invoices].[Discount] AS [Discount],
+ − 84 [Invoices].[ExtendedPrice] AS [ExtendedPrice],
+ − 85 [Invoices].[Freight] AS [Freight]
+ − 86 FROM [dbo].[Invoices] AS [Invoices]</DefiningQuery>
+ − 87 </EntitySet>
+ − 88 <EntitySet Name="Order Details Extended" EntityType="NorthwindModel.Store.Order Details Extended" store:Type="Views" store:Schema="dbo" store:Name="Order Details Extended">
+ − 89 <DefiningQuery>SELECT
+ − 90 [Order Details Extended].[OrderID] AS [OrderID],
+ − 91 [Order Details Extended].[ProductID] AS [ProductID],
+ − 92 [Order Details Extended].[ProductName] AS [ProductName],
+ − 93 [Order Details Extended].[UnitPrice] AS [UnitPrice],
+ − 94 [Order Details Extended].[Quantity] AS [Quantity],
+ − 95 [Order Details Extended].[Discount] AS [Discount],
+ − 96 [Order Details Extended].[ExtendedPrice] AS [ExtendedPrice]
+ − 97 FROM [dbo].[Order Details Extended] AS [Order Details Extended]</DefiningQuery>
+ − 98 </EntitySet>
+ − 99 <EntitySet Name="Order Subtotals" EntityType="NorthwindModel.Store.Order Subtotals" store:Type="Views" store:Schema="dbo" store:Name="Order Subtotals">
+ − 100 <DefiningQuery>SELECT
+ − 101 [Order Subtotals].[OrderID] AS [OrderID],
+ − 102 [Order Subtotals].[Subtotal] AS [Subtotal]
+ − 103 FROM [dbo].[Order Subtotals] AS [Order Subtotals]</DefiningQuery>
+ − 104 </EntitySet>
+ − 105 <EntitySet Name="Orders Qry" EntityType="NorthwindModel.Store.Orders Qry" store:Type="Views" store:Schema="dbo" store:Name="Orders Qry">
+ − 106 <DefiningQuery>SELECT
+ − 107 [Orders Qry].[OrderID] AS [OrderID],
+ − 108 [Orders Qry].[CustomerID] AS [CustomerID],
+ − 109 [Orders Qry].[EmployeeID] AS [EmployeeID],
+ − 110 [Orders Qry].[OrderDate] AS [OrderDate],
+ − 111 [Orders Qry].[RequiredDate] AS [RequiredDate],
+ − 112 [Orders Qry].[ShippedDate] AS [ShippedDate],
+ − 113 [Orders Qry].[ShipVia] AS [ShipVia],
+ − 114 [Orders Qry].[Freight] AS [Freight],
+ − 115 [Orders Qry].[ShipName] AS [ShipName],
+ − 116 [Orders Qry].[ShipAddress] AS [ShipAddress],
+ − 117 [Orders Qry].[ShipCity] AS [ShipCity],
+ − 118 [Orders Qry].[ShipRegion] AS [ShipRegion],
+ − 119 [Orders Qry].[ShipPostalCode] AS [ShipPostalCode],
+ − 120 [Orders Qry].[ShipCountry] AS [ShipCountry],
+ − 121 [Orders Qry].[CompanyName] AS [CompanyName],
+ − 122 [Orders Qry].[Address] AS [Address],
+ − 123 [Orders Qry].[City] AS [City],
+ − 124 [Orders Qry].[Region] AS [Region],
+ − 125 [Orders Qry].[PostalCode] AS [PostalCode],
+ − 126 [Orders Qry].[Country] AS [Country]
+ − 127 FROM [dbo].[Orders Qry] AS [Orders Qry]</DefiningQuery>
+ − 128 </EntitySet>
+ − 129 <EntitySet Name="Product Sales for 1997" EntityType="NorthwindModel.Store.Product Sales for 1997" store:Type="Views" store:Schema="dbo" store:Name="Product Sales for 1997">
+ − 130 <DefiningQuery>SELECT
+ − 131 [Product Sales for 1997].[CategoryName] AS [CategoryName],
+ − 132 [Product Sales for 1997].[ProductName] AS [ProductName],
+ − 133 [Product Sales for 1997].[ProductSales] AS [ProductSales]
+ − 134 FROM [dbo].[Product Sales for 1997] AS [Product Sales for 1997]</DefiningQuery>
+ − 135 </EntitySet>
+ − 136 <EntitySet Name="Products Above Average Price" EntityType="NorthwindModel.Store.Products Above Average Price" store:Type="Views" store:Schema="dbo" store:Name="Products Above Average Price">
+ − 137 <DefiningQuery>SELECT
+ − 138 [Products Above Average Price].[ProductName] AS [ProductName],
+ − 139 [Products Above Average Price].[UnitPrice] AS [UnitPrice]
+ − 140 FROM [dbo].[Products Above Average Price] AS [Products Above Average Price]</DefiningQuery>
+ − 141 </EntitySet>
+ − 142 <EntitySet Name="Products by Category" EntityType="NorthwindModel.Store.Products by Category" store:Type="Views" store:Schema="dbo" store:Name="Products by Category">
+ − 143 <DefiningQuery>SELECT
+ − 144 [Products by Category].[CategoryName] AS [CategoryName],
+ − 145 [Products by Category].[ProductName] AS [ProductName],
+ − 146 [Products by Category].[QuantityPerUnit] AS [QuantityPerUnit],
+ − 147 [Products by Category].[UnitsInStock] AS [UnitsInStock],
+ − 148 [Products by Category].[Discontinued] AS [Discontinued]
+ − 149 FROM [dbo].[Products by Category] AS [Products by Category]</DefiningQuery>
+ − 150 </EntitySet>
+ − 151 <EntitySet Name="Sales by Category" EntityType="NorthwindModel.Store.Sales by Category" store:Type="Views" store:Schema="dbo" store:Name="Sales by Category">
+ − 152 <DefiningQuery>SELECT
+ − 153 [Sales by Category].[CategoryID] AS [CategoryID],
+ − 154 [Sales by Category].[CategoryName] AS [CategoryName],
+ − 155 [Sales by Category].[ProductName] AS [ProductName],
+ − 156 [Sales by Category].[ProductSales] AS [ProductSales]
+ − 157 FROM [dbo].[Sales by Category] AS [Sales by Category]</DefiningQuery>
+ − 158 </EntitySet>
+ − 159 <EntitySet Name="Sales Totals by Amount" EntityType="NorthwindModel.Store.Sales Totals by Amount" store:Type="Views" store:Schema="dbo" store:Name="Sales Totals by Amount">
+ − 160 <DefiningQuery>SELECT
+ − 161 [Sales Totals by Amount].[SaleAmount] AS [SaleAmount],
+ − 162 [Sales Totals by Amount].[OrderID] AS [OrderID],
+ − 163 [Sales Totals by Amount].[CompanyName] AS [CompanyName],
+ − 164 [Sales Totals by Amount].[ShippedDate] AS [ShippedDate]
+ − 165 FROM [dbo].[Sales Totals by Amount] AS [Sales Totals by Amount]</DefiningQuery>
+ − 166 </EntitySet>
+ − 167 <EntitySet Name="Summary of Sales by Quarter" EntityType="NorthwindModel.Store.Summary of Sales by Quarter" store:Type="Views" store:Schema="dbo" store:Name="Summary of Sales by Quarter">
+ − 168 <DefiningQuery>SELECT
+ − 169 [Summary of Sales by Quarter].[ShippedDate] AS [ShippedDate],
+ − 170 [Summary of Sales by Quarter].[OrderID] AS [OrderID],
+ − 171 [Summary of Sales by Quarter].[Subtotal] AS [Subtotal]
+ − 172 FROM [dbo].[Summary of Sales by Quarter] AS [Summary of Sales by Quarter]</DefiningQuery>
+ − 173 </EntitySet>
+ − 174 <EntitySet Name="Summary of Sales by Year" EntityType="NorthwindModel.Store.Summary of Sales by Year" store:Type="Views" store:Schema="dbo" store:Name="Summary of Sales by Year">
+ − 175 <DefiningQuery>SELECT
+ − 176 [Summary of Sales by Year].[ShippedDate] AS [ShippedDate],
+ − 177 [Summary of Sales by Year].[OrderID] AS [OrderID],
+ − 178 [Summary of Sales by Year].[Subtotal] AS [Subtotal]
+ − 179 FROM [dbo].[Summary of Sales by Year] AS [Summary of Sales by Year]</DefiningQuery>
+ − 180 </EntitySet>
+ − 181 <AssociationSet Name="FK_CustomerCustomerDemo" Association="NorthwindModel.Store.FK_CustomerCustomerDemo">
+ − 182 <End Role="CustomerDemographics" EntitySet="CustomerDemographics" />
+ − 183 <End Role="CustomerCustomerDemo" EntitySet="CustomerCustomerDemo" />
+ − 184 </AssociationSet>
+ − 185 <AssociationSet Name="FK_CustomerCustomerDemo_Customers" Association="NorthwindModel.Store.FK_CustomerCustomerDemo_Customers">
+ − 186 <End Role="Customers" EntitySet="Customers" />
+ − 187 <End Role="CustomerCustomerDemo" EntitySet="CustomerCustomerDemo" />
+ − 188 </AssociationSet>
+ − 189 <AssociationSet Name="FK_Employees_Employees" Association="NorthwindModel.Store.FK_Employees_Employees">
+ − 190 <End Role="Employees" EntitySet="Employees" />
+ − 191 <End Role="Employees1" EntitySet="Employees" />
+ − 192 </AssociationSet>
+ − 193 <AssociationSet Name="FK_EmployeeTerritories_Employees" Association="NorthwindModel.Store.FK_EmployeeTerritories_Employees">
+ − 194 <End Role="Employees" EntitySet="Employees" />
+ − 195 <End Role="EmployeeTerritories" EntitySet="EmployeeTerritories" />
+ − 196 </AssociationSet>
+ − 197 <AssociationSet Name="FK_EmployeeTerritories_Territories" Association="NorthwindModel.Store.FK_EmployeeTerritories_Territories">
+ − 198 <End Role="Territories" EntitySet="Territories" />
+ − 199 <End Role="EmployeeTerritories" EntitySet="EmployeeTerritories" />
+ − 200 </AssociationSet>
+ − 201 <AssociationSet Name="FK_Order_Details_Orders" Association="NorthwindModel.Store.FK_Order_Details_Orders">
+ − 202 <End Role="Orders" EntitySet="Orders" />
+ − 203 <End Role="Order Details" EntitySet="Order Details" />
+ − 204 </AssociationSet>
+ − 205 <AssociationSet Name="FK_Order_Details_Products" Association="NorthwindModel.Store.FK_Order_Details_Products">
+ − 206 <End Role="Products" EntitySet="Products" />
+ − 207 <End Role="Order Details" EntitySet="Order Details" />
+ − 208 </AssociationSet>
+ − 209 <AssociationSet Name="FK_Orders_Customers" Association="NorthwindModel.Store.FK_Orders_Customers">
+ − 210 <End Role="Customers" EntitySet="Customers" />
+ − 211 <End Role="Orders" EntitySet="Orders" />
+ − 212 </AssociationSet>
+ − 213 <AssociationSet Name="FK_Orders_Employees" Association="NorthwindModel.Store.FK_Orders_Employees">
+ − 214 <End Role="Employees" EntitySet="Employees" />
+ − 215 <End Role="Orders" EntitySet="Orders" />
+ − 216 </AssociationSet>
+ − 217 <AssociationSet Name="FK_Orders_Shippers" Association="NorthwindModel.Store.FK_Orders_Shippers">
+ − 218 <End Role="Shippers" EntitySet="Shippers" />
+ − 219 <End Role="Orders" EntitySet="Orders" />
+ − 220 </AssociationSet>
+ − 221 <AssociationSet Name="FK_Products_Categories" Association="NorthwindModel.Store.FK_Products_Categories">
+ − 222 <End Role="Categories" EntitySet="Categories" />
+ − 223 <End Role="Products" EntitySet="Products" />
+ − 224 </AssociationSet>
+ − 225 <AssociationSet Name="FK_Products_Suppliers" Association="NorthwindModel.Store.FK_Products_Suppliers">
+ − 226 <End Role="Suppliers" EntitySet="Suppliers" />
+ − 227 <End Role="Products" EntitySet="Products" />
+ − 228 </AssociationSet>
+ − 229 <AssociationSet Name="FK_Territories_Region" Association="NorthwindModel.Store.FK_Territories_Region">
+ − 230 <End Role="Region" EntitySet="Region" />
+ − 231 <End Role="Territories" EntitySet="Territories" />
+ − 232 </AssociationSet>
+ − 233 </EntityContainer>
+ − 234 <EntityType Name="Categories">
+ − 235 <Key>
+ − 236 <PropertyRef Name="CategoryID" />
+ − 237 </Key>
+ − 238 <Property Name="CategoryID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
+ − 239 <Property Name="CategoryName" Type="nvarchar" Nullable="false" MaxLength="15" />
+ − 240 <Property Name="Description" Type="ntext" />
+ − 241 <Property Name="Picture" Type="image" />
+ − 242 </EntityType>
+ − 243 <EntityType Name="CustomerCustomerDemo">
+ − 244 <Key>
+ − 245 <PropertyRef Name="CustomerID" />
+ − 246 <PropertyRef Name="CustomerTypeID" />
+ − 247 </Key>
+ − 248 <Property Name="CustomerID" Type="nchar" Nullable="false" MaxLength="5" />
+ − 249 <Property Name="CustomerTypeID" Type="nchar" Nullable="false" MaxLength="10" />
+ − 250 </EntityType>
+ − 251 <EntityType Name="CustomerDemographics">
+ − 252 <Key>
+ − 253 <PropertyRef Name="CustomerTypeID" />
+ − 254 </Key>
+ − 255 <Property Name="CustomerTypeID" Type="nchar" Nullable="false" MaxLength="10" />
+ − 256 <Property Name="CustomerDesc" Type="ntext" />
+ − 257 </EntityType>
+ − 258 <EntityType Name="Customers">
+ − 259 <Key>
+ − 260 <PropertyRef Name="CustomerID" />
+ − 261 </Key>
+ − 262 <Property Name="CustomerID" Type="nchar" Nullable="false" MaxLength="5" />
+ − 263 <Property Name="CompanyName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 264 <Property Name="ContactName" Type="nvarchar" MaxLength="30" />
+ − 265 <Property Name="ContactTitle" Type="nvarchar" MaxLength="30" />
+ − 266 <Property Name="Address" Type="nvarchar" MaxLength="60" />
+ − 267 <Property Name="City" Type="nvarchar" MaxLength="15" />
+ − 268 <Property Name="Region" Type="nvarchar" MaxLength="15" />
+ − 269 <Property Name="PostalCode" Type="nvarchar" MaxLength="10" />
+ − 270 <Property Name="Country" Type="nvarchar" MaxLength="15" />
+ − 271 <Property Name="Phone" Type="nvarchar" MaxLength="24" />
+ − 272 <Property Name="Fax" Type="nvarchar" MaxLength="24" />
+ − 273 </EntityType>
+ − 274 <EntityType Name="Employees">
+ − 275 <Key>
+ − 276 <PropertyRef Name="EmployeeID" />
+ − 277 </Key>
+ − 278 <Property Name="EmployeeID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
+ − 279 <Property Name="LastName" Type="nvarchar" Nullable="false" MaxLength="20" />
+ − 280 <Property Name="FirstName" Type="nvarchar" Nullable="false" MaxLength="10" />
+ − 281 <Property Name="Title" Type="nvarchar" MaxLength="30" />
+ − 282 <Property Name="TitleOfCourtesy" Type="nvarchar" MaxLength="25" />
+ − 283 <Property Name="BirthDate" Type="datetime" />
+ − 284 <Property Name="HireDate" Type="datetime" />
+ − 285 <Property Name="Address" Type="nvarchar" MaxLength="60" />
+ − 286 <Property Name="City" Type="nvarchar" MaxLength="15" />
+ − 287 <Property Name="Region" Type="nvarchar" MaxLength="15" />
+ − 288 <Property Name="PostalCode" Type="nvarchar" MaxLength="10" />
+ − 289 <Property Name="Country" Type="nvarchar" MaxLength="15" />
+ − 290 <Property Name="HomePhone" Type="nvarchar" MaxLength="24" />
+ − 291 <Property Name="Extension" Type="nvarchar" MaxLength="4" />
+ − 292 <Property Name="Photo" Type="image" />
+ − 293 <Property Name="Notes" Type="ntext" />
+ − 294 <Property Name="ReportsTo" Type="int" />
+ − 295 <Property Name="PhotoPath" Type="nvarchar" MaxLength="255" />
+ − 296 </EntityType>
+ − 297 <EntityType Name="EmployeeTerritories">
+ − 298 <Key>
+ − 299 <PropertyRef Name="EmployeeID" />
+ − 300 <PropertyRef Name="TerritoryID" />
+ − 301 </Key>
+ − 302 <Property Name="EmployeeID" Type="int" Nullable="false" />
+ − 303 <Property Name="TerritoryID" Type="nvarchar" Nullable="false" MaxLength="20" />
+ − 304 </EntityType>
+ − 305 <EntityType Name="Order Details">
+ − 306 <Key>
+ − 307 <PropertyRef Name="OrderID" />
+ − 308 <PropertyRef Name="ProductID" />
+ − 309 </Key>
+ − 310 <Property Name="OrderID" Type="int" Nullable="false" />
+ − 311 <Property Name="ProductID" Type="int" Nullable="false" />
+ − 312 <Property Name="UnitPrice" Type="money" Nullable="false" />
+ − 313 <Property Name="Quantity" Type="smallint" Nullable="false" />
+ − 314 <Property Name="Discount" Type="real" Nullable="false" />
+ − 315 </EntityType>
+ − 316 <EntityType Name="Orders">
+ − 317 <Key>
+ − 318 <PropertyRef Name="OrderID" />
+ − 319 </Key>
+ − 320 <Property Name="OrderID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
+ − 321 <Property Name="CustomerID" Type="nchar" MaxLength="5" />
+ − 322 <Property Name="EmployeeID" Type="int" />
+ − 323 <Property Name="OrderDate" Type="datetime" />
+ − 324 <Property Name="RequiredDate" Type="datetime" />
+ − 325 <Property Name="ShippedDate" Type="datetime" />
+ − 326 <Property Name="ShipVia" Type="int" />
+ − 327 <Property Name="Freight" Type="money" />
+ − 328 <Property Name="ShipName" Type="nvarchar" MaxLength="40" />
+ − 329 <Property Name="ShipAddress" Type="nvarchar" MaxLength="60" />
+ − 330 <Property Name="ShipCity" Type="nvarchar" MaxLength="15" />
+ − 331 <Property Name="ShipRegion" Type="nvarchar" MaxLength="15" />
+ − 332 <Property Name="ShipPostalCode" Type="nvarchar" MaxLength="10" />
+ − 333 <Property Name="ShipCountry" Type="nvarchar" MaxLength="15" />
+ − 334 </EntityType>
+ − 335 <EntityType Name="Products">
+ − 336 <Key>
+ − 337 <PropertyRef Name="ProductID" />
+ − 338 </Key>
+ − 339 <Property Name="ProductID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
+ − 340 <Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 341 <Property Name="SupplierID" Type="int" />
+ − 342 <Property Name="CategoryID" Type="int" />
+ − 343 <Property Name="QuantityPerUnit" Type="nvarchar" MaxLength="20" />
+ − 344 <Property Name="UnitPrice" Type="money" />
+ − 345 <Property Name="UnitsInStock" Type="smallint" />
+ − 346 <Property Name="UnitsOnOrder" Type="smallint" />
+ − 347 <Property Name="ReorderLevel" Type="smallint" />
+ − 348 <Property Name="Discontinued" Type="bit" Nullable="false" />
+ − 349 </EntityType>
+ − 350 <EntityType Name="Region">
+ − 351 <Key>
+ − 352 <PropertyRef Name="RegionID" />
+ − 353 </Key>
+ − 354 <Property Name="RegionID" Type="int" Nullable="false" />
+ − 355 <Property Name="RegionDescription" Type="nchar" Nullable="false" MaxLength="50" />
+ − 356 </EntityType>
+ − 357 <EntityType Name="Shippers">
+ − 358 <Key>
+ − 359 <PropertyRef Name="ShipperID" />
+ − 360 </Key>
+ − 361 <Property Name="ShipperID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
+ − 362 <Property Name="CompanyName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 363 <Property Name="Phone" Type="nvarchar" MaxLength="24" />
+ − 364 </EntityType>
+ − 365 <EntityType Name="Suppliers">
+ − 366 <Key>
+ − 367 <PropertyRef Name="SupplierID" />
+ − 368 </Key>
+ − 369 <Property Name="SupplierID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
+ − 370 <Property Name="CompanyName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 371 <Property Name="ContactName" Type="nvarchar" MaxLength="30" />
+ − 372 <Property Name="ContactTitle" Type="nvarchar" MaxLength="30" />
+ − 373 <Property Name="Address" Type="nvarchar" MaxLength="60" />
+ − 374 <Property Name="City" Type="nvarchar" MaxLength="15" />
+ − 375 <Property Name="Region" Type="nvarchar" MaxLength="15" />
+ − 376 <Property Name="PostalCode" Type="nvarchar" MaxLength="10" />
+ − 377 <Property Name="Country" Type="nvarchar" MaxLength="15" />
+ − 378 <Property Name="Phone" Type="nvarchar" MaxLength="24" />
+ − 379 <Property Name="Fax" Type="nvarchar" MaxLength="24" />
+ − 380 <Property Name="HomePage" Type="ntext" />
+ − 381 </EntityType>
+ − 382 <EntityType Name="sysdiagrams">
+ − 383 <Key>
+ − 384 <PropertyRef Name="diagram_id" />
+ − 385 </Key>
+ − 386 <Property Name="name" Type="nvarchar" Nullable="false" MaxLength="128" />
+ − 387 <Property Name="principal_id" Type="int" Nullable="false" />
+ − 388 <Property Name="diagram_id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
+ − 389 <Property Name="version" Type="int" />
+ − 390 <Property Name="definition" Type="varbinary(max)" />
+ − 391 </EntityType>
+ − 392 <EntityType Name="Territories">
+ − 393 <Key>
+ − 394 <PropertyRef Name="TerritoryID" />
+ − 395 </Key>
+ − 396 <Property Name="TerritoryID" Type="nvarchar" Nullable="false" MaxLength="20" />
+ − 397 <Property Name="TerritoryDescription" Type="nchar" Nullable="false" MaxLength="50" />
+ − 398 <Property Name="RegionID" Type="int" Nullable="false" />
+ − 399 </EntityType>
+ − 400 <!--Errors Found During Generation:
+ − 401 warning 6002: The table/view 'Northwind.dbo.Alphabetical list of products' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 402 -->
+ − 403 <EntityType Name="Alphabetical list of products">
+ − 404 <Key>
+ − 405 <PropertyRef Name="ProductID" />
+ − 406 <PropertyRef Name="ProductName" />
+ − 407 <PropertyRef Name="Discontinued" />
+ − 408 <PropertyRef Name="CategoryName" />
+ − 409 </Key>
+ − 410 <Property Name="ProductID" Type="int" Nullable="false" />
+ − 411 <Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 412 <Property Name="SupplierID" Type="int" />
+ − 413 <Property Name="CategoryID" Type="int" />
+ − 414 <Property Name="QuantityPerUnit" Type="nvarchar" MaxLength="20" />
+ − 415 <Property Name="UnitPrice" Type="money" />
+ − 416 <Property Name="UnitsInStock" Type="smallint" />
+ − 417 <Property Name="UnitsOnOrder" Type="smallint" />
+ − 418 <Property Name="ReorderLevel" Type="smallint" />
+ − 419 <Property Name="Discontinued" Type="bit" Nullable="false" />
+ − 420 <Property Name="CategoryName" Type="nvarchar" Nullable="false" MaxLength="15" />
+ − 421 </EntityType>
+ − 422 <!--Errors Found During Generation:
+ − 423 warning 6002: The table/view 'Northwind.dbo.Category Sales for 1997' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 424 -->
+ − 425 <EntityType Name="Category Sales for 1997">
+ − 426 <Key>
+ − 427 <PropertyRef Name="CategoryName" />
+ − 428 </Key>
+ − 429 <Property Name="CategoryName" Type="nvarchar" Nullable="false" MaxLength="15" />
+ − 430 <Property Name="CategorySales" Type="money" />
+ − 431 </EntityType>
+ − 432 <!--Errors Found During Generation:
+ − 433 warning 6002: The table/view 'Northwind.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.
+ − 434 -->
+ − 435 <EntityType Name="Current Product List">
+ − 436 <Key>
+ − 437 <PropertyRef Name="ProductID" />
+ − 438 <PropertyRef Name="ProductName" />
+ − 439 </Key>
+ − 440 <Property Name="ProductID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
+ − 441 <Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 442 </EntityType>
+ − 443 <!--Errors Found During Generation:
+ − 444 warning 6002: The table/view 'Northwind.dbo.Customer and Suppliers by City' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 445 -->
+ − 446 <EntityType Name="Customer and Suppliers by City">
+ − 447 <Key>
+ − 448 <PropertyRef Name="CompanyName" />
+ − 449 <PropertyRef Name="Relationship" />
+ − 450 </Key>
+ − 451 <Property Name="City" Type="nvarchar" MaxLength="15" />
+ − 452 <Property Name="CompanyName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 453 <Property Name="ContactName" Type="nvarchar" MaxLength="30" />
+ − 454 <Property Name="Relationship" Type="varchar" Nullable="false" MaxLength="9" />
+ − 455 </EntityType>
+ − 456 <!--Errors Found During Generation:
+ − 457 warning 6002: The table/view 'Northwind.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.
+ − 458 -->
+ − 459 <EntityType Name="Invoices">
+ − 460 <Key>
+ − 461 <PropertyRef Name="CustomerName" />
+ − 462 <PropertyRef Name="Salesperson" />
+ − 463 <PropertyRef Name="OrderID" />
+ − 464 <PropertyRef Name="ShipperName" />
+ − 465 <PropertyRef Name="ProductID" />
+ − 466 <PropertyRef Name="ProductName" />
+ − 467 <PropertyRef Name="UnitPrice" />
+ − 468 <PropertyRef Name="Quantity" />
+ − 469 <PropertyRef Name="Discount" />
+ − 470 </Key>
+ − 471 <Property Name="ShipName" Type="nvarchar" MaxLength="40" />
+ − 472 <Property Name="ShipAddress" Type="nvarchar" MaxLength="60" />
+ − 473 <Property Name="ShipCity" Type="nvarchar" MaxLength="15" />
+ − 474 <Property Name="ShipRegion" Type="nvarchar" MaxLength="15" />
+ − 475 <Property Name="ShipPostalCode" Type="nvarchar" MaxLength="10" />
+ − 476 <Property Name="ShipCountry" Type="nvarchar" MaxLength="15" />
+ − 477 <Property Name="CustomerID" Type="nchar" MaxLength="5" />
+ − 478 <Property Name="CustomerName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 479 <Property Name="Address" Type="nvarchar" MaxLength="60" />
+ − 480 <Property Name="City" Type="nvarchar" MaxLength="15" />
+ − 481 <Property Name="Region" Type="nvarchar" MaxLength="15" />
+ − 482 <Property Name="PostalCode" Type="nvarchar" MaxLength="10" />
+ − 483 <Property Name="Country" Type="nvarchar" MaxLength="15" />
+ − 484 <Property Name="Salesperson" Type="nvarchar" Nullable="false" MaxLength="31" />
+ − 485 <Property Name="OrderID" Type="int" Nullable="false" />
+ − 486 <Property Name="OrderDate" Type="datetime" />
+ − 487 <Property Name="RequiredDate" Type="datetime" />
+ − 488 <Property Name="ShippedDate" Type="datetime" />
+ − 489 <Property Name="ShipperName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 490 <Property Name="ProductID" Type="int" Nullable="false" />
+ − 491 <Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 492 <Property Name="UnitPrice" Type="money" Nullable="false" />
+ − 493 <Property Name="Quantity" Type="smallint" Nullable="false" />
+ − 494 <Property Name="Discount" Type="real" Nullable="false" />
+ − 495 <Property Name="ExtendedPrice" Type="money" />
+ − 496 <Property Name="Freight" Type="money" />
+ − 497 </EntityType>
+ − 498 <!--Errors Found During Generation:
+ − 499 warning 6002: The table/view 'Northwind.dbo.Order Details Extended' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 500 -->
+ − 501 <EntityType Name="Order Details Extended">
+ − 502 <Key>
+ − 503 <PropertyRef Name="OrderID" />
+ − 504 <PropertyRef Name="ProductID" />
+ − 505 <PropertyRef Name="ProductName" />
+ − 506 <PropertyRef Name="UnitPrice" />
+ − 507 <PropertyRef Name="Quantity" />
+ − 508 <PropertyRef Name="Discount" />
+ − 509 </Key>
+ − 510 <Property Name="OrderID" Type="int" Nullable="false" />
+ − 511 <Property Name="ProductID" Type="int" Nullable="false" />
+ − 512 <Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 513 <Property Name="UnitPrice" Type="money" Nullable="false" />
+ − 514 <Property Name="Quantity" Type="smallint" Nullable="false" />
+ − 515 <Property Name="Discount" Type="real" Nullable="false" />
+ − 516 <Property Name="ExtendedPrice" Type="money" />
+ − 517 </EntityType>
+ − 518 <!--Errors Found During Generation:
+ − 519 warning 6002: The table/view 'Northwind.dbo.Order Subtotals' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 520 -->
+ − 521 <EntityType Name="Order Subtotals">
+ − 522 <Key>
+ − 523 <PropertyRef Name="OrderID" />
+ − 524 </Key>
+ − 525 <Property Name="OrderID" Type="int" Nullable="false" />
+ − 526 <Property Name="Subtotal" Type="money" />
+ − 527 </EntityType>
+ − 528 <!--Errors Found During Generation:
+ − 529 warning 6002: The table/view 'Northwind.dbo.Orders Qry' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 530 -->
+ − 531 <EntityType Name="Orders Qry">
+ − 532 <Key>
+ − 533 <PropertyRef Name="OrderID" />
+ − 534 <PropertyRef Name="CompanyName" />
+ − 535 </Key>
+ − 536 <Property Name="OrderID" Type="int" Nullable="false" />
+ − 537 <Property Name="CustomerID" Type="nchar" MaxLength="5" />
+ − 538 <Property Name="EmployeeID" Type="int" />
+ − 539 <Property Name="OrderDate" Type="datetime" />
+ − 540 <Property Name="RequiredDate" Type="datetime" />
+ − 541 <Property Name="ShippedDate" Type="datetime" />
+ − 542 <Property Name="ShipVia" Type="int" />
+ − 543 <Property Name="Freight" Type="money" />
+ − 544 <Property Name="ShipName" Type="nvarchar" MaxLength="40" />
+ − 545 <Property Name="ShipAddress" Type="nvarchar" MaxLength="60" />
+ − 546 <Property Name="ShipCity" Type="nvarchar" MaxLength="15" />
+ − 547 <Property Name="ShipRegion" Type="nvarchar" MaxLength="15" />
+ − 548 <Property Name="ShipPostalCode" Type="nvarchar" MaxLength="10" />
+ − 549 <Property Name="ShipCountry" Type="nvarchar" MaxLength="15" />
+ − 550 <Property Name="CompanyName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 551 <Property Name="Address" Type="nvarchar" MaxLength="60" />
+ − 552 <Property Name="City" Type="nvarchar" MaxLength="15" />
+ − 553 <Property Name="Region" Type="nvarchar" MaxLength="15" />
+ − 554 <Property Name="PostalCode" Type="nvarchar" MaxLength="10" />
+ − 555 <Property Name="Country" Type="nvarchar" MaxLength="15" />
+ − 556 </EntityType>
+ − 557 <!--Errors Found During Generation:
+ − 558 warning 6002: The table/view 'Northwind.dbo.Product Sales for 1997' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 559 -->
+ − 560 <EntityType Name="Product Sales for 1997">
+ − 561 <Key>
+ − 562 <PropertyRef Name="CategoryName" />
+ − 563 <PropertyRef Name="ProductName" />
+ − 564 </Key>
+ − 565 <Property Name="CategoryName" Type="nvarchar" Nullable="false" MaxLength="15" />
+ − 566 <Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 567 <Property Name="ProductSales" Type="money" />
+ − 568 </EntityType>
+ − 569 <!--Errors Found During Generation:
+ − 570 warning 6002: The table/view 'Northwind.dbo.Products Above Average Price' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 571 -->
+ − 572 <EntityType Name="Products Above Average Price">
+ − 573 <Key>
+ − 574 <PropertyRef Name="ProductName" />
+ − 575 </Key>
+ − 576 <Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 577 <Property Name="UnitPrice" Type="money" />
+ − 578 </EntityType>
+ − 579 <!--Errors Found During Generation:
+ − 580 warning 6002: The table/view 'Northwind.dbo.Products 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.
+ − 581 -->
+ − 582 <EntityType Name="Products by Category">
+ − 583 <Key>
+ − 584 <PropertyRef Name="CategoryName" />
+ − 585 <PropertyRef Name="ProductName" />
+ − 586 <PropertyRef Name="Discontinued" />
+ − 587 </Key>
+ − 588 <Property Name="CategoryName" Type="nvarchar" Nullable="false" MaxLength="15" />
+ − 589 <Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 590 <Property Name="QuantityPerUnit" Type="nvarchar" MaxLength="20" />
+ − 591 <Property Name="UnitsInStock" Type="smallint" />
+ − 592 <Property Name="Discontinued" Type="bit" Nullable="false" />
+ − 593 </EntityType>
+ − 594 <!--Errors Found During Generation:
+ − 595 warning 6002: The table/view 'Northwind.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.
+ − 596 -->
+ − 597 <EntityType Name="Sales by Category">
+ − 598 <Key>
+ − 599 <PropertyRef Name="CategoryID" />
+ − 600 <PropertyRef Name="CategoryName" />
+ − 601 <PropertyRef Name="ProductName" />
+ − 602 </Key>
+ − 603 <Property Name="CategoryID" Type="int" Nullable="false" />
+ − 604 <Property Name="CategoryName" Type="nvarchar" Nullable="false" MaxLength="15" />
+ − 605 <Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 606 <Property Name="ProductSales" Type="money" />
+ − 607 </EntityType>
+ − 608 <!--Errors Found During Generation:
+ − 609 warning 6002: The table/view 'Northwind.dbo.Sales Totals by Amount' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 610 -->
+ − 611 <EntityType Name="Sales Totals by Amount">
+ − 612 <Key>
+ − 613 <PropertyRef Name="OrderID" />
+ − 614 <PropertyRef Name="CompanyName" />
+ − 615 </Key>
+ − 616 <Property Name="SaleAmount" Type="money" />
+ − 617 <Property Name="OrderID" Type="int" Nullable="false" />
+ − 618 <Property Name="CompanyName" Type="nvarchar" Nullable="false" MaxLength="40" />
+ − 619 <Property Name="ShippedDate" Type="datetime" />
+ − 620 </EntityType>
+ − 621 <!--Errors Found During Generation:
+ − 622 warning 6002: The table/view 'Northwind.dbo.Summary of Sales by Quarter' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 623 -->
+ − 624 <EntityType Name="Summary of Sales by Quarter">
+ − 625 <Key>
+ − 626 <PropertyRef Name="OrderID" />
+ − 627 </Key>
+ − 628 <Property Name="ShippedDate" Type="datetime" />
+ − 629 <Property Name="OrderID" Type="int" Nullable="false" />
+ − 630 <Property Name="Subtotal" Type="money" />
+ − 631 </EntityType>
+ − 632 <!--Errors Found During Generation:
+ − 633 warning 6002: The table/view 'Northwind.dbo.Summary of Sales by Year' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
+ − 634 -->
+ − 635 <EntityType Name="Summary of Sales by Year">
+ − 636 <Key>
+ − 637 <PropertyRef Name="OrderID" />
+ − 638 </Key>
+ − 639 <Property Name="ShippedDate" Type="datetime" />
+ − 640 <Property Name="OrderID" Type="int" Nullable="false" />
+ − 641 <Property Name="Subtotal" Type="money" />
+ − 642 </EntityType>
+ − 643 <Association Name="FK_CustomerCustomerDemo">
+ − 644 <End Role="CustomerDemographics" Type="NorthwindModel.Store.CustomerDemographics" Multiplicity="1" />
+ − 645 <End Role="CustomerCustomerDemo" Type="NorthwindModel.Store.CustomerCustomerDemo" Multiplicity="*" />
+ − 646 <ReferentialConstraint>
+ − 647 <Principal Role="CustomerDemographics">
+ − 648 <PropertyRef Name="CustomerTypeID" />
+ − 649 </Principal>
+ − 650 <Dependent Role="CustomerCustomerDemo">
+ − 651 <PropertyRef Name="CustomerTypeID" />
+ − 652 </Dependent>
+ − 653 </ReferentialConstraint>
+ − 654 </Association>
+ − 655 <Association Name="FK_CustomerCustomerDemo_Customers">
+ − 656 <End Role="Customers" Type="NorthwindModel.Store.Customers" Multiplicity="1" />
+ − 657 <End Role="CustomerCustomerDemo" Type="NorthwindModel.Store.CustomerCustomerDemo" Multiplicity="*" />
+ − 658 <ReferentialConstraint>
+ − 659 <Principal Role="Customers">
+ − 660 <PropertyRef Name="CustomerID" />
+ − 661 </Principal>
+ − 662 <Dependent Role="CustomerCustomerDemo">
+ − 663 <PropertyRef Name="CustomerID" />
+ − 664 </Dependent>
+ − 665 </ReferentialConstraint>
+ − 666 </Association>
+ − 667 <Association Name="FK_Employees_Employees">
+ − 668 <End Role="Employees" Type="NorthwindModel.Store.Employees" Multiplicity="0..1" />
+ − 669 <End Role="Employees1" Type="NorthwindModel.Store.Employees" Multiplicity="*" />
+ − 670 <ReferentialConstraint>
+ − 671 <Principal Role="Employees">
+ − 672 <PropertyRef Name="EmployeeID" />
+ − 673 </Principal>
+ − 674 <Dependent Role="Employees1">
+ − 675 <PropertyRef Name="ReportsTo" />
+ − 676 </Dependent>
+ − 677 </ReferentialConstraint>
+ − 678 </Association>
+ − 679 <Association Name="FK_EmployeeTerritories_Employees">
+ − 680 <End Role="Employees" Type="NorthwindModel.Store.Employees" Multiplicity="1" />
+ − 681 <End Role="EmployeeTerritories" Type="NorthwindModel.Store.EmployeeTerritories" Multiplicity="*" />
+ − 682 <ReferentialConstraint>
+ − 683 <Principal Role="Employees">
+ − 684 <PropertyRef Name="EmployeeID" />
+ − 685 </Principal>
+ − 686 <Dependent Role="EmployeeTerritories">
+ − 687 <PropertyRef Name="EmployeeID" />
+ − 688 </Dependent>
+ − 689 </ReferentialConstraint>
+ − 690 </Association>
+ − 691 <Association Name="FK_EmployeeTerritories_Territories">
+ − 692 <End Role="Territories" Type="NorthwindModel.Store.Territories" Multiplicity="1" />
+ − 693 <End Role="EmployeeTerritories" Type="NorthwindModel.Store.EmployeeTerritories" Multiplicity="*" />
+ − 694 <ReferentialConstraint>
+ − 695 <Principal Role="Territories">
+ − 696 <PropertyRef Name="TerritoryID" />
+ − 697 </Principal>
+ − 698 <Dependent Role="EmployeeTerritories">
+ − 699 <PropertyRef Name="TerritoryID" />
+ − 700 </Dependent>
+ − 701 </ReferentialConstraint>
+ − 702 </Association>
+ − 703 <Association Name="FK_Order_Details_Orders">
+ − 704 <End Role="Orders" Type="NorthwindModel.Store.Orders" Multiplicity="1" />
+ − 705 <End Role="Order Details" Type="NorthwindModel.Store.Order Details" Multiplicity="*" />
+ − 706 <ReferentialConstraint>
+ − 707 <Principal Role="Orders">
+ − 708 <PropertyRef Name="OrderID" />
+ − 709 </Principal>
+ − 710 <Dependent Role="Order Details">
+ − 711 <PropertyRef Name="OrderID" />
+ − 712 </Dependent>
+ − 713 </ReferentialConstraint>
+ − 714 </Association>
+ − 715 <Association Name="FK_Order_Details_Products">
+ − 716 <End Role="Products" Type="NorthwindModel.Store.Products" Multiplicity="1" />
+ − 717 <End Role="Order Details" Type="NorthwindModel.Store.Order Details" Multiplicity="*" />
+ − 718 <ReferentialConstraint>
+ − 719 <Principal Role="Products">
+ − 720 <PropertyRef Name="ProductID" />
+ − 721 </Principal>
+ − 722 <Dependent Role="Order Details">
+ − 723 <PropertyRef Name="ProductID" />
+ − 724 </Dependent>
+ − 725 </ReferentialConstraint>
+ − 726 </Association>
+ − 727 <Association Name="FK_Orders_Customers">
+ − 728 <End Role="Customers" Type="NorthwindModel.Store.Customers" Multiplicity="0..1" />
+ − 729 <End Role="Orders" Type="NorthwindModel.Store.Orders" Multiplicity="*" />
+ − 730 <ReferentialConstraint>
+ − 731 <Principal Role="Customers">
+ − 732 <PropertyRef Name="CustomerID" />
+ − 733 </Principal>
+ − 734 <Dependent Role="Orders">
+ − 735 <PropertyRef Name="CustomerID" />
+ − 736 </Dependent>
+ − 737 </ReferentialConstraint>
+ − 738 </Association>
+ − 739 <Association Name="FK_Orders_Employees">
+ − 740 <End Role="Employees" Type="NorthwindModel.Store.Employees" Multiplicity="0..1" />
+ − 741 <End Role="Orders" Type="NorthwindModel.Store.Orders" Multiplicity="*" />
+ − 742 <ReferentialConstraint>
+ − 743 <Principal Role="Employees">
+ − 744 <PropertyRef Name="EmployeeID" />
+ − 745 </Principal>
+ − 746 <Dependent Role="Orders">
+ − 747 <PropertyRef Name="EmployeeID" />
+ − 748 </Dependent>
+ − 749 </ReferentialConstraint>
+ − 750 </Association>
+ − 751 <Association Name="FK_Orders_Shippers">
+ − 752 <End Role="Shippers" Type="NorthwindModel.Store.Shippers" Multiplicity="0..1" />
+ − 753 <End Role="Orders" Type="NorthwindModel.Store.Orders" Multiplicity="*" />
+ − 754 <ReferentialConstraint>
+ − 755 <Principal Role="Shippers">
+ − 756 <PropertyRef Name="ShipperID" />
+ − 757 </Principal>
+ − 758 <Dependent Role="Orders">
+ − 759 <PropertyRef Name="ShipVia" />
+ − 760 </Dependent>
+ − 761 </ReferentialConstraint>
+ − 762 </Association>
+ − 763 <Association Name="FK_Products_Categories">
+ − 764 <End Role="Categories" Type="NorthwindModel.Store.Categories" Multiplicity="0..1" />
+ − 765 <End Role="Products" Type="NorthwindModel.Store.Products" Multiplicity="*" />
+ − 766 <ReferentialConstraint>
+ − 767 <Principal Role="Categories">
+ − 768 <PropertyRef Name="CategoryID" />
+ − 769 </Principal>
+ − 770 <Dependent Role="Products">
+ − 771 <PropertyRef Name="CategoryID" />
+ − 772 </Dependent>
+ − 773 </ReferentialConstraint>
+ − 774 </Association>
+ − 775 <Association Name="FK_Products_Suppliers">
+ − 776 <End Role="Suppliers" Type="NorthwindModel.Store.Suppliers" Multiplicity="0..1" />
+ − 777 <End Role="Products" Type="NorthwindModel.Store.Products" Multiplicity="*" />
+ − 778 <ReferentialConstraint>
+ − 779 <Principal Role="Suppliers">
+ − 780 <PropertyRef Name="SupplierID" />
+ − 781 </Principal>
+ − 782 <Dependent Role="Products">
+ − 783 <PropertyRef Name="SupplierID" />
+ − 784 </Dependent>
+ − 785 </ReferentialConstraint>
+ − 786 </Association>
+ − 787 <Association Name="FK_Territories_Region">
+ − 788 <End Role="Region" Type="NorthwindModel.Store.Region" Multiplicity="1" />
+ − 789 <End Role="Territories" Type="NorthwindModel.Store.Territories" Multiplicity="*" />
+ − 790 <ReferentialConstraint>
+ − 791 <Principal Role="Region">
+ − 792 <PropertyRef Name="RegionID" />
+ − 793 </Principal>
+ − 794 <Dependent Role="Territories">
+ − 795 <PropertyRef Name="RegionID" />
+ − 796 </Dependent>
+ − 797 </ReferentialConstraint>
+ − 798 </Association>
+ − 799 <Function Name="CustOrderHist" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
+ − 800 <Parameter Name="CustomerID" Type="nchar" Mode="In" />
+ − 801 </Function>
+ − 802 <Function Name="CustOrdersDetail" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
+ − 803 <Parameter Name="OrderID" Type="int" Mode="In" />
+ − 804 </Function>
+ − 805 <Function Name="CustOrdersOrders" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
+ − 806 <Parameter Name="CustomerID" Type="nchar" Mode="In" />
+ − 807 </Function>
+ − 808 <Function Name="Employee_Sales_by_Country" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" StoreFunctionName="Employee Sales by Country" Schema="dbo">
+ − 809 <Parameter Name="Beginning_Date" Type="datetime" Mode="In" />
+ − 810 <Parameter Name="Ending_Date" Type="datetime" Mode="In" />
+ − 811 </Function>
+ − 812 <Function Name="fn_diagramobjects" ReturnType="int" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
+ − 813 <Function Name="Sales_by_Year" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" StoreFunctionName="Sales by Year" Schema="dbo">
+ − 814 <Parameter Name="Beginning_Date" Type="datetime" Mode="In" />
+ − 815 <Parameter Name="Ending_Date" Type="datetime" Mode="In" />
+ − 816 </Function>
+ − 817 <Function Name="SalesByCategory" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
+ − 818 <Parameter Name="CategoryName" Type="nvarchar" Mode="In" />
+ − 819 <Parameter Name="OrdYear" Type="nvarchar" Mode="In" />
+ − 820 </Function>
+ − 821 <Function Name="sp_alterdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
+ − 822 <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
+ − 823 <Parameter Name="owner_id" Type="int" Mode="In" />
+ − 824 <Parameter Name="version" Type="int" Mode="In" />
+ − 825 <Parameter Name="definition" Type="varbinary(max)" Mode="In" />
+ − 826 </Function>
+ − 827 <Function Name="sp_creatediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
+ − 828 <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
+ − 829 <Parameter Name="owner_id" Type="int" Mode="In" />
+ − 830 <Parameter Name="version" Type="int" Mode="In" />
+ − 831 <Parameter Name="definition" Type="varbinary(max)" Mode="In" />
+ − 832 </Function>
+ − 833 <Function Name="sp_dropdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
+ − 834 <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
+ − 835 <Parameter Name="owner_id" Type="int" Mode="In" />
+ − 836 </Function>
+ − 837 <Function Name="sp_helpdiagramdefinition" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
+ − 838 <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
+ − 839 <Parameter Name="owner_id" Type="int" Mode="In" />
+ − 840 </Function>
+ − 841 <Function Name="sp_helpdiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
+ − 842 <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
+ − 843 <Parameter Name="owner_id" Type="int" Mode="In" />
+ − 844 </Function>
+ − 845 <Function Name="sp_renamediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
+ − 846 <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
+ − 847 <Parameter Name="owner_id" Type="int" Mode="In" />
+ − 848 <Parameter Name="new_diagramname" Type="nvarchar" Mode="In" />
+ − 849 </Function>
+ − 850 <Function Name="sp_upgraddiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
+ − 851 <Function Name="Ten_Most_Expensive_Products" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" StoreFunctionName="Ten Most Expensive Products" Schema="dbo" />
+ − 852 <!--Errors Found During Generation:
+ − 853 warning 6013: The table/view 'Northwind.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.
+ − 854
+ − 855 <EntityType Name="Quarterly Orders">
+ − 856 <Property Name="CustomerID" Type="nchar" MaxLength="5" />
+ − 857 <Property Name="CompanyName" Type="nvarchar" MaxLength="40" />
+ − 858 <Property Name="City" Type="nvarchar" MaxLength="15" />
+ − 859 <Property Name="Country" Type="nvarchar" MaxLength="15" />
+ − 860 </EntityType>-->
+ − 861 </Schema>
+ − 862 </edmx:StorageModels>
+ − 863 <!-- CSDL content -->
+ − 864 <edmx:ConceptualModels>
+ − 865 <Schema Namespace="NorthwindModel" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
+ − 866 <EntityContainer Name="NorthwindEntities" annotation:LazyLoadingEnabled="true">
+ − 867 <EntitySet Name="Categories" EntityType="NorthwindModel.Category" />
+ − 868 <EntitySet Name="CustomerDemographics" EntityType="NorthwindModel.CustomerDemographic" />
+ − 869 <EntitySet Name="Customers" EntityType="NorthwindModel.Customer" />
+ − 870 <EntitySet Name="Employees" EntityType="NorthwindModel.Employee" />
+ − 871 <EntitySet Name="Order_Details" EntityType="NorthwindModel.Order_Detail" />
+ − 872 <EntitySet Name="Orders" EntityType="NorthwindModel.Order" />
+ − 873 <EntitySet Name="Products" EntityType="NorthwindModel.Product" />
+ − 874 <EntitySet Name="Regions" EntityType="NorthwindModel.Region" />
+ − 875 <EntitySet Name="Shippers" EntityType="NorthwindModel.Shipper" />
+ − 876 <EntitySet Name="Suppliers" EntityType="NorthwindModel.Supplier" />
+ − 877 <EntitySet Name="sysdiagrams" EntityType="NorthwindModel.sysdiagram" />
+ − 878 <EntitySet Name="Territories" EntityType="NorthwindModel.Territory" />
+ − 879 <EntitySet Name="Alphabetical_list_of_products" EntityType="NorthwindModel.Alphabetical_list_of_product" />
+ − 880 <EntitySet Name="Category_Sales_for_1997" EntityType="NorthwindModel.Category_Sales_for_1997" />
+ − 881 <EntitySet Name="Current_Product_Lists" EntityType="NorthwindModel.Current_Product_List" />
+ − 882 <EntitySet Name="Customer_and_Suppliers_by_Cities" EntityType="NorthwindModel.Customer_and_Suppliers_by_City" />
+ − 883 <EntitySet Name="Invoices" EntityType="NorthwindModel.Invoice" />
+ − 884 <EntitySet Name="Order_Details_Extendeds" EntityType="NorthwindModel.Order_Details_Extended" />
+ − 885 <EntitySet Name="Order_Subtotals" EntityType="NorthwindModel.Order_Subtotal" />
+ − 886 <EntitySet Name="Orders_Qries" EntityType="NorthwindModel.Orders_Qry" />
+ − 887 <EntitySet Name="Product_Sales_for_1997" EntityType="NorthwindModel.Product_Sales_for_1997" />
+ − 888 <EntitySet Name="Products_Above_Average_Prices" EntityType="NorthwindModel.Products_Above_Average_Price" />
+ − 889 <EntitySet Name="Products_by_Categories" EntityType="NorthwindModel.Products_by_Category" />
+ − 890 <EntitySet Name="Sales_by_Categories" EntityType="NorthwindModel.Sales_by_Category" />
+ − 891 <EntitySet Name="Sales_Totals_by_Amounts" EntityType="NorthwindModel.Sales_Totals_by_Amount" />
+ − 892 <EntitySet Name="Summary_of_Sales_by_Quarters" EntityType="NorthwindModel.Summary_of_Sales_by_Quarter" />
+ − 893 <EntitySet Name="Summary_of_Sales_by_Years" EntityType="NorthwindModel.Summary_of_Sales_by_Year" />
+ − 894 <AssociationSet Name="FK_Products_Categories" Association="NorthwindModel.FK_Products_Categories">
+ − 895 <End Role="Categories" EntitySet="Categories" />
+ − 896 <End Role="Products" EntitySet="Products" />
+ − 897 </AssociationSet>
+ − 898 <AssociationSet Name="FK_Orders_Customers" Association="NorthwindModel.FK_Orders_Customers">
+ − 899 <End Role="Customers" EntitySet="Customers" />
+ − 900 <End Role="Orders" EntitySet="Orders" />
+ − 901 </AssociationSet>
+ − 902 <AssociationSet Name="FK_Employees_Employees" Association="NorthwindModel.FK_Employees_Employees">
+ − 903 <End Role="Employees" EntitySet="Employees" />
+ − 904 <End Role="Employees1" EntitySet="Employees" />
+ − 905 </AssociationSet>
+ − 906 <AssociationSet Name="FK_Orders_Employees" Association="NorthwindModel.FK_Orders_Employees">
+ − 907 <End Role="Employees" EntitySet="Employees" />
+ − 908 <End Role="Orders" EntitySet="Orders" />
+ − 909 </AssociationSet>
+ − 910 <AssociationSet Name="FK_Order_Details_Orders" Association="NorthwindModel.FK_Order_Details_Orders">
+ − 911 <End Role="Orders" EntitySet="Orders" />
+ − 912 <End Role="Order_Details" EntitySet="Order_Details" />
+ − 913 </AssociationSet>
+ − 914 <AssociationSet Name="FK_Order_Details_Products" Association="NorthwindModel.FK_Order_Details_Products">
+ − 915 <End Role="Products" EntitySet="Products" />
+ − 916 <End Role="Order_Details" EntitySet="Order_Details" />
+ − 917 </AssociationSet>
+ − 918 <AssociationSet Name="FK_Orders_Shippers" Association="NorthwindModel.FK_Orders_Shippers">
+ − 919 <End Role="Shippers" EntitySet="Shippers" />
+ − 920 <End Role="Orders" EntitySet="Orders" />
+ − 921 </AssociationSet>
+ − 922 <AssociationSet Name="FK_Products_Suppliers" Association="NorthwindModel.FK_Products_Suppliers">
+ − 923 <End Role="Suppliers" EntitySet="Suppliers" />
+ − 924 <End Role="Products" EntitySet="Products" />
+ − 925 </AssociationSet>
+ − 926 <AssociationSet Name="FK_Territories_Region" Association="NorthwindModel.FK_Territories_Region">
+ − 927 <End Role="Region" EntitySet="Regions" />
+ − 928 <End Role="Territories" EntitySet="Territories" />
+ − 929 </AssociationSet>
+ − 930 <AssociationSet Name="CustomerCustomerDemo" Association="NorthwindModel.CustomerCustomerDemo">
+ − 931 <End Role="CustomerDemographics" EntitySet="CustomerDemographics" />
+ − 932 <End Role="Customers" EntitySet="Customers" />
+ − 933 </AssociationSet>
+ − 934 <AssociationSet Name="EmployeeTerritories" Association="NorthwindModel.EmployeeTerritories">
+ − 935 <End Role="Employees" EntitySet="Employees" />
+ − 936 <End Role="Territories" EntitySet="Territories" />
+ − 937 </AssociationSet>
+ − 938 </EntityContainer>
+ − 939 <EntityType Name="Category">
+ − 940 <Key>
+ − 941 <PropertyRef Name="CategoryID" />
+ − 942 </Key>
+ − 943 <Property Name="CategoryID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+ − 944 <Property Name="CategoryName" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 945 <Property Name="Description" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
+ − 946 <Property Name="Picture" Type="Binary" MaxLength="Max" FixedLength="false" />
+ − 947 <NavigationProperty Name="Products" Relationship="NorthwindModel.FK_Products_Categories" FromRole="Categories" ToRole="Products" />
+ − 948 </EntityType>
+ − 949 <EntityType Name="CustomerDemographic">
+ − 950 <Key>
+ − 951 <PropertyRef Name="CustomerTypeID" />
+ − 952 </Key>
+ − 953 <Property Name="CustomerTypeID" Type="String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="true" />
+ − 954 <Property Name="CustomerDesc" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
+ − 955 <NavigationProperty Name="Customers" Relationship="NorthwindModel.CustomerCustomerDemo" FromRole="CustomerDemographics" ToRole="Customers" />
+ − 956 </EntityType>
+ − 957 <EntityType Name="Customer">
+ − 958 <Key>
+ − 959 <PropertyRef Name="CustomerID" />
+ − 960 </Key>
+ − 961 <Property Name="CustomerID" Type="String" Nullable="false" MaxLength="5" Unicode="true" FixedLength="true" />
+ − 962 <Property Name="CompanyName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 963 <Property Name="ContactName" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
+ − 964 <Property Name="ContactTitle" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
+ − 965 <Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
+ − 966 <Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 967 <Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 968 <Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
+ − 969 <Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 970 <Property Name="Phone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
+ − 971 <Property Name="Fax" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
+ − 972 <NavigationProperty Name="Orders" Relationship="NorthwindModel.FK_Orders_Customers" FromRole="Customers" ToRole="Orders" />
+ − 973 <NavigationProperty Name="CustomerDemographics" Relationship="NorthwindModel.CustomerCustomerDemo" FromRole="Customers" ToRole="CustomerDemographics" />
+ − 974 </EntityType>
+ − 975 <EntityType Name="Employee">
+ − 976 <Key>
+ − 977 <PropertyRef Name="EmployeeID" />
+ − 978 </Key>
+ − 979 <Property Name="EmployeeID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+ − 980 <Property Name="LastName" Type="String" Nullable="false" MaxLength="20" Unicode="true" FixedLength="false" />
+ − 981 <Property Name="FirstName" Type="String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
+ − 982 <Property Name="Title" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
+ − 983 <Property Name="TitleOfCourtesy" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
+ − 984 <Property Name="BirthDate" Type="DateTime" />
+ − 985 <Property Name="HireDate" Type="DateTime" />
+ − 986 <Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
+ − 987 <Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 988 <Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 989 <Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
+ − 990 <Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 991 <Property Name="HomePhone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
+ − 992 <Property Name="Extension" Type="String" MaxLength="4" Unicode="true" FixedLength="false" />
+ − 993 <Property Name="Photo" Type="Binary" MaxLength="Max" FixedLength="false" />
+ − 994 <Property Name="Notes" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
+ − 995 <Property Name="ReportsTo" Type="Int32" />
+ − 996 <Property Name="PhotoPath" Type="String" MaxLength="255" Unicode="true" FixedLength="false" />
+ − 997 <NavigationProperty Name="Employees1" Relationship="NorthwindModel.FK_Employees_Employees" FromRole="Employees" ToRole="Employees1" />
+ − 998 <NavigationProperty Name="Employee1" Relationship="NorthwindModel.FK_Employees_Employees" FromRole="Employees1" ToRole="Employees" />
+ − 999 <NavigationProperty Name="Orders" Relationship="NorthwindModel.FK_Orders_Employees" FromRole="Employees" ToRole="Orders" />
+ − 1000 <NavigationProperty Name="Territories" Relationship="NorthwindModel.EmployeeTerritories" FromRole="Employees" ToRole="Territories" />
+ − 1001 </EntityType>
+ − 1002 <EntityType Name="Order_Detail">
+ − 1003 <Key>
+ − 1004 <PropertyRef Name="OrderID" />
+ − 1005 <PropertyRef Name="ProductID" />
+ − 1006 </Key>
+ − 1007 <Property Name="OrderID" Type="Int32" Nullable="false" />
+ − 1008 <Property Name="ProductID" Type="Int32" Nullable="false" />
+ − 1009 <Property Name="UnitPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
+ − 1010 <Property Name="Quantity" Type="Int16" Nullable="false" />
+ − 1011 <Property Name="Discount" Type="Single" Nullable="false" />
+ − 1012 <NavigationProperty Name="Order" Relationship="NorthwindModel.FK_Order_Details_Orders" FromRole="Order_Details" ToRole="Orders" />
+ − 1013 <NavigationProperty Name="Product" Relationship="NorthwindModel.FK_Order_Details_Products" FromRole="Order_Details" ToRole="Products" />
+ − 1014 </EntityType>
+ − 1015 <EntityType Name="Order">
+ − 1016 <Key>
+ − 1017 <PropertyRef Name="OrderID" />
+ − 1018 </Key>
+ − 1019 <Property Name="OrderID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+ − 1020 <Property Name="CustomerID" Type="String" MaxLength="5" Unicode="true" FixedLength="true" />
+ − 1021 <Property Name="EmployeeID" Type="Int32" />
+ − 1022 <Property Name="OrderDate" Type="DateTime" />
+ − 1023 <Property Name="RequiredDate" Type="DateTime" />
+ − 1024 <Property Name="ShippedDate" Type="DateTime" />
+ − 1025 <Property Name="ShipVia" Type="Int32" />
+ − 1026 <Property Name="Freight" Type="Decimal" Precision="19" Scale="4" />
+ − 1027 <Property Name="ShipName" Type="String" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1028 <Property Name="ShipAddress" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
+ − 1029 <Property Name="ShipCity" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1030 <Property Name="ShipRegion" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1031 <Property Name="ShipPostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
+ − 1032 <Property Name="ShipCountry" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1033 <NavigationProperty Name="Customer" Relationship="NorthwindModel.FK_Orders_Customers" FromRole="Orders" ToRole="Customers" />
+ − 1034 <NavigationProperty Name="Employee" Relationship="NorthwindModel.FK_Orders_Employees" FromRole="Orders" ToRole="Employees" />
+ − 1035 <NavigationProperty Name="Order_Details" Relationship="NorthwindModel.FK_Order_Details_Orders" FromRole="Orders" ToRole="Order_Details" />
+ − 1036 <NavigationProperty Name="Shipper" Relationship="NorthwindModel.FK_Orders_Shippers" FromRole="Orders" ToRole="Shippers" />
+ − 1037 </EntityType>
+ − 1038 <EntityType Name="Product">
+ − 1039 <Key>
+ − 1040 <PropertyRef Name="ProductID" />
+ − 1041 </Key>
+ − 1042 <Property Name="ProductID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+ − 1043 <Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1044 <Property Name="SupplierID" Type="Int32" />
+ − 1045 <Property Name="CategoryID" Type="Int32" />
+ − 1046 <Property Name="QuantityPerUnit" Type="String" MaxLength="20" Unicode="true" FixedLength="false" />
+ − 1047 <Property Name="UnitPrice" Type="Decimal" Precision="19" Scale="4" />
+ − 1048 <Property Name="UnitsInStock" Type="Int16" />
+ − 1049 <Property Name="UnitsOnOrder" Type="Int16" />
+ − 1050 <Property Name="ReorderLevel" Type="Int16" />
+ − 1051 <Property Name="Discontinued" Type="Boolean" Nullable="false" />
+ − 1052 <NavigationProperty Name="Category" Relationship="NorthwindModel.FK_Products_Categories" FromRole="Products" ToRole="Categories" />
+ − 1053 <NavigationProperty Name="Order_Details" Relationship="NorthwindModel.FK_Order_Details_Products" FromRole="Products" ToRole="Order_Details" />
+ − 1054 <NavigationProperty Name="Supplier" Relationship="NorthwindModel.FK_Products_Suppliers" FromRole="Products" ToRole="Suppliers" />
+ − 1055 </EntityType>
+ − 1056 <EntityType Name="Region">
+ − 1057 <Key>
+ − 1058 <PropertyRef Name="RegionID" />
+ − 1059 </Key>
+ − 1060 <Property Name="RegionID" Type="Int32" Nullable="false" />
+ − 1061 <Property Name="RegionDescription" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="true" />
+ − 1062 <NavigationProperty Name="Territories" Relationship="NorthwindModel.FK_Territories_Region" FromRole="Region" ToRole="Territories" />
+ − 1063 </EntityType>
+ − 1064 <EntityType Name="Shipper">
+ − 1065 <Key>
+ − 1066 <PropertyRef Name="ShipperID" />
+ − 1067 </Key>
+ − 1068 <Property Name="ShipperID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+ − 1069 <Property Name="CompanyName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1070 <Property Name="Phone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
+ − 1071 <NavigationProperty Name="Orders" Relationship="NorthwindModel.FK_Orders_Shippers" FromRole="Shippers" ToRole="Orders" />
+ − 1072 </EntityType>
+ − 1073 <EntityType Name="Supplier">
+ − 1074 <Key>
+ − 1075 <PropertyRef Name="SupplierID" />
+ − 1076 </Key>
+ − 1077 <Property Name="SupplierID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+ − 1078 <Property Name="CompanyName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1079 <Property Name="ContactName" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
+ − 1080 <Property Name="ContactTitle" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
+ − 1081 <Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
+ − 1082 <Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1083 <Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1084 <Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
+ − 1085 <Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1086 <Property Name="Phone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
+ − 1087 <Property Name="Fax" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
+ − 1088 <Property Name="HomePage" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
+ − 1089 <NavigationProperty Name="Products" Relationship="NorthwindModel.FK_Products_Suppliers" FromRole="Suppliers" ToRole="Products" />
+ − 1090 </EntityType>
+ − 1091 <EntityType Name="sysdiagram">
+ − 1092 <Key>
+ − 1093 <PropertyRef Name="diagram_id" />
+ − 1094 </Key>
+ − 1095 <Property Name="name" Type="String" Nullable="false" MaxLength="128" Unicode="true" FixedLength="false" />
+ − 1096 <Property Name="principal_id" Type="Int32" Nullable="false" />
+ − 1097 <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+ − 1098 <Property Name="version" Type="Int32" />
+ − 1099 <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
+ − 1100 </EntityType>
+ − 1101 <EntityType Name="Territory">
+ − 1102 <Key>
+ − 1103 <PropertyRef Name="TerritoryID" />
+ − 1104 </Key>
+ − 1105 <Property Name="TerritoryID" Type="String" Nullable="false" MaxLength="20" Unicode="true" FixedLength="false" />
+ − 1106 <Property Name="TerritoryDescription" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="true" />
+ − 1107 <Property Name="RegionID" Type="Int32" Nullable="false" />
+ − 1108 <NavigationProperty Name="Region" Relationship="NorthwindModel.FK_Territories_Region" FromRole="Territories" ToRole="Region" />
+ − 1109 <NavigationProperty Name="Employees" Relationship="NorthwindModel.EmployeeTerritories" FromRole="Territories" ToRole="Employees" />
+ − 1110 </EntityType>
+ − 1111 <EntityType Name="Alphabetical_list_of_product">
+ − 1112 <Key>
+ − 1113 <PropertyRef Name="ProductID" />
+ − 1114 <PropertyRef Name="ProductName" />
+ − 1115 <PropertyRef Name="Discontinued" />
+ − 1116 <PropertyRef Name="CategoryName" />
+ − 1117 </Key>
+ − 1118 <Property Name="ProductID" Type="Int32" Nullable="false" />
+ − 1119 <Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1120 <Property Name="SupplierID" Type="Int32" />
+ − 1121 <Property Name="CategoryID" Type="Int32" />
+ − 1122 <Property Name="QuantityPerUnit" Type="String" MaxLength="20" Unicode="true" FixedLength="false" />
+ − 1123 <Property Name="UnitPrice" Type="Decimal" Precision="19" Scale="4" />
+ − 1124 <Property Name="UnitsInStock" Type="Int16" />
+ − 1125 <Property Name="UnitsOnOrder" Type="Int16" />
+ − 1126 <Property Name="ReorderLevel" Type="Int16" />
+ − 1127 <Property Name="Discontinued" Type="Boolean" Nullable="false" />
+ − 1128 <Property Name="CategoryName" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1129 </EntityType>
+ − 1130 <EntityType Name="Category_Sales_for_1997">
+ − 1131 <Key>
+ − 1132 <PropertyRef Name="CategoryName" />
+ − 1133 </Key>
+ − 1134 <Property Name="CategoryName" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1135 <Property Name="CategorySales" Type="Decimal" Precision="19" Scale="4" />
+ − 1136 </EntityType>
+ − 1137 <EntityType Name="Current_Product_List">
+ − 1138 <Key>
+ − 1139 <PropertyRef Name="ProductID" />
+ − 1140 <PropertyRef Name="ProductName" />
+ − 1141 </Key>
+ − 1142 <Property Name="ProductID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+ − 1143 <Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1144 </EntityType>
+ − 1145 <EntityType Name="Customer_and_Suppliers_by_City">
+ − 1146 <Key>
+ − 1147 <PropertyRef Name="CompanyName" />
+ − 1148 <PropertyRef Name="Relationship" />
+ − 1149 </Key>
+ − 1150 <Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1151 <Property Name="CompanyName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1152 <Property Name="ContactName" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
+ − 1153 <Property Name="Relationship" Type="String" Nullable="false" MaxLength="9" Unicode="false" FixedLength="false" />
+ − 1154 </EntityType>
+ − 1155 <EntityType Name="Invoice">
+ − 1156 <Key>
+ − 1157 <PropertyRef Name="CustomerName" />
+ − 1158 <PropertyRef Name="Salesperson" />
+ − 1159 <PropertyRef Name="OrderID" />
+ − 1160 <PropertyRef Name="ShipperName" />
+ − 1161 <PropertyRef Name="ProductID" />
+ − 1162 <PropertyRef Name="ProductName" />
+ − 1163 <PropertyRef Name="UnitPrice" />
+ − 1164 <PropertyRef Name="Quantity" />
+ − 1165 <PropertyRef Name="Discount" />
+ − 1166 </Key>
+ − 1167 <Property Name="ShipName" Type="String" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1168 <Property Name="ShipAddress" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
+ − 1169 <Property Name="ShipCity" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1170 <Property Name="ShipRegion" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1171 <Property Name="ShipPostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
+ − 1172 <Property Name="ShipCountry" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1173 <Property Name="CustomerID" Type="String" MaxLength="5" Unicode="true" FixedLength="true" />
+ − 1174 <Property Name="CustomerName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1175 <Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
+ − 1176 <Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1177 <Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1178 <Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
+ − 1179 <Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1180 <Property Name="Salesperson" Type="String" Nullable="false" MaxLength="31" Unicode="true" FixedLength="false" />
+ − 1181 <Property Name="OrderID" Type="Int32" Nullable="false" />
+ − 1182 <Property Name="OrderDate" Type="DateTime" />
+ − 1183 <Property Name="RequiredDate" Type="DateTime" />
+ − 1184 <Property Name="ShippedDate" Type="DateTime" />
+ − 1185 <Property Name="ShipperName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1186 <Property Name="ProductID" Type="Int32" Nullable="false" />
+ − 1187 <Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1188 <Property Name="UnitPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
+ − 1189 <Property Name="Quantity" Type="Int16" Nullable="false" />
+ − 1190 <Property Name="Discount" Type="Single" Nullable="false" />
+ − 1191 <Property Name="ExtendedPrice" Type="Decimal" Precision="19" Scale="4" />
+ − 1192 <Property Name="Freight" Type="Decimal" Precision="19" Scale="4" />
+ − 1193 </EntityType>
+ − 1194 <EntityType Name="Order_Details_Extended">
+ − 1195 <Key>
+ − 1196 <PropertyRef Name="OrderID" />
+ − 1197 <PropertyRef Name="ProductID" />
+ − 1198 <PropertyRef Name="ProductName" />
+ − 1199 <PropertyRef Name="UnitPrice" />
+ − 1200 <PropertyRef Name="Quantity" />
+ − 1201 <PropertyRef Name="Discount" />
+ − 1202 </Key>
+ − 1203 <Property Name="OrderID" Type="Int32" Nullable="false" />
+ − 1204 <Property Name="ProductID" Type="Int32" Nullable="false" />
+ − 1205 <Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1206 <Property Name="UnitPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
+ − 1207 <Property Name="Quantity" Type="Int16" Nullable="false" />
+ − 1208 <Property Name="Discount" Type="Single" Nullable="false" />
+ − 1209 <Property Name="ExtendedPrice" Type="Decimal" Precision="19" Scale="4" />
+ − 1210 </EntityType>
+ − 1211 <EntityType Name="Order_Subtotal">
+ − 1212 <Key>
+ − 1213 <PropertyRef Name="OrderID" />
+ − 1214 </Key>
+ − 1215 <Property Name="OrderID" Type="Int32" Nullable="false" />
+ − 1216 <Property Name="Subtotal" Type="Decimal" Precision="19" Scale="4" />
+ − 1217 </EntityType>
+ − 1218 <EntityType Name="Orders_Qry">
+ − 1219 <Key>
+ − 1220 <PropertyRef Name="OrderID" />
+ − 1221 <PropertyRef Name="CompanyName" />
+ − 1222 </Key>
+ − 1223 <Property Name="OrderID" Type="Int32" Nullable="false" />
+ − 1224 <Property Name="CustomerID" Type="String" MaxLength="5" Unicode="true" FixedLength="true" />
+ − 1225 <Property Name="EmployeeID" Type="Int32" />
+ − 1226 <Property Name="OrderDate" Type="DateTime" />
+ − 1227 <Property Name="RequiredDate" Type="DateTime" />
+ − 1228 <Property Name="ShippedDate" Type="DateTime" />
+ − 1229 <Property Name="ShipVia" Type="Int32" />
+ − 1230 <Property Name="Freight" Type="Decimal" Precision="19" Scale="4" />
+ − 1231 <Property Name="ShipName" Type="String" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1232 <Property Name="ShipAddress" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
+ − 1233 <Property Name="ShipCity" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1234 <Property Name="ShipRegion" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1235 <Property Name="ShipPostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
+ − 1236 <Property Name="ShipCountry" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1237 <Property Name="CompanyName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1238 <Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
+ − 1239 <Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1240 <Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1241 <Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
+ − 1242 <Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1243 </EntityType>
+ − 1244 <EntityType Name="Product_Sales_for_1997">
+ − 1245 <Key>
+ − 1246 <PropertyRef Name="CategoryName" />
+ − 1247 <PropertyRef Name="ProductName" />
+ − 1248 </Key>
+ − 1249 <Property Name="CategoryName" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1250 <Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1251 <Property Name="ProductSales" Type="Decimal" Precision="19" Scale="4" />
+ − 1252 </EntityType>
+ − 1253 <EntityType Name="Products_Above_Average_Price">
+ − 1254 <Key>
+ − 1255 <PropertyRef Name="ProductName" />
+ − 1256 </Key>
+ − 1257 <Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1258 <Property Name="UnitPrice" Type="Decimal" Precision="19" Scale="4" />
+ − 1259 </EntityType>
+ − 1260 <EntityType Name="Products_by_Category">
+ − 1261 <Key>
+ − 1262 <PropertyRef Name="CategoryName" />
+ − 1263 <PropertyRef Name="ProductName" />
+ − 1264 <PropertyRef Name="Discontinued" />
+ − 1265 </Key>
+ − 1266 <Property Name="CategoryName" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1267 <Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1268 <Property Name="QuantityPerUnit" Type="String" MaxLength="20" Unicode="true" FixedLength="false" />
+ − 1269 <Property Name="UnitsInStock" Type="Int16" />
+ − 1270 <Property Name="Discontinued" Type="Boolean" Nullable="false" />
+ − 1271 </EntityType>
+ − 1272 <EntityType Name="Sales_by_Category">
+ − 1273 <Key>
+ − 1274 <PropertyRef Name="CategoryID" />
+ − 1275 <PropertyRef Name="CategoryName" />
+ − 1276 <PropertyRef Name="ProductName" />
+ − 1277 </Key>
+ − 1278 <Property Name="CategoryID" Type="Int32" Nullable="false" />
+ − 1279 <Property Name="CategoryName" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
+ − 1280 <Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1281 <Property Name="ProductSales" Type="Decimal" Precision="19" Scale="4" />
+ − 1282 </EntityType>
+ − 1283 <EntityType Name="Sales_Totals_by_Amount">
+ − 1284 <Key>
+ − 1285 <PropertyRef Name="OrderID" />
+ − 1286 <PropertyRef Name="CompanyName" />
+ − 1287 </Key>
+ − 1288 <Property Name="SaleAmount" Type="Decimal" Precision="19" Scale="4" />
+ − 1289 <Property Name="OrderID" Type="Int32" Nullable="false" />
+ − 1290 <Property Name="CompanyName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
+ − 1291 <Property Name="ShippedDate" Type="DateTime" />
+ − 1292 </EntityType>
+ − 1293 <EntityType Name="Summary_of_Sales_by_Quarter">
+ − 1294 <Key>
+ − 1295 <PropertyRef Name="OrderID" />
+ − 1296 </Key>
+ − 1297 <Property Name="ShippedDate" Type="DateTime" />
+ − 1298 <Property Name="OrderID" Type="Int32" Nullable="false" />
+ − 1299 <Property Name="Subtotal" Type="Decimal" Precision="19" Scale="4" />
+ − 1300 </EntityType>
+ − 1301 <EntityType Name="Summary_of_Sales_by_Year">
+ − 1302 <Key>
+ − 1303 <PropertyRef Name="OrderID" />
+ − 1304 </Key>
+ − 1305 <Property Name="ShippedDate" Type="DateTime" />
+ − 1306 <Property Name="OrderID" Type="Int32" Nullable="false" />
+ − 1307 <Property Name="Subtotal" Type="Decimal" Precision="19" Scale="4" />
+ − 1308 </EntityType>
+ − 1309 <Association Name="FK_Products_Categories">
+ − 1310 <End Role="Categories" Type="NorthwindModel.Category" Multiplicity="0..1" />
+ − 1311 <End Role="Products" Type="NorthwindModel.Product" Multiplicity="*" />
+ − 1312 <ReferentialConstraint>
+ − 1313 <Principal Role="Categories">
+ − 1314 <PropertyRef Name="CategoryID" />
+ − 1315 </Principal>
+ − 1316 <Dependent Role="Products">
+ − 1317 <PropertyRef Name="CategoryID" />
+ − 1318 </Dependent>
+ − 1319 </ReferentialConstraint>
+ − 1320 </Association>
+ − 1321 <Association Name="FK_Orders_Customers">
+ − 1322 <End Role="Customers" Type="NorthwindModel.Customer" Multiplicity="0..1" />
+ − 1323 <End Role="Orders" Type="NorthwindModel.Order" Multiplicity="*" />
+ − 1324 <ReferentialConstraint>
+ − 1325 <Principal Role="Customers">
+ − 1326 <PropertyRef Name="CustomerID" />
+ − 1327 </Principal>
+ − 1328 <Dependent Role="Orders">
+ − 1329 <PropertyRef Name="CustomerID" />
+ − 1330 </Dependent>
+ − 1331 </ReferentialConstraint>
+ − 1332 </Association>
+ − 1333 <Association Name="FK_Employees_Employees">
+ − 1334 <End Role="Employees" Type="NorthwindModel.Employee" Multiplicity="0..1" />
+ − 1335 <End Role="Employees1" Type="NorthwindModel.Employee" Multiplicity="*" />
+ − 1336 <ReferentialConstraint>
+ − 1337 <Principal Role="Employees">
+ − 1338 <PropertyRef Name="EmployeeID" />
+ − 1339 </Principal>
+ − 1340 <Dependent Role="Employees1">
+ − 1341 <PropertyRef Name="ReportsTo" />
+ − 1342 </Dependent>
+ − 1343 </ReferentialConstraint>
+ − 1344 </Association>
+ − 1345 <Association Name="FK_Orders_Employees">
+ − 1346 <End Role="Employees" Type="NorthwindModel.Employee" Multiplicity="0..1" />
+ − 1347 <End Role="Orders" Type="NorthwindModel.Order" Multiplicity="*" />
+ − 1348 <ReferentialConstraint>
+ − 1349 <Principal Role="Employees">
+ − 1350 <PropertyRef Name="EmployeeID" />
+ − 1351 </Principal>
+ − 1352 <Dependent Role="Orders">
+ − 1353 <PropertyRef Name="EmployeeID" />
+ − 1354 </Dependent>
+ − 1355 </ReferentialConstraint>
+ − 1356 </Association>
+ − 1357 <Association Name="FK_Order_Details_Orders">
+ − 1358 <End Role="Orders" Type="NorthwindModel.Order" Multiplicity="1" />
+ − 1359 <End Role="Order_Details" Type="NorthwindModel.Order_Detail" Multiplicity="*" />
+ − 1360 <ReferentialConstraint>
+ − 1361 <Principal Role="Orders">
+ − 1362 <PropertyRef Name="OrderID" />
+ − 1363 </Principal>
+ − 1364 <Dependent Role="Order_Details">
+ − 1365 <PropertyRef Name="OrderID" />
+ − 1366 </Dependent>
+ − 1367 </ReferentialConstraint>
+ − 1368 </Association>
+ − 1369 <Association Name="FK_Order_Details_Products">
+ − 1370 <End Role="Products" Type="NorthwindModel.Product" Multiplicity="1" />
+ − 1371 <End Role="Order_Details" Type="NorthwindModel.Order_Detail" Multiplicity="*" />
+ − 1372 <ReferentialConstraint>
+ − 1373 <Principal Role="Products">
+ − 1374 <PropertyRef Name="ProductID" />
+ − 1375 </Principal>
+ − 1376 <Dependent Role="Order_Details">
+ − 1377 <PropertyRef Name="ProductID" />
+ − 1378 </Dependent>
+ − 1379 </ReferentialConstraint>
+ − 1380 </Association>
+ − 1381 <Association Name="FK_Orders_Shippers">
+ − 1382 <End Role="Shippers" Type="NorthwindModel.Shipper" Multiplicity="0..1" />
+ − 1383 <End Role="Orders" Type="NorthwindModel.Order" Multiplicity="*" />
+ − 1384 <ReferentialConstraint>
+ − 1385 <Principal Role="Shippers">
+ − 1386 <PropertyRef Name="ShipperID" />
+ − 1387 </Principal>
+ − 1388 <Dependent Role="Orders">
+ − 1389 <PropertyRef Name="ShipVia" />
+ − 1390 </Dependent>
+ − 1391 </ReferentialConstraint>
+ − 1392 </Association>
+ − 1393 <Association Name="FK_Products_Suppliers">
+ − 1394 <End Role="Suppliers" Type="NorthwindModel.Supplier" Multiplicity="0..1" />
+ − 1395 <End Role="Products" Type="NorthwindModel.Product" Multiplicity="*" />
+ − 1396 <ReferentialConstraint>
+ − 1397 <Principal Role="Suppliers">
+ − 1398 <PropertyRef Name="SupplierID" />
+ − 1399 </Principal>
+ − 1400 <Dependent Role="Products">
+ − 1401 <PropertyRef Name="SupplierID" />
+ − 1402 </Dependent>
+ − 1403 </ReferentialConstraint>
+ − 1404 </Association>
+ − 1405 <Association Name="FK_Territories_Region">
+ − 1406 <End Role="Region" Type="NorthwindModel.Region" Multiplicity="1" />
+ − 1407 <End Role="Territories" Type="NorthwindModel.Territory" Multiplicity="*" />
+ − 1408 <ReferentialConstraint>
+ − 1409 <Principal Role="Region">
+ − 1410 <PropertyRef Name="RegionID" />
+ − 1411 </Principal>
+ − 1412 <Dependent Role="Territories">
+ − 1413 <PropertyRef Name="RegionID" />
+ − 1414 </Dependent>
+ − 1415 </ReferentialConstraint>
+ − 1416 </Association>
+ − 1417 <Association Name="CustomerCustomerDemo">
+ − 1418 <End Role="CustomerDemographics" Type="NorthwindModel.CustomerDemographic" Multiplicity="*" />
+ − 1419 <End Role="Customers" Type="NorthwindModel.Customer" Multiplicity="*" />
+ − 1420 </Association>
+ − 1421 <Association Name="EmployeeTerritories">
+ − 1422 <End Role="Employees" Type="NorthwindModel.Employee" Multiplicity="*" />
+ − 1423 <End Role="Territories" Type="NorthwindModel.Territory" Multiplicity="*" />
+ − 1424 </Association>
+ − 1425 </Schema>
+ − 1426 </edmx:ConceptualModels>
+ − 1427 <!-- C-S mapping content -->
+ − 1428 <edmx:Mappings>
+ − 1429 <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
+ − 1430 <EntityContainerMapping StorageEntityContainer="NorthwindModelStoreContainer" CdmEntityContainer="NorthwindEntities">
+ − 1431 <EntitySetMapping Name="Categories"><EntityTypeMapping TypeName="NorthwindModel.Category"><MappingFragment StoreEntitySet="Categories">
+ − 1432 <ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
+ − 1433 <ScalarProperty Name="CategoryName" ColumnName="CategoryName" />
+ − 1434 <ScalarProperty Name="Description" ColumnName="Description" />
+ − 1435 <ScalarProperty Name="Picture" ColumnName="Picture" />
+ − 1436 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1437 <EntitySetMapping Name="CustomerDemographics"><EntityTypeMapping TypeName="NorthwindModel.CustomerDemographic"><MappingFragment StoreEntitySet="CustomerDemographics">
+ − 1438 <ScalarProperty Name="CustomerTypeID" ColumnName="CustomerTypeID" />
+ − 1439 <ScalarProperty Name="CustomerDesc" ColumnName="CustomerDesc" />
+ − 1440 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1441 <EntitySetMapping Name="Customers"><EntityTypeMapping TypeName="NorthwindModel.Customer"><MappingFragment StoreEntitySet="Customers">
+ − 1442 <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
+ − 1443 <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
+ − 1444 <ScalarProperty Name="ContactName" ColumnName="ContactName" />
+ − 1445 <ScalarProperty Name="ContactTitle" ColumnName="ContactTitle" />
+ − 1446 <ScalarProperty Name="Address" ColumnName="Address" />
+ − 1447 <ScalarProperty Name="City" ColumnName="City" />
+ − 1448 <ScalarProperty Name="Region" ColumnName="Region" />
+ − 1449 <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
+ − 1450 <ScalarProperty Name="Country" ColumnName="Country" />
+ − 1451 <ScalarProperty Name="Phone" ColumnName="Phone" />
+ − 1452 <ScalarProperty Name="Fax" ColumnName="Fax" />
+ − 1453 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1454 <EntitySetMapping Name="Employees"><EntityTypeMapping TypeName="NorthwindModel.Employee"><MappingFragment StoreEntitySet="Employees">
+ − 1455 <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
+ − 1456 <ScalarProperty Name="LastName" ColumnName="LastName" />
+ − 1457 <ScalarProperty Name="FirstName" ColumnName="FirstName" />
+ − 1458 <ScalarProperty Name="Title" ColumnName="Title" />
+ − 1459 <ScalarProperty Name="TitleOfCourtesy" ColumnName="TitleOfCourtesy" />
+ − 1460 <ScalarProperty Name="BirthDate" ColumnName="BirthDate" />
+ − 1461 <ScalarProperty Name="HireDate" ColumnName="HireDate" />
+ − 1462 <ScalarProperty Name="Address" ColumnName="Address" />
+ − 1463 <ScalarProperty Name="City" ColumnName="City" />
+ − 1464 <ScalarProperty Name="Region" ColumnName="Region" />
+ − 1465 <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
+ − 1466 <ScalarProperty Name="Country" ColumnName="Country" />
+ − 1467 <ScalarProperty Name="HomePhone" ColumnName="HomePhone" />
+ − 1468 <ScalarProperty Name="Extension" ColumnName="Extension" />
+ − 1469 <ScalarProperty Name="Photo" ColumnName="Photo" />
+ − 1470 <ScalarProperty Name="Notes" ColumnName="Notes" />
+ − 1471 <ScalarProperty Name="ReportsTo" ColumnName="ReportsTo" />
+ − 1472 <ScalarProperty Name="PhotoPath" ColumnName="PhotoPath" />
+ − 1473 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1474 <EntitySetMapping Name="Order_Details"><EntityTypeMapping TypeName="NorthwindModel.Order_Detail"><MappingFragment StoreEntitySet="Order Details">
+ − 1475 <ScalarProperty Name="OrderID" ColumnName="OrderID" />
+ − 1476 <ScalarProperty Name="ProductID" ColumnName="ProductID" />
+ − 1477 <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
+ − 1478 <ScalarProperty Name="Quantity" ColumnName="Quantity" />
+ − 1479 <ScalarProperty Name="Discount" ColumnName="Discount" />
+ − 1480 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1481 <EntitySetMapping Name="Orders"><EntityTypeMapping TypeName="NorthwindModel.Order"><MappingFragment StoreEntitySet="Orders">
+ − 1482 <ScalarProperty Name="OrderID" ColumnName="OrderID" />
+ − 1483 <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
+ − 1484 <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
+ − 1485 <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
+ − 1486 <ScalarProperty Name="RequiredDate" ColumnName="RequiredDate" />
+ − 1487 <ScalarProperty Name="ShippedDate" ColumnName="ShippedDate" />
+ − 1488 <ScalarProperty Name="ShipVia" ColumnName="ShipVia" />
+ − 1489 <ScalarProperty Name="Freight" ColumnName="Freight" />
+ − 1490 <ScalarProperty Name="ShipName" ColumnName="ShipName" />
+ − 1491 <ScalarProperty Name="ShipAddress" ColumnName="ShipAddress" />
+ − 1492 <ScalarProperty Name="ShipCity" ColumnName="ShipCity" />
+ − 1493 <ScalarProperty Name="ShipRegion" ColumnName="ShipRegion" />
+ − 1494 <ScalarProperty Name="ShipPostalCode" ColumnName="ShipPostalCode" />
+ − 1495 <ScalarProperty Name="ShipCountry" ColumnName="ShipCountry" />
+ − 1496 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1497 <EntitySetMapping Name="Products"><EntityTypeMapping TypeName="NorthwindModel.Product"><MappingFragment StoreEntitySet="Products">
+ − 1498 <ScalarProperty Name="ProductID" ColumnName="ProductID" />
+ − 1499 <ScalarProperty Name="ProductName" ColumnName="ProductName" />
+ − 1500 <ScalarProperty Name="SupplierID" ColumnName="SupplierID" />
+ − 1501 <ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
+ − 1502 <ScalarProperty Name="QuantityPerUnit" ColumnName="QuantityPerUnit" />
+ − 1503 <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
+ − 1504 <ScalarProperty Name="UnitsInStock" ColumnName="UnitsInStock" />
+ − 1505 <ScalarProperty Name="UnitsOnOrder" ColumnName="UnitsOnOrder" />
+ − 1506 <ScalarProperty Name="ReorderLevel" ColumnName="ReorderLevel" />
+ − 1507 <ScalarProperty Name="Discontinued" ColumnName="Discontinued" />
+ − 1508 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1509 <EntitySetMapping Name="Regions"><EntityTypeMapping TypeName="NorthwindModel.Region"><MappingFragment StoreEntitySet="Region">
+ − 1510 <ScalarProperty Name="RegionID" ColumnName="RegionID" />
+ − 1511 <ScalarProperty Name="RegionDescription" ColumnName="RegionDescription" />
+ − 1512 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1513 <EntitySetMapping Name="Shippers"><EntityTypeMapping TypeName="NorthwindModel.Shipper"><MappingFragment StoreEntitySet="Shippers">
+ − 1514 <ScalarProperty Name="ShipperID" ColumnName="ShipperID" />
+ − 1515 <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
+ − 1516 <ScalarProperty Name="Phone" ColumnName="Phone" />
+ − 1517 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1518 <EntitySetMapping Name="Suppliers"><EntityTypeMapping TypeName="NorthwindModel.Supplier"><MappingFragment StoreEntitySet="Suppliers">
+ − 1519 <ScalarProperty Name="SupplierID" ColumnName="SupplierID" />
+ − 1520 <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
+ − 1521 <ScalarProperty Name="ContactName" ColumnName="ContactName" />
+ − 1522 <ScalarProperty Name="ContactTitle" ColumnName="ContactTitle" />
+ − 1523 <ScalarProperty Name="Address" ColumnName="Address" />
+ − 1524 <ScalarProperty Name="City" ColumnName="City" />
+ − 1525 <ScalarProperty Name="Region" ColumnName="Region" />
+ − 1526 <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
+ − 1527 <ScalarProperty Name="Country" ColumnName="Country" />
+ − 1528 <ScalarProperty Name="Phone" ColumnName="Phone" />
+ − 1529 <ScalarProperty Name="Fax" ColumnName="Fax" />
+ − 1530 <ScalarProperty Name="HomePage" ColumnName="HomePage" />
+ − 1531 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1532 <EntitySetMapping Name="sysdiagrams"><EntityTypeMapping TypeName="NorthwindModel.sysdiagram"><MappingFragment StoreEntitySet="sysdiagrams">
+ − 1533 <ScalarProperty Name="name" ColumnName="name" />
+ − 1534 <ScalarProperty Name="principal_id" ColumnName="principal_id" />
+ − 1535 <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
+ − 1536 <ScalarProperty Name="version" ColumnName="version" />
+ − 1537 <ScalarProperty Name="definition" ColumnName="definition" />
+ − 1538 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1539 <EntitySetMapping Name="Territories"><EntityTypeMapping TypeName="NorthwindModel.Territory"><MappingFragment StoreEntitySet="Territories">
+ − 1540 <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
+ − 1541 <ScalarProperty Name="TerritoryDescription" ColumnName="TerritoryDescription" />
+ − 1542 <ScalarProperty Name="RegionID" ColumnName="RegionID" />
+ − 1543 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1544 <EntitySetMapping Name="Alphabetical_list_of_products"><EntityTypeMapping TypeName="NorthwindModel.Alphabetical_list_of_product"><MappingFragment StoreEntitySet="Alphabetical list of products">
+ − 1545 <ScalarProperty Name="ProductID" ColumnName="ProductID" />
+ − 1546 <ScalarProperty Name="ProductName" ColumnName="ProductName" />
+ − 1547 <ScalarProperty Name="SupplierID" ColumnName="SupplierID" />
+ − 1548 <ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
+ − 1549 <ScalarProperty Name="QuantityPerUnit" ColumnName="QuantityPerUnit" />
+ − 1550 <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
+ − 1551 <ScalarProperty Name="UnitsInStock" ColumnName="UnitsInStock" />
+ − 1552 <ScalarProperty Name="UnitsOnOrder" ColumnName="UnitsOnOrder" />
+ − 1553 <ScalarProperty Name="ReorderLevel" ColumnName="ReorderLevel" />
+ − 1554 <ScalarProperty Name="Discontinued" ColumnName="Discontinued" />
+ − 1555 <ScalarProperty Name="CategoryName" ColumnName="CategoryName" />
+ − 1556 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1557 <EntitySetMapping Name="Category_Sales_for_1997"><EntityTypeMapping TypeName="NorthwindModel.Category_Sales_for_1997"><MappingFragment StoreEntitySet="Category Sales for 1997">
+ − 1558 <ScalarProperty Name="CategoryName" ColumnName="CategoryName" />
+ − 1559 <ScalarProperty Name="CategorySales" ColumnName="CategorySales" />
+ − 1560 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1561 <EntitySetMapping Name="Current_Product_Lists"><EntityTypeMapping TypeName="NorthwindModel.Current_Product_List"><MappingFragment StoreEntitySet="Current Product List">
+ − 1562 <ScalarProperty Name="ProductID" ColumnName="ProductID" />
+ − 1563 <ScalarProperty Name="ProductName" ColumnName="ProductName" />
+ − 1564 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1565 <EntitySetMapping Name="Customer_and_Suppliers_by_Cities"><EntityTypeMapping TypeName="NorthwindModel.Customer_and_Suppliers_by_City"><MappingFragment StoreEntitySet="Customer and Suppliers by City">
+ − 1566 <ScalarProperty Name="City" ColumnName="City" />
+ − 1567 <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
+ − 1568 <ScalarProperty Name="ContactName" ColumnName="ContactName" />
+ − 1569 <ScalarProperty Name="Relationship" ColumnName="Relationship" />
+ − 1570 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1571 <EntitySetMapping Name="Invoices"><EntityTypeMapping TypeName="NorthwindModel.Invoice"><MappingFragment StoreEntitySet="Invoices">
+ − 1572 <ScalarProperty Name="ShipName" ColumnName="ShipName" />
+ − 1573 <ScalarProperty Name="ShipAddress" ColumnName="ShipAddress" />
+ − 1574 <ScalarProperty Name="ShipCity" ColumnName="ShipCity" />
+ − 1575 <ScalarProperty Name="ShipRegion" ColumnName="ShipRegion" />
+ − 1576 <ScalarProperty Name="ShipPostalCode" ColumnName="ShipPostalCode" />
+ − 1577 <ScalarProperty Name="ShipCountry" ColumnName="ShipCountry" />
+ − 1578 <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
+ − 1579 <ScalarProperty Name="CustomerName" ColumnName="CustomerName" />
+ − 1580 <ScalarProperty Name="Address" ColumnName="Address" />
+ − 1581 <ScalarProperty Name="City" ColumnName="City" />
+ − 1582 <ScalarProperty Name="Region" ColumnName="Region" />
+ − 1583 <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
+ − 1584 <ScalarProperty Name="Country" ColumnName="Country" />
+ − 1585 <ScalarProperty Name="Salesperson" ColumnName="Salesperson" />
+ − 1586 <ScalarProperty Name="OrderID" ColumnName="OrderID" />
+ − 1587 <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
+ − 1588 <ScalarProperty Name="RequiredDate" ColumnName="RequiredDate" />
+ − 1589 <ScalarProperty Name="ShippedDate" ColumnName="ShippedDate" />
+ − 1590 <ScalarProperty Name="ShipperName" ColumnName="ShipperName" />
+ − 1591 <ScalarProperty Name="ProductID" ColumnName="ProductID" />
+ − 1592 <ScalarProperty Name="ProductName" ColumnName="ProductName" />
+ − 1593 <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
+ − 1594 <ScalarProperty Name="Quantity" ColumnName="Quantity" />
+ − 1595 <ScalarProperty Name="Discount" ColumnName="Discount" />
+ − 1596 <ScalarProperty Name="ExtendedPrice" ColumnName="ExtendedPrice" />
+ − 1597 <ScalarProperty Name="Freight" ColumnName="Freight" />
+ − 1598 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1599 <EntitySetMapping Name="Order_Details_Extendeds"><EntityTypeMapping TypeName="NorthwindModel.Order_Details_Extended"><MappingFragment StoreEntitySet="Order Details Extended">
+ − 1600 <ScalarProperty Name="OrderID" ColumnName="OrderID" />
+ − 1601 <ScalarProperty Name="ProductID" ColumnName="ProductID" />
+ − 1602 <ScalarProperty Name="ProductName" ColumnName="ProductName" />
+ − 1603 <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
+ − 1604 <ScalarProperty Name="Quantity" ColumnName="Quantity" />
+ − 1605 <ScalarProperty Name="Discount" ColumnName="Discount" />
+ − 1606 <ScalarProperty Name="ExtendedPrice" ColumnName="ExtendedPrice" />
+ − 1607 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1608 <EntitySetMapping Name="Order_Subtotals"><EntityTypeMapping TypeName="NorthwindModel.Order_Subtotal"><MappingFragment StoreEntitySet="Order Subtotals">
+ − 1609 <ScalarProperty Name="OrderID" ColumnName="OrderID" />
+ − 1610 <ScalarProperty Name="Subtotal" ColumnName="Subtotal" />
+ − 1611 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1612 <EntitySetMapping Name="Orders_Qries"><EntityTypeMapping TypeName="NorthwindModel.Orders_Qry"><MappingFragment StoreEntitySet="Orders Qry">
+ − 1613 <ScalarProperty Name="OrderID" ColumnName="OrderID" />
+ − 1614 <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
+ − 1615 <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
+ − 1616 <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
+ − 1617 <ScalarProperty Name="RequiredDate" ColumnName="RequiredDate" />
+ − 1618 <ScalarProperty Name="ShippedDate" ColumnName="ShippedDate" />
+ − 1619 <ScalarProperty Name="ShipVia" ColumnName="ShipVia" />
+ − 1620 <ScalarProperty Name="Freight" ColumnName="Freight" />
+ − 1621 <ScalarProperty Name="ShipName" ColumnName="ShipName" />
+ − 1622 <ScalarProperty Name="ShipAddress" ColumnName="ShipAddress" />
+ − 1623 <ScalarProperty Name="ShipCity" ColumnName="ShipCity" />
+ − 1624 <ScalarProperty Name="ShipRegion" ColumnName="ShipRegion" />
+ − 1625 <ScalarProperty Name="ShipPostalCode" ColumnName="ShipPostalCode" />
+ − 1626 <ScalarProperty Name="ShipCountry" ColumnName="ShipCountry" />
+ − 1627 <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
+ − 1628 <ScalarProperty Name="Address" ColumnName="Address" />
+ − 1629 <ScalarProperty Name="City" ColumnName="City" />
+ − 1630 <ScalarProperty Name="Region" ColumnName="Region" />
+ − 1631 <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
+ − 1632 <ScalarProperty Name="Country" ColumnName="Country" />
+ − 1633 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1634 <EntitySetMapping Name="Product_Sales_for_1997"><EntityTypeMapping TypeName="NorthwindModel.Product_Sales_for_1997"><MappingFragment StoreEntitySet="Product Sales for 1997">
+ − 1635 <ScalarProperty Name="CategoryName" ColumnName="CategoryName" />
+ − 1636 <ScalarProperty Name="ProductName" ColumnName="ProductName" />
+ − 1637 <ScalarProperty Name="ProductSales" ColumnName="ProductSales" />
+ − 1638 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1639 <EntitySetMapping Name="Products_Above_Average_Prices"><EntityTypeMapping TypeName="NorthwindModel.Products_Above_Average_Price"><MappingFragment StoreEntitySet="Products Above Average Price">
+ − 1640 <ScalarProperty Name="ProductName" ColumnName="ProductName" />
+ − 1641 <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
+ − 1642 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1643 <EntitySetMapping Name="Products_by_Categories"><EntityTypeMapping TypeName="NorthwindModel.Products_by_Category"><MappingFragment StoreEntitySet="Products by Category">
+ − 1644 <ScalarProperty Name="CategoryName" ColumnName="CategoryName" />
+ − 1645 <ScalarProperty Name="ProductName" ColumnName="ProductName" />
+ − 1646 <ScalarProperty Name="QuantityPerUnit" ColumnName="QuantityPerUnit" />
+ − 1647 <ScalarProperty Name="UnitsInStock" ColumnName="UnitsInStock" />
+ − 1648 <ScalarProperty Name="Discontinued" ColumnName="Discontinued" />
+ − 1649 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1650 <EntitySetMapping Name="Sales_by_Categories"><EntityTypeMapping TypeName="NorthwindModel.Sales_by_Category"><MappingFragment StoreEntitySet="Sales by Category">
+ − 1651 <ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
+ − 1652 <ScalarProperty Name="CategoryName" ColumnName="CategoryName" />
+ − 1653 <ScalarProperty Name="ProductName" ColumnName="ProductName" />
+ − 1654 <ScalarProperty Name="ProductSales" ColumnName="ProductSales" />
+ − 1655 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1656 <EntitySetMapping Name="Sales_Totals_by_Amounts"><EntityTypeMapping TypeName="NorthwindModel.Sales_Totals_by_Amount"><MappingFragment StoreEntitySet="Sales Totals by Amount">
+ − 1657 <ScalarProperty Name="SaleAmount" ColumnName="SaleAmount" />
+ − 1658 <ScalarProperty Name="OrderID" ColumnName="OrderID" />
+ − 1659 <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
+ − 1660 <ScalarProperty Name="ShippedDate" ColumnName="ShippedDate" />
+ − 1661 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1662 <EntitySetMapping Name="Summary_of_Sales_by_Quarters"><EntityTypeMapping TypeName="NorthwindModel.Summary_of_Sales_by_Quarter"><MappingFragment StoreEntitySet="Summary of Sales by Quarter">
+ − 1663 <ScalarProperty Name="ShippedDate" ColumnName="ShippedDate" />
+ − 1664 <ScalarProperty Name="OrderID" ColumnName="OrderID" />
+ − 1665 <ScalarProperty Name="Subtotal" ColumnName="Subtotal" />
+ − 1666 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1667 <EntitySetMapping Name="Summary_of_Sales_by_Years"><EntityTypeMapping TypeName="NorthwindModel.Summary_of_Sales_by_Year"><MappingFragment StoreEntitySet="Summary of Sales by Year">
+ − 1668 <ScalarProperty Name="ShippedDate" ColumnName="ShippedDate" />
+ − 1669 <ScalarProperty Name="OrderID" ColumnName="OrderID" />
+ − 1670 <ScalarProperty Name="Subtotal" ColumnName="Subtotal" />
+ − 1671 </MappingFragment></EntityTypeMapping></EntitySetMapping>
+ − 1672 <AssociationSetMapping Name="CustomerCustomerDemo" TypeName="NorthwindModel.CustomerCustomerDemo" StoreEntitySet="CustomerCustomerDemo">
+ − 1673 <EndProperty Name="CustomerDemographics">
+ − 1674 <ScalarProperty Name="CustomerTypeID" ColumnName="CustomerTypeID" />
+ − 1675 </EndProperty>
+ − 1676 <EndProperty Name="Customers">
+ − 1677 <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
+ − 1678 </EndProperty>
+ − 1679 </AssociationSetMapping>
+ − 1680 <AssociationSetMapping Name="EmployeeTerritories" TypeName="NorthwindModel.EmployeeTerritories" StoreEntitySet="EmployeeTerritories">
+ − 1681 <EndProperty Name="Employees">
+ − 1682 <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
+ − 1683 </EndProperty>
+ − 1684 <EndProperty Name="Territories">
+ − 1685 <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
+ − 1686 </EndProperty>
+ − 1687 </AssociationSetMapping>
+ − 1688 </EntityContainerMapping>
+ − 1689 </Mapping>
+ − 1690 </edmx:Mappings>
+ − 1691 </edmx:Runtime>
+ − 1692 <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
+ − 1693 <Designer xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
+ − 1694 <Connection>
+ − 1695 <DesignerInfoPropertySet>
+ − 1696 <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
+ − 1697 </DesignerInfoPropertySet>
+ − 1698 </Connection>
+ − 1699 <Options>
+ − 1700 <DesignerInfoPropertySet>
+ − 1701 <DesignerProperty Name="ValidateOnBuild" Value="true" />
+ − 1702 <DesignerProperty Name="EnablePluralization" Value="True" />
+ − 1703 <DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
+ − 1704 </DesignerInfoPropertySet>
+ − 1705 </Options>
+ − 1706 <!-- Diagram content (shape and connector positions) -->
+ − 1707 <Diagrams>
+ − 1708 <Diagram Name="NorthwindModel">
+ − 1709 <EntityTypeShape EntityType="NorthwindModel.Category" Width="1.5" PointX="8.125" PointY="14.75" Height="1.9802864583333317" IsExpanded="true" />
+ − 1710 <EntityTypeShape EntityType="NorthwindModel.CustomerDemographic" Width="1.5" PointX="0.75" PointY="2.5" Height="1.5956835937499996" IsExpanded="true" />
+ − 1711 <EntityTypeShape EntityType="NorthwindModel.Customer" Width="1.5" PointX="3" PointY="1.5" Height="3.5186979166666656" IsExpanded="true" />
+ − 1712 <EntityTypeShape EntityType="NorthwindModel.Employee" Width="1.5" PointX="3" PointY="9.25" Height="5.2494108072916674" IsExpanded="true" />
+ − 1713 <EntityTypeShape EntityType="NorthwindModel.Order_Detail" Width="1.5" PointX="7.5" PointY="2.125" Height="2.3648893229166656" IsExpanded="true" />
+ − 1714 <EntityTypeShape EntityType="NorthwindModel.Order" Width="1.5" PointX="5.25" PointY="1" Height="4.4802050781250031" IsExpanded="true" />
+ − 1715 <EntityTypeShape EntityType="NorthwindModel.Product" Width="1.5" PointX="10.375" PointY="16.125" Height="3.5186979166666674" IsExpanded="true" />
+ − 1716 <EntityTypeShape EntityType="NorthwindModel.Region" Width="1.5" PointX="5.75" PointY="7.125" Height="1.5956835937500005" IsExpanded="true" />
+ − 1717 <EntityTypeShape EntityType="NorthwindModel.Shipper" Width="1.5" PointX="3" PointY="15.25" Height="1.7879850260416674" IsExpanded="true" />
+ − 1718 <EntityTypeShape EntityType="NorthwindModel.Supplier" Width="1.5" PointX="8.125" PointY="17.5" Height="3.5186979166666674" IsExpanded="true" />
+ − 1719 <EntityTypeShape EntityType="NorthwindModel.sysdiagram" Width="1.5" PointX="7.75" PointY="5.75" Height="1.9802864583333353" IsExpanded="true" />
+ − 1720 <EntityTypeShape EntityType="NorthwindModel.Territory" Width="1.5" PointX="8" PointY="9.875" Height="1.9802864583333317" IsExpanded="true" />
+ − 1721 <EntityTypeShape EntityType="NorthwindModel.Alphabetical_list_of_product" Width="1.5" PointX="9.75" PointY="0.75" Height="3.1340950520833388" IsExpanded="true" />
+ − 1722 <EntityTypeShape EntityType="NorthwindModel.Category_Sales_for_1997" Width="1.5" PointX="0.75" PointY="6.75" Height="1.4033821614583388" IsExpanded="true" />
+ − 1723 <EntityTypeShape EntityType="NorthwindModel.Current_Product_List" Width="1.5" PointX="2.75" PointY="6.75" Height="1.4033821614583388" IsExpanded="true" />
+ − 1724 <EntityTypeShape EntityType="NorthwindModel.Customer_and_Suppliers_by_City" Width="1.5" PointX="9.75" PointY="4.75" Height="1.7879850260416674" IsExpanded="true" />
+ − 1725 <EntityTypeShape EntityType="NorthwindModel.Invoice" Width="1.5" PointX="10.75" PointY="7.75" Height="6.0186165364583388" IsExpanded="true" />
+ − 1726 <EntityTypeShape EntityType="NorthwindModel.Order_Details_Extended" Width="1.5" PointX="11.75" PointY="0.75" Height="2.3648893229166674" IsExpanded="true" />
+ − 1727 <EntityTypeShape EntityType="NorthwindModel.Order_Subtotal" Width="1.5" PointX="11.75" PointY="4.75" Height="1.4033821614583388" IsExpanded="true" />
+ − 1728 <EntityTypeShape EntityType="NorthwindModel.Orders_Qry" Width="1.5" PointX="5.75" PointY="12.75" Height="4.8648079427083317" IsExpanded="true" />
+ − 1729 <EntityTypeShape EntityType="NorthwindModel.Product_Sales_for_1997" Width="1.5" PointX="12.75" PointY="7.75" Height="1.5956835937500031" IsExpanded="true" />
+ − 1730 <EntityTypeShape EntityType="NorthwindModel.Products_Above_Average_Price" Width="1.5" PointX="7.75" PointY="12.75" Height="1.4033821614583282" IsExpanded="true" />
+ − 1731 <EntityTypeShape EntityType="NorthwindModel.Products_by_Category" Width="1.5" PointX="12.75" PointY="10.75" Height="1.9802864583333246" IsExpanded="true" />
+ − 1732 <EntityTypeShape EntityType="NorthwindModel.Sales_by_Category" Width="1.5" PointX="13.75" PointY="0.75" Height="1.7879850260416674" IsExpanded="true" />
+ − 1733 <EntityTypeShape EntityType="NorthwindModel.Sales_Totals_by_Amount" Width="1.5" PointX="13.75" PointY="3.75" Height="1.7879850260416674" IsExpanded="true" />
+ − 1734 <EntityTypeShape EntityType="NorthwindModel.Summary_of_Sales_by_Quarter" Width="1.5" PointX="12.75" PointY="13.75" Height="1.5956835937500102" IsExpanded="true" />
+ − 1735 <EntityTypeShape EntityType="NorthwindModel.Summary_of_Sales_by_Year" Width="1.5" PointX="14.75" PointY="6.75" Height="1.5956835937500102" IsExpanded="true" />
+ − 1736 <AssociationConnector Association="NorthwindModel.FK_Products_Categories" ManuallyRouted="false">
+ − 1737 <ConnectorPoint PointX="9.625" PointY="16.427643229166666" />
+ − 1738 <ConnectorPoint PointX="10.375" PointY="16.427643229166666" />
+ − 1739 </AssociationConnector>
+ − 1740 <AssociationConnector Association="NorthwindModel.FK_Orders_Customers" ManuallyRouted="false">
+ − 1741 <ConnectorPoint PointX="4.5" PointY="3.2593489583333328" />
+ − 1742 <ConnectorPoint PointX="4.791666666666667" PointY="3.2593489583333324" />
+ − 1743 <ConnectorPoint PointX="4.958333333333333" PointY="3.2593489583333328" />
+ − 1744 <ConnectorPoint PointX="5.25" PointY="3.2593489583333328" />
+ − 1745 </AssociationConnector>
+ − 1746 <AssociationConnector Association="NorthwindModel.FK_Employees_Employees" ManuallyRouted="false">
+ − 1747 <ConnectorPoint PointX="3.5319230769230767" PointY="14.499410807291667" />
+ − 1748 <ConnectorPoint PointX="3.5319230769230767" PointY="14.749410807291667" />
+ − 1749 <ConnectorPoint PointX="3.9784615384615383" PointY="14.749410807291667" />
+ − 1750 <ConnectorPoint PointX="3.9784615384615383" PointY="14.499410807291667" />
+ − 1751 </AssociationConnector>
+ − 1752 <AssociationConnector Association="NorthwindModel.FK_Orders_Employees" ManuallyRouted="false">
+ − 1753 <ConnectorPoint PointX="4.5" PointY="10.96875" />
+ − 1754 <ConnectorPoint PointX="4.791666666666667" PointY="10.96875" />
+ − 1755 <ConnectorPoint PointX="4.958333333333333" PointY="10.96875" />
+ − 1756 <ConnectorPoint PointX="5.46875" PointY="10.96875" />
+ − 1757 <ConnectorPoint PointX="5.46875" PointY="5.4802050781250031" />
+ − 1758 </AssociationConnector>
+ − 1759 <AssociationConnector Association="NorthwindModel.FK_Order_Details_Orders" ManuallyRouted="false">
+ − 1760 <ConnectorPoint PointX="6.75" PointY="3.3074446614583328" />
+ − 1761 <ConnectorPoint PointX="7.5" PointY="3.3074446614583328" />
+ − 1762 </AssociationConnector>
+ − 1763 <AssociationConnector Association="NorthwindModel.FK_Order_Details_Products" ManuallyRouted="false">
+ − 1764 <ConnectorPoint PointX="10.375" PointY="17.115143229166666" />
+ − 1765 <ConnectorPoint PointX="7.59375" PointY="17.115143229166666" />
+ − 1766 <ConnectorPoint PointX="7.59375" PointY="4.4898893229166656" />
+ − 1767 </AssociationConnector>
+ − 1768 <AssociationConnector Association="NorthwindModel.FK_Orders_Shippers" ManuallyRouted="false">
+ − 1769 <ConnectorPoint PointX="4.5" PointY="15.251152846153847" />
+ − 1770 <ConnectorPoint PointX="4.875" PointY="14.876152846153847" />
+ − 1771 <ConnectorPoint PointX="4.875" PointY="2.0984224791666657" />
+ − 1772 <ConnectorPoint PointX="5.25" PointY="2.0984224791666657" />
+ − 1773 </AssociationConnector>
+ − 1774 <AssociationConnector Association="NorthwindModel.FK_Products_Suppliers" ManuallyRouted="false">
+ − 1775 <ConnectorPoint PointX="9.625" PointY="18.571848958333334" />
+ − 1776 <ConnectorPoint PointX="10.375" PointY="18.571848958333334" />
+ − 1777 </AssociationConnector>
+ − 1778 <AssociationConnector Association="NorthwindModel.FK_Territories_Region" ManuallyRouted="false">
+ − 1779 <ConnectorPoint PointX="6.5" PointY="8.72068359375" />
+ − 1780 <ConnectorPoint PointX="6.5" PointY="10.865143229166666" />
+ − 1781 <ConnectorPoint PointX="7.510416666666667" PointY="10.865143229166666" />
+ − 1782 <ConnectorPoint PointX="7.677083333333333" PointY="10.865143229166666" />
+ − 1783 <ConnectorPoint PointX="8" PointY="10.865143229166666" />
+ − 1784 </AssociationConnector>
+ − 1785 <AssociationConnector Association="NorthwindModel.CustomerCustomerDemo" ManuallyRouted="false">
+ − 1786 <ConnectorPoint PointX="2.25" PointY="3.297841796875" />
+ − 1787 <ConnectorPoint PointX="3" PointY="3.297841796875" />
+ − 1788 </AssociationConnector>
+ − 1789 <AssociationConnector Association="NorthwindModel.EmployeeTerritories" ManuallyRouted="false">
+ − 1790 <ConnectorPoint PointX="4.5" PointY="11.327694740639076" />
+ − 1791 <ConnectorPoint PointX="4.9375" PointY="11.327694740639076" />
+ − 1792 <ConnectorPoint PointX="4.9375" PointY="11.318800799589202" />
+ − 1793 <ConnectorPoint PointX="7.510416666666667" PointY="11.318800799589202" />
+ − 1794 <ConnectorPoint PointX="7.677083333333333" PointY="11.318800799589202" />
+ − 1795 <ConnectorPoint PointX="8" PointY="11.318800799589202" />
+ − 1796 </AssociationConnector>
+ − 1797 </Diagram>
+ − 1798 </Diagrams>
+ − 1799 </Designer>
+ − 1800 </edmx:Edmx>