Model1.edmx 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155
  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="Хранилище P_ShabaninModel" 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="Book">
  9. <Key>
  10. <PropertyRef Name="Id" />
  11. </Key>
  12. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="Title" Type="varchar" MaxLength="1000" Nullable="false" />
  14. <Property Name="Style" Type="varchar" MaxLength="100" Nullable="false" />
  15. <Property Name="Author" Type="varchar" MaxLength="1000" Nullable="false" />
  16. <Property Name="Cost" Type="varchar" MaxLength="100" Nullable="false" />
  17. <Property Name="Store" Type="int" Nullable="false" />
  18. <Property Name="Stock" Type="int" Nullable="false" />
  19. <Property Name="Description" Type="varchar" MaxLength="3500" Nullable="false" />
  20. <Property Name="Img" Type="varchar" MaxLength="100" Nullable="false" />
  21. </EntityType>
  22. <EntityType Name="BuyOrder">
  23. <Key>
  24. <PropertyRef Name="id" />
  25. </Key>
  26. <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  27. <Property Name="IdBook" Type="int" Nullable="false" />
  28. <Property Name="Count" Type="int" Nullable="false" />
  29. <Property Name="DateOrder" Type="date" Nullable="false" />
  30. </EntityType>
  31. <Association Name="FK_BuyOrder_Book">
  32. <End Role="Book" Type="Self.Book" Multiplicity="1" />
  33. <End Role="BuyOrder" Type="Self.BuyOrder" Multiplicity="*" />
  34. <ReferentialConstraint>
  35. <Principal Role="Book">
  36. <PropertyRef Name="Id" />
  37. </Principal>
  38. <Dependent Role="BuyOrder">
  39. <PropertyRef Name="IdBook" />
  40. </Dependent>
  41. </ReferentialConstraint>
  42. </Association>
  43. <EntityContainer Name="Хранилище P_ShabaninModelContainer">
  44. <EntitySet Name="Book" EntityType="Self.Book" Schema="dbo" store:Type="Tables" />
  45. <EntitySet Name="BuyOrder" EntityType="Self.BuyOrder" Schema="dbo" store:Type="Tables" />
  46. <AssociationSet Name="FK_BuyOrder_Book" Association="Self.FK_BuyOrder_Book">
  47. <End Role="Book" EntitySet="Book" />
  48. <End Role="BuyOrder" EntitySet="BuyOrder" />
  49. </AssociationSet>
  50. </EntityContainer>
  51. </Schema>
  52. </edmx:StorageModels>
  53. <!-- CSDL content -->
  54. <edmx:ConceptualModels>
  55. <Schema Namespace="P_ShabaninModel" 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">
  56. <EntityType Name="Book">
  57. <Key>
  58. <PropertyRef Name="Id" />
  59. </Key>
  60. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  61. <Property Name="Title" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" Nullable="false" />
  62. <Property Name="Style" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
  63. <Property Name="Author" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" Nullable="false" />
  64. <Property Name="Cost" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
  65. <Property Name="Store" Type="Int32" Nullable="false" />
  66. <Property Name="Stock" Type="Int32" Nullable="false" />
  67. <Property Name="Description" Type="String" MaxLength="3500" FixedLength="false" Unicode="false" Nullable="false" />
  68. <Property Name="Img" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
  69. <NavigationProperty Name="BuyOrder" Relationship="Self.FK_BuyOrder_Book" FromRole="Book" ToRole="BuyOrder" />
  70. </EntityType>
  71. <EntityType Name="BuyOrder">
  72. <Key>
  73. <PropertyRef Name="id" />
  74. </Key>
  75. <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  76. <Property Name="IdBook" Type="Int32" Nullable="false" />
  77. <Property Name="Count" Type="Int32" Nullable="false" />
  78. <Property Name="DateOrder" Type="DateTime" Nullable="false" Precision="0" />
  79. <NavigationProperty Name="Book" Relationship="Self.FK_BuyOrder_Book" FromRole="BuyOrder" ToRole="Book" />
  80. </EntityType>
  81. <Association Name="FK_BuyOrder_Book">
  82. <End Role="Book" Type="Self.Book" Multiplicity="1" />
  83. <End Role="BuyOrder" Type="Self.BuyOrder" Multiplicity="*" />
  84. <ReferentialConstraint>
  85. <Principal Role="Book">
  86. <PropertyRef Name="Id" />
  87. </Principal>
  88. <Dependent Role="BuyOrder">
  89. <PropertyRef Name="IdBook" />
  90. </Dependent>
  91. </ReferentialConstraint>
  92. </Association>
  93. <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
  94. <EntitySet Name="Book" EntityType="Self.Book" />
  95. <EntitySet Name="BuyOrder" EntityType="Self.BuyOrder" />
  96. <AssociationSet Name="FK_BuyOrder_Book" Association="Self.FK_BuyOrder_Book">
  97. <End Role="Book" EntitySet="Book" />
  98. <End Role="BuyOrder" EntitySet="BuyOrder" />
  99. </AssociationSet>
  100. </EntityContainer>
  101. </Schema>
  102. </edmx:ConceptualModels>
  103. <!-- C-S mapping content -->
  104. <edmx:Mappings>
  105. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  106. <EntityContainerMapping StorageEntityContainer="Хранилище P_ShabaninModelContainer" CdmEntityContainer="Entities">
  107. <EntitySetMapping Name="Book">
  108. <EntityTypeMapping TypeName="P_ShabaninModel.Book">
  109. <MappingFragment StoreEntitySet="Book">
  110. <ScalarProperty Name="Id" ColumnName="Id" />
  111. <ScalarProperty Name="Title" ColumnName="Title" />
  112. <ScalarProperty Name="Style" ColumnName="Style" />
  113. <ScalarProperty Name="Author" ColumnName="Author" />
  114. <ScalarProperty Name="Cost" ColumnName="Cost" />
  115. <ScalarProperty Name="Store" ColumnName="Store" />
  116. <ScalarProperty Name="Stock" ColumnName="Stock" />
  117. <ScalarProperty Name="Description" ColumnName="Description" />
  118. <ScalarProperty Name="Img" ColumnName="Img" />
  119. </MappingFragment>
  120. </EntityTypeMapping>
  121. </EntitySetMapping>
  122. <EntitySetMapping Name="BuyOrder">
  123. <EntityTypeMapping TypeName="P_ShabaninModel.BuyOrder">
  124. <MappingFragment StoreEntitySet="BuyOrder">
  125. <ScalarProperty Name="id" ColumnName="id" />
  126. <ScalarProperty Name="IdBook" ColumnName="IdBook" />
  127. <ScalarProperty Name="Count" ColumnName="Count" />
  128. <ScalarProperty Name="DateOrder" ColumnName="DateOrder" />
  129. </MappingFragment>
  130. </EntityTypeMapping>
  131. </EntitySetMapping>
  132. </EntityContainerMapping>
  133. </Mapping>
  134. </edmx:Mappings>
  135. </edmx:Runtime>
  136. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  137. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  138. <Connection>
  139. <DesignerInfoPropertySet>
  140. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  141. </DesignerInfoPropertySet>
  142. </Connection>
  143. <Options>
  144. <DesignerInfoPropertySet>
  145. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  146. <DesignerProperty Name="EnablePluralization" Value="false" />
  147. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  148. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  149. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  150. </DesignerInfoPropertySet>
  151. </Options>
  152. <!-- Diagram content (shape and connector positions) -->
  153. <Diagrams></Diagrams>
  154. </Designer>
  155. </edmx:Edmx>