Model1.edmx 6.4 KB

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