annotate Demo/WebServices/NorthwindDataService/NorthwindModel.edmx @ 1:8f65451dc28f

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