Mercurial > pub > bltoolkit

comparison Demo/WebServices/NorthwindDataService/NorthwindModel.edmx @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:f990fcb411a9
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>