EDM.edmx 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208
  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="MyTestsDataBaseModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2012" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
  8. <EntityContainer Name="MyTestsDataBaseModelStoreContainer">
  9. <EntitySet Name="Questions" EntityType="MyTestsDataBaseModel.Store.Questions" store:Type="Tables" Schema="dbo" />
  10. <EntitySet Name="Tests" EntityType="MyTestsDataBaseModel.Store.Tests" store:Type="Tables" Schema="dbo" />
  11. <EntitySet Name="Users" EntityType="MyTestsDataBaseModel.Store.Users" store:Type="Tables" Schema="dbo" />
  12. <AssociationSet Name="FK_Questions_Tests" Association="MyTestsDataBaseModel.Store.FK_Questions_Tests">
  13. <End Role="Tests" EntitySet="Tests" />
  14. <End Role="Questions" EntitySet="Questions" />
  15. </AssociationSet>
  16. <AssociationSet Name="FK_Tests_Users" Association="MyTestsDataBaseModel.Store.FK_Tests_Users">
  17. <End Role="Users" EntitySet="Users" />
  18. <End Role="Tests" EntitySet="Tests" />
  19. </AssociationSet>
  20. </EntityContainer>
  21. <EntityType Name="Questions">
  22. <Key>
  23. <PropertyRef Name="IdQuestion" />
  24. </Key>
  25. <Property Name="IdQuestion" Type="int" Nullable="false" />
  26. <Property Name="IdTest" Type="int" Nullable="false" />
  27. <Property Name="Content" Type="nvarchar" Nullable="false" MaxLength="150" />
  28. <Property Name="Answer" Type="nvarchar" Nullable="false" MaxLength="150" />
  29. </EntityType>
  30. <EntityType Name="Tests">
  31. <Key>
  32. <PropertyRef Name="IdTest" />
  33. </Key>
  34. <Property Name="IdTest" Type="int" Nullable="false" />
  35. <Property Name="IdUser" Type="int" Nullable="false" />
  36. <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="150" />
  37. <Property Name="Image" Type="varbinary(max)" Nullable="true" />
  38. </EntityType>
  39. <EntityType Name="Users">
  40. <Key>
  41. <PropertyRef Name="IdUser" />
  42. </Key>
  43. <Property Name="IdUser" Type="int" Nullable="false" />
  44. <Property Name="Login" Type="nvarchar" Nullable="false" MaxLength="50" />
  45. <Property Name="Password" Type="nvarchar" Nullable="false" MaxLength="50" />
  46. <Property Name="Email" Type="nvarchar" Nullable="false" MaxLength="50" />
  47. <Property Name="Info" Type="nvarchar" Nullable="true" MaxLength="50" />
  48. <Property Name="Image" Type="varbinary(max)" Nullable="true" />
  49. </EntityType>
  50. <Association Name="FK_Questions_Tests">
  51. <End Role="Tests" Type="MyTestsDataBaseModel.Store.Tests" Multiplicity="1" />
  52. <End Role="Questions" Type="MyTestsDataBaseModel.Store.Questions" Multiplicity="*" />
  53. <ReferentialConstraint>
  54. <Principal Role="Tests">
  55. <PropertyRef Name="IdTest" />
  56. </Principal>
  57. <Dependent Role="Questions">
  58. <PropertyRef Name="IdTest" />
  59. </Dependent>
  60. </ReferentialConstraint>
  61. </Association>
  62. <Association Name="FK_Tests_Users">
  63. <End Role="Users" Type="MyTestsDataBaseModel.Store.Users" Multiplicity="1" />
  64. <End Role="Tests" Type="MyTestsDataBaseModel.Store.Tests" Multiplicity="*" />
  65. <ReferentialConstraint>
  66. <Principal Role="Users">
  67. <PropertyRef Name="IdUser" />
  68. </Principal>
  69. <Dependent Role="Tests">
  70. <PropertyRef Name="IdUser" />
  71. </Dependent>
  72. </ReferentialConstraint>
  73. </Association>
  74. </Schema></edmx:StorageModels>
  75. <!-- CSDL content -->
  76. <edmx:ConceptualModels>
  77. <Schema Namespace="MyTestsDataBaseModel" 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">
  78. <EntityType Name="Questions">
  79. <Key>
  80. <PropertyRef Name="IdQuestion" />
  81. </Key>
  82. <Property Name="IdQuestion" Type="Int32" Nullable="false" />
  83. <Property Name="IdTest" Type="Int32" Nullable="false" />
  84. <Property Name="Content" Type="String" MaxLength="150" FixedLength="false" Unicode="true" Nullable="false" />
  85. <NavigationProperty Name="Tests" Relationship="Self.FK_Questions_Tests" FromRole="Questions" ToRole="Tests" />
  86. <Property Name="Answer" Type="String" Nullable="false" MaxLength="150" FixedLength="false" Unicode="true" />
  87. </EntityType>
  88. <EntityType Name="Tests">
  89. <Key>
  90. <PropertyRef Name="IdTest" />
  91. </Key>
  92. <Property Name="IdTest" Type="Int32" Nullable="false" />
  93. <Property Name="IdUser" Type="Int32" Nullable="false" />
  94. <Property Name="Name" Type="String" MaxLength="150" FixedLength="false" Unicode="true" Nullable="false" />
  95. <Property Name="Image" Type="Binary" MaxLength="Max" FixedLength="false" />
  96. <NavigationProperty Name="Questions" Relationship="Self.FK_Questions_Tests" FromRole="Tests" ToRole="Questions" />
  97. <NavigationProperty Name="Users" Relationship="Self.FK_Tests_Users" FromRole="Tests" ToRole="Users" />
  98. </EntityType>
  99. <EntityType Name="Users">
  100. <Key>
  101. <PropertyRef Name="IdUser" />
  102. </Key>
  103. <Property Name="IdUser" Type="Int32" Nullable="false" />
  104. <Property Name="Login" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  105. <Property Name="Password" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  106. <Property Name="Email" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  107. <Property Name="Info" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  108. <Property Name="Image" Type="Binary" MaxLength="Max" FixedLength="false" />
  109. <NavigationProperty Name="Tests" Relationship="Self.FK_Tests_Users" FromRole="Users" ToRole="Tests" />
  110. </EntityType>
  111. <Association Name="FK_Questions_Tests">
  112. <End Role="Tests" Type="Self.Tests" Multiplicity="1" />
  113. <End Role="Questions" Type="Self.Questions" Multiplicity="*" />
  114. <ReferentialConstraint>
  115. <Principal Role="Tests">
  116. <PropertyRef Name="IdTest" />
  117. </Principal>
  118. <Dependent Role="Questions">
  119. <PropertyRef Name="IdTest" />
  120. </Dependent>
  121. </ReferentialConstraint>
  122. </Association>
  123. <Association Name="FK_Tests_Users">
  124. <End Role="Users" Type="Self.Users" Multiplicity="1" />
  125. <End Role="Tests" Type="Self.Tests" Multiplicity="*" />
  126. <ReferentialConstraint>
  127. <Principal Role="Users">
  128. <PropertyRef Name="IdUser" />
  129. </Principal>
  130. <Dependent Role="Tests">
  131. <PropertyRef Name="IdUser" />
  132. </Dependent>
  133. </ReferentialConstraint>
  134. </Association>
  135. <EntityContainer Name="MyTestsDataBaseEntities" annotation:LazyLoadingEnabled="true">
  136. <EntitySet Name="Questions" EntityType="Self.Questions" />
  137. <EntitySet Name="Tests" EntityType="Self.Tests" />
  138. <EntitySet Name="Users" EntityType="Self.Users" />
  139. <AssociationSet Name="FK_Questions_Tests" Association="Self.FK_Questions_Tests">
  140. <End Role="Tests" EntitySet="Tests" />
  141. <End Role="Questions" EntitySet="Questions" />
  142. </AssociationSet>
  143. <AssociationSet Name="FK_Tests_Users" Association="Self.FK_Tests_Users">
  144. <End Role="Users" EntitySet="Users" />
  145. <End Role="Tests" EntitySet="Tests" />
  146. </AssociationSet>
  147. </EntityContainer>
  148. </Schema>
  149. </edmx:ConceptualModels>
  150. <!-- C-S mapping content -->
  151. <edmx:Mappings>
  152. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  153. <EntityContainerMapping StorageEntityContainer="MyTestsDataBaseModelStoreContainer" CdmEntityContainer="MyTestsDataBaseEntities">
  154. <EntitySetMapping Name="Questions">
  155. <EntityTypeMapping TypeName="IsTypeOf(MyTestsDataBaseModel.Questions)">
  156. <MappingFragment StoreEntitySet="Questions">
  157. <ScalarProperty Name="IdQuestion" ColumnName="IdQuestion" />
  158. <ScalarProperty Name="IdTest" ColumnName="IdTest" />
  159. <ScalarProperty Name="Content" ColumnName="Content" />
  160. <ScalarProperty Name="Answer" ColumnName="Answer" />
  161. </MappingFragment>
  162. </EntityTypeMapping>
  163. </EntitySetMapping>
  164. <EntitySetMapping Name="Tests">
  165. <EntityTypeMapping TypeName="IsTypeOf(MyTestsDataBaseModel.Tests)">
  166. <MappingFragment StoreEntitySet="Tests">
  167. <ScalarProperty Name="IdTest" ColumnName="IdTest" />
  168. <ScalarProperty Name="IdUser" ColumnName="IdUser" />
  169. <ScalarProperty Name="Name" ColumnName="Name" />
  170. <ScalarProperty Name="Image" ColumnName="Image" />
  171. </MappingFragment>
  172. </EntityTypeMapping>
  173. </EntitySetMapping>
  174. <EntitySetMapping Name="Users">
  175. <EntityTypeMapping TypeName="IsTypeOf(MyTestsDataBaseModel.Users)">
  176. <MappingFragment StoreEntitySet="Users">
  177. <ScalarProperty Name="IdUser" ColumnName="IdUser" />
  178. <ScalarProperty Name="Login" ColumnName="Login" />
  179. <ScalarProperty Name="Password" ColumnName="Password" />
  180. <ScalarProperty Name="Email" ColumnName="Email" />
  181. <ScalarProperty Name="Info" ColumnName="Info" />
  182. <ScalarProperty Name="Image" ColumnName="Image" />
  183. </MappingFragment>
  184. </EntityTypeMapping>
  185. </EntitySetMapping>
  186. </EntityContainerMapping>
  187. </Mapping></edmx:Mappings>
  188. </edmx:Runtime>
  189. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  190. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  191. <Connection>
  192. <DesignerInfoPropertySet>
  193. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  194. </DesignerInfoPropertySet>
  195. </Connection>
  196. <Options>
  197. <DesignerInfoPropertySet>
  198. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  199. <DesignerProperty Name="EnablePluralization" Value="false" />
  200. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  201. <DesignerProperty Name="UseLegacyProvider" Value="False" />
  202. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  203. </DesignerInfoPropertySet>
  204. </Options>
  205. <!-- Diagram content (shape and connector positions) -->
  206. <Diagrams></Diagrams>
  207. </Designer>
  208. </edmx:Edmx>