-
Notifications
You must be signed in to change notification settings - Fork 14
/
northwind.edmx
67 lines (67 loc) · 3.37 KB
/
northwind.edmx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="4.0" xmlns:edmx="https://docs.oasis-open.org/odata/ns/edmx">
<edmx:DataServices>
<Schema Namespace="NorthwindModel" xmlns="https://docs.oasis-open.org/odata/ns/edm">
<EntityContainer Name="EntityContainer">
<EntitySet Name="Products" EntityType="NorthwindModel.Products">
<NavigationPropertyBinding Path="Category" Target="Categories"/>
<NavigationPropertyBinding Path="Supplier" Target="Suppliers"/>
</EntitySet>
<EntitySet Name="Suppliers" EntityType="NorthwindModel.Suppliers">
<NavigationPropertyBinding Path="Products" Target="Products"/>
</EntitySet>
<EntitySet Name="Categories" EntityType="NorthwindModel.Categories">
<NavigationPropertyBinding Path="Products" Target="Products"/>
</EntitySet>
</EntityContainer>
<EntityType Name="Products">
<Key>
<PropertyRef Name="ProductID"/>
</Key>
<Property Name="ProductID" Type="Edm.Int32" Nullable="false"/>
<Property Name="ProductName" Type="Edm.String"/>
<Property Name="QuantityPerUnit" Type="Edm.String"/>
<Property Name="UnitPrice" Type="Edm.Decimal" Scale="variable"/>
<NavigationProperty Name="Category" Type="NorthwindModel.Categories" Partner="Products">
<ReferentialConstraint Property="Category_CategoryID" ReferencedProperty="CategoryID"/>
</NavigationProperty>
<Property Name="Category_CategoryID" Type="Edm.Int32"/>
<NavigationProperty Name="Supplier" Type="NorthwindModel.Suppliers" Partner="Products">
<ReferentialConstraint Property="Supplier_SupplierID" ReferencedProperty="SupplierID"/>
</NavigationProperty>
<Property Name="Supplier_SupplierID" Type="Edm.Int32"/>
<Property Name="UnitsInStock" Type="Edm.Int32"/>
<Property Name="UnitsOnOrder" Type="Edm.Int32"/>
<Property Name="ReorderLevel" Type="Edm.Int32"/>
<Property Name="Discontinued" Type="Edm.Boolean"/>
</EntityType>
<EntityType Name="Suppliers">
<Key>
<PropertyRef Name="SupplierID"/>
</Key>
<Property Name="SupplierID" Type="Edm.Int32" Nullable="false"/>
<Property Name="CompanyName" Type="Edm.String"/>
<Property Name="ContactName" Type="Edm.String"/>
<Property Name="ContactTitle" Type="Edm.String"/>
<Property Name="Address" Type="Edm.String"/>
<Property Name="City" Type="Edm.String"/>
<Property Name="Region" Type="Edm.String"/>
<Property Name="PostalCode" Type="Edm.String"/>
<Property Name="Country" Type="Edm.String"/>
<Property Name="Phone" Type="Edm.String"/>
<Property Name="Fax" Type="Edm.String"/>
<Property Name="HomePage" Type="Edm.String"/>
<NavigationProperty Name="Products" Type="Collection(NorthwindModel.Products)" Partner="Supplier"/>
</EntityType>
<EntityType Name="Categories">
<Key>
<PropertyRef Name="CategoryID"/>
</Key>
<Property Name="CategoryID" Type="Edm.Int32" Nullable="false"/>
<Property Name="CategoryName" Type="Edm.String"/>
<Property Name="Description" Type="Edm.String"/>
<NavigationProperty Name="Products" Type="Collection(NorthwindModel.Products)" Partner="Category"/>
</EntityType>
</Schema>
</edmx:DataServices>
</edmx:Edmx>