Model1.edmx 9.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  3. <!-- EF Runtime content -->
  4. <edmx:Runtime>
  5. <!-- SSDL content -->
  6. <edmx:StorageModels>
  7. <Schema Namespace="Хранилище B0Model" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
  8. <EntityType Name="Dish">
  9. <Key>
  10. <PropertyRef Name="id" />
  11. </Key>
  12. <Property Name="id" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="name" Type="varchar" MaxLength="50" Nullable="false" />
  14. </EntityType>
  15. <EntityType Name="DishCompound">
  16. <Key>
  17. <PropertyRef Name="dish" />
  18. <PropertyRef Name="ingredient" />
  19. </Key>
  20. <Property Name="dish" Type="bigint" Nullable="false" />
  21. <Property Name="ingredient" Type="bigint" Nullable="false" />
  22. <Property Name="volume" Type="float" Nullable="false" />
  23. </EntityType>
  24. <EntityType Name="Ingredient">
  25. <Key>
  26. <PropertyRef Name="id" />
  27. </Key>
  28. <Property Name="id" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
  29. <Property Name="name" Type="varchar" MaxLength="50" Nullable="false" />
  30. </EntityType>
  31. <Association Name="FK_DishCompound_Dish">
  32. <End Role="Dish" Type="Self.Dish" Multiplicity="1" />
  33. <End Role="DishCompound" Type="Self.DishCompound" Multiplicity="*" />
  34. <ReferentialConstraint>
  35. <Principal Role="Dish">
  36. <PropertyRef Name="id" />
  37. </Principal>
  38. <Dependent Role="DishCompound">
  39. <PropertyRef Name="dish" />
  40. </Dependent>
  41. </ReferentialConstraint>
  42. </Association>
  43. <Association Name="FK_DishCompound_Ingredient">
  44. <End Role="Ingredient" Type="Self.Ingredient" Multiplicity="1" />
  45. <End Role="DishCompound" Type="Self.DishCompound" Multiplicity="*" />
  46. <ReferentialConstraint>
  47. <Principal Role="Ingredient">
  48. <PropertyRef Name="id" />
  49. </Principal>
  50. <Dependent Role="DishCompound">
  51. <PropertyRef Name="ingredient" />
  52. </Dependent>
  53. </ReferentialConstraint>
  54. </Association>
  55. <EntityContainer Name="Хранилище B0ModelContainer">
  56. <EntitySet Name="Dish" EntityType="Self.Dish" Schema="dbo" store:Type="Tables" />
  57. <EntitySet Name="DishCompound" EntityType="Self.DishCompound" Schema="dbo" store:Type="Tables" />
  58. <EntitySet Name="Ingredient" EntityType="Self.Ingredient" Schema="dbo" store:Type="Tables" />
  59. <AssociationSet Name="FK_DishCompound_Dish" Association="Self.FK_DishCompound_Dish">
  60. <End Role="Dish" EntitySet="Dish" />
  61. <End Role="DishCompound" EntitySet="DishCompound" />
  62. </AssociationSet>
  63. <AssociationSet Name="FK_DishCompound_Ingredient" Association="Self.FK_DishCompound_Ingredient">
  64. <End Role="Ingredient" EntitySet="Ingredient" />
  65. <End Role="DishCompound" EntitySet="DishCompound" />
  66. </AssociationSet>
  67. </EntityContainer>
  68. </Schema>
  69. </edmx:StorageModels>
  70. <!-- CSDL content -->
  71. <edmx:ConceptualModels>
  72. <Schema Namespace="B0Model" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
  73. <EntityType Name="Dish">
  74. <Key>
  75. <PropertyRef Name="id" />
  76. </Key>
  77. <Property Name="id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  78. <Property Name="name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
  79. <NavigationProperty Name="DishCompound" Relationship="Self.FK_DishCompound_Dish" FromRole="Dish" ToRole="DishCompound" />
  80. </EntityType>
  81. <EntityType Name="DishCompound">
  82. <Key>
  83. <PropertyRef Name="dish" />
  84. <PropertyRef Name="ingredient" />
  85. </Key>
  86. <Property Name="dish" Type="Int64" Nullable="false" />
  87. <Property Name="ingredient" Type="Int64" Nullable="false" />
  88. <Property Name="volume" Type="Double" Nullable="false" />
  89. <NavigationProperty Name="Dish1" Relationship="Self.FK_DishCompound_Dish" FromRole="DishCompound" ToRole="Dish" />
  90. <NavigationProperty Name="Ingredient1" Relationship="Self.FK_DishCompound_Ingredient" FromRole="DishCompound" ToRole="Ingredient" />
  91. </EntityType>
  92. <EntityType Name="Ingredient">
  93. <Key>
  94. <PropertyRef Name="id" />
  95. </Key>
  96. <Property Name="id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  97. <Property Name="name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
  98. <NavigationProperty Name="DishCompound" Relationship="Self.FK_DishCompound_Ingredient" FromRole="Ingredient" ToRole="DishCompound" />
  99. </EntityType>
  100. <Association Name="FK_DishCompound_Dish">
  101. <End Role="Dish" Type="Self.Dish" Multiplicity="1" />
  102. <End Role="DishCompound" Type="Self.DishCompound" Multiplicity="*" />
  103. <ReferentialConstraint>
  104. <Principal Role="Dish">
  105. <PropertyRef Name="id" />
  106. </Principal>
  107. <Dependent Role="DishCompound">
  108. <PropertyRef Name="dish" />
  109. </Dependent>
  110. </ReferentialConstraint>
  111. </Association>
  112. <Association Name="FK_DishCompound_Ingredient">
  113. <End Role="Ingredient" Type="Self.Ingredient" Multiplicity="1" />
  114. <End Role="DishCompound" Type="Self.DishCompound" Multiplicity="*" />
  115. <ReferentialConstraint>
  116. <Principal Role="Ingredient">
  117. <PropertyRef Name="id" />
  118. </Principal>
  119. <Dependent Role="DishCompound">
  120. <PropertyRef Name="ingredient" />
  121. </Dependent>
  122. </ReferentialConstraint>
  123. </Association>
  124. <EntityContainer Name="B0Entities" annotation:LazyLoadingEnabled="true">
  125. <EntitySet Name="Dish" EntityType="Self.Dish" />
  126. <EntitySet Name="DishCompound" EntityType="Self.DishCompound" />
  127. <EntitySet Name="Ingredient" EntityType="Self.Ingredient" />
  128. <AssociationSet Name="FK_DishCompound_Dish" Association="Self.FK_DishCompound_Dish">
  129. <End Role="Dish" EntitySet="Dish" />
  130. <End Role="DishCompound" EntitySet="DishCompound" />
  131. </AssociationSet>
  132. <AssociationSet Name="FK_DishCompound_Ingredient" Association="Self.FK_DishCompound_Ingredient">
  133. <End Role="Ingredient" EntitySet="Ingredient" />
  134. <End Role="DishCompound" EntitySet="DishCompound" />
  135. </AssociationSet>
  136. </EntityContainer>
  137. </Schema>
  138. </edmx:ConceptualModels>
  139. <!-- C-S mapping content -->
  140. <edmx:Mappings>
  141. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  142. <EntityContainerMapping StorageEntityContainer="Хранилище B0ModelContainer" CdmEntityContainer="B0Entities">
  143. <EntitySetMapping Name="Dish">
  144. <EntityTypeMapping TypeName="B0Model.Dish">
  145. <MappingFragment StoreEntitySet="Dish">
  146. <ScalarProperty Name="id" ColumnName="id" />
  147. <ScalarProperty Name="name" ColumnName="name" />
  148. </MappingFragment>
  149. </EntityTypeMapping>
  150. </EntitySetMapping>
  151. <EntitySetMapping Name="DishCompound">
  152. <EntityTypeMapping TypeName="B0Model.DishCompound">
  153. <MappingFragment StoreEntitySet="DishCompound">
  154. <ScalarProperty Name="dish" ColumnName="dish" />
  155. <ScalarProperty Name="ingredient" ColumnName="ingredient" />
  156. <ScalarProperty Name="volume" ColumnName="volume" />
  157. </MappingFragment>
  158. </EntityTypeMapping>
  159. </EntitySetMapping>
  160. <EntitySetMapping Name="Ingredient">
  161. <EntityTypeMapping TypeName="B0Model.Ingredient">
  162. <MappingFragment StoreEntitySet="Ingredient">
  163. <ScalarProperty Name="id" ColumnName="id" />
  164. <ScalarProperty Name="name" ColumnName="name" />
  165. </MappingFragment>
  166. </EntityTypeMapping>
  167. </EntitySetMapping>
  168. </EntityContainerMapping>
  169. </Mapping>
  170. </edmx:Mappings>
  171. </edmx:Runtime>
  172. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  173. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  174. <Connection>
  175. <DesignerInfoPropertySet>
  176. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  177. </DesignerInfoPropertySet>
  178. </Connection>
  179. <Options>
  180. <DesignerInfoPropertySet>
  181. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  182. <DesignerProperty Name="EnablePluralization" Value="false" />
  183. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  184. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  185. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  186. </DesignerInfoPropertySet>
  187. </Options>
  188. <!-- Diagram content (shape and connector positions) -->
  189. <Diagrams></Diagrams>
  190. </Designer>
  191. </edmx:Edmx>