BaseModel.edmx 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179
  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="Cancelar2024Model.Store" 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="Manufacturer">
  9. <Key>
  10. <PropertyRef Name="IdManufacturer" />
  11. </Key>
  12. <Property Name="IdManufacturer" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="TitleManufacturer" Type="nvarchar" MaxLength="50" />
  14. </EntityType>
  15. <EntityType Name="Product">
  16. <Key>
  17. <PropertyRef Name="ProductArticleNumber" />
  18. </Key>
  19. <Property Name="ProductArticleNumber" Type="nvarchar" MaxLength="100" Nullable="false" />
  20. <Property Name="ProductName" Type="nvarchar(max)" Nullable="false" />
  21. <Property Name="ProductCost" Type="decimal" Precision="19" Scale="4" Nullable="false" />
  22. <Property Name="ProductDiscountMax" Type="tinyint" />
  23. <Property Name="IdManufacturer" Type="int" Nullable="false" />
  24. <Property Name="ProductDiscountAmount" Type="tinyint" />
  25. <Property Name="ProductQuantityInStock" Type="int" Nullable="false" />
  26. <Property Name="ProductDescription" Type="nvarchar(max)" Nullable="false" />
  27. </EntityType>
  28. <EntityType Name="sysdiagrams">
  29. <Key>
  30. <PropertyRef Name="diagram_id" />
  31. </Key>
  32. <Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" />
  33. <Property Name="principal_id" Type="int" Nullable="false" />
  34. <Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  35. <Property Name="version" Type="int" />
  36. <Property Name="definition" Type="varbinary(max)" />
  37. </EntityType>
  38. <Association Name="FK_Product_Manufacturer">
  39. <End Role="Manufacturer" Type="Self.Manufacturer" Multiplicity="1" />
  40. <End Role="Product" Type="Self.Product" Multiplicity="*" />
  41. <ReferentialConstraint>
  42. <Principal Role="Manufacturer">
  43. <PropertyRef Name="IdManufacturer" />
  44. </Principal>
  45. <Dependent Role="Product">
  46. <PropertyRef Name="IdManufacturer" />
  47. </Dependent>
  48. </ReferentialConstraint>
  49. </Association>
  50. <EntityContainer Name="Cancelar2024ModelStoreContainer">
  51. <EntitySet Name="Manufacturer" EntityType="Self.Manufacturer" Schema="dbo" store:Type="Tables" />
  52. <EntitySet Name="Product" EntityType="Self.Product" Schema="dbo" store:Type="Tables" />
  53. <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
  54. <AssociationSet Name="FK_Product_Manufacturer" Association="Self.FK_Product_Manufacturer">
  55. <End Role="Manufacturer" EntitySet="Manufacturer" />
  56. <End Role="Product" EntitySet="Product" />
  57. </AssociationSet>
  58. </EntityContainer>
  59. </Schema>
  60. </edmx:StorageModels>
  61. <!-- CSDL content -->
  62. <edmx:ConceptualModels>
  63. <Schema Namespace="Cancelar2024Model" 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">
  64. <EntityType Name="Manufacturer">
  65. <Key>
  66. <PropertyRef Name="IdManufacturer" />
  67. </Key>
  68. <Property Name="IdManufacturer" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  69. <Property Name="TitleManufacturer" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  70. <NavigationProperty Name="Products" Relationship="Self.FK_Product_Manufacturer" FromRole="Manufacturer" ToRole="Product" />
  71. </EntityType>
  72. <EntityType Name="Product">
  73. <Key>
  74. <PropertyRef Name="ProductArticleNumber" />
  75. </Key>
  76. <Property Name="ProductArticleNumber" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
  77. <Property Name="ProductName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
  78. <Property Name="ProductCost" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
  79. <Property Name="ProductDiscountMax" Type="Byte" />
  80. <Property Name="IdManufacturer" Type="Int32" Nullable="false" />
  81. <Property Name="ProductDiscountAmount" Type="Byte" />
  82. <Property Name="ProductQuantityInStock" Type="Int32" Nullable="false" />
  83. <Property Name="ProductDescription" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
  84. <NavigationProperty Name="Manufacturer" Relationship="Self.FK_Product_Manufacturer" FromRole="Product" ToRole="Manufacturer" />
  85. </EntityType>
  86. <EntityType Name="sysdiagram">
  87. <Key>
  88. <PropertyRef Name="diagram_id" />
  89. </Key>
  90. <Property Name="name" Type="String" MaxLength="128" FixedLength="false" Unicode="true" Nullable="false" />
  91. <Property Name="principal_id" Type="Int32" Nullable="false" />
  92. <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  93. <Property Name="version" Type="Int32" />
  94. <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
  95. </EntityType>
  96. <Association Name="FK_Product_Manufacturer">
  97. <End Role="Manufacturer" Type="Self.Manufacturer" Multiplicity="1" />
  98. <End Role="Product" Type="Self.Product" Multiplicity="*" />
  99. <ReferentialConstraint>
  100. <Principal Role="Manufacturer">
  101. <PropertyRef Name="IdManufacturer" />
  102. </Principal>
  103. <Dependent Role="Product">
  104. <PropertyRef Name="IdManufacturer" />
  105. </Dependent>
  106. </ReferentialConstraint>
  107. </Association>
  108. <EntityContainer Name="Cancelar2024Entities" annotation:LazyLoadingEnabled="true">
  109. <EntitySet Name="Manufacturers" EntityType="Self.Manufacturer" />
  110. <EntitySet Name="Products" EntityType="Self.Product" />
  111. <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagram" />
  112. <AssociationSet Name="FK_Product_Manufacturer" Association="Self.FK_Product_Manufacturer">
  113. <End Role="Manufacturer" EntitySet="Manufacturers" />
  114. <End Role="Product" EntitySet="Products" />
  115. </AssociationSet>
  116. </EntityContainer>
  117. </Schema>
  118. </edmx:ConceptualModels>
  119. <!-- C-S mapping content -->
  120. <edmx:Mappings>
  121. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  122. <EntityContainerMapping StorageEntityContainer="Cancelar2024ModelStoreContainer" CdmEntityContainer="Cancelar2024Entities">
  123. <EntitySetMapping Name="Manufacturers">
  124. <EntityTypeMapping TypeName="Cancelar2024Model.Manufacturer">
  125. <MappingFragment StoreEntitySet="Manufacturer">
  126. <ScalarProperty Name="IdManufacturer" ColumnName="IdManufacturer" />
  127. <ScalarProperty Name="TitleManufacturer" ColumnName="TitleManufacturer" />
  128. </MappingFragment>
  129. </EntityTypeMapping>
  130. </EntitySetMapping>
  131. <EntitySetMapping Name="Products">
  132. <EntityTypeMapping TypeName="Cancelar2024Model.Product">
  133. <MappingFragment StoreEntitySet="Product">
  134. <ScalarProperty Name="ProductArticleNumber" ColumnName="ProductArticleNumber" />
  135. <ScalarProperty Name="ProductName" ColumnName="ProductName" />
  136. <ScalarProperty Name="ProductCost" ColumnName="ProductCost" />
  137. <ScalarProperty Name="ProductDiscountMax" ColumnName="ProductDiscountMax" />
  138. <ScalarProperty Name="IdManufacturer" ColumnName="IdManufacturer" />
  139. <ScalarProperty Name="ProductDiscountAmount" ColumnName="ProductDiscountAmount" />
  140. <ScalarProperty Name="ProductQuantityInStock" ColumnName="ProductQuantityInStock" />
  141. <ScalarProperty Name="ProductDescription" ColumnName="ProductDescription" />
  142. </MappingFragment>
  143. </EntityTypeMapping>
  144. </EntitySetMapping>
  145. <EntitySetMapping Name="sysdiagrams">
  146. <EntityTypeMapping TypeName="Cancelar2024Model.sysdiagram">
  147. <MappingFragment StoreEntitySet="sysdiagrams">
  148. <ScalarProperty Name="name" ColumnName="name" />
  149. <ScalarProperty Name="principal_id" ColumnName="principal_id" />
  150. <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
  151. <ScalarProperty Name="version" ColumnName="version" />
  152. <ScalarProperty Name="definition" ColumnName="definition" />
  153. </MappingFragment>
  154. </EntityTypeMapping>
  155. </EntitySetMapping>
  156. </EntityContainerMapping>
  157. </Mapping>
  158. </edmx:Mappings>
  159. </edmx:Runtime>
  160. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  161. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  162. <Connection>
  163. <DesignerInfoPropertySet>
  164. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  165. </DesignerInfoPropertySet>
  166. </Connection>
  167. <Options>
  168. <DesignerInfoPropertySet>
  169. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  170. <DesignerProperty Name="EnablePluralization" Value="true" />
  171. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  172. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  173. <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
  174. </DesignerInfoPropertySet>
  175. </Options>
  176. <!-- Diagram content (shape and connector positions) -->
  177. <Diagrams></Diagrams>
  178. </Designer>
  179. </edmx:Edmx>