Model1.edmx 5.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
  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="Хранилище studentsModel" 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="stud">
  9. <Key>
  10. <PropertyRef Name="Id" />
  11. </Key>
  12. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="last_name" Type="nvarchar(max)" Nullable="false" />
  14. <Property Name="first_name" Type="nvarchar(max)" Nullable="false" />
  15. <Property Name="middle_name" Type="nvarchar(max)" Nullable="false" />
  16. <Property Name="birthdate" Type="date" Nullable="false" />
  17. <Property Name="year_entrance" Type="date" Nullable="false" />
  18. <Property Name="course" Type="int" Nullable="false" />
  19. <Property Name="study_group" Type="int" Nullable="false" />
  20. <Property Name="average_score" Type="float" Nullable="false" />
  21. </EntityType>
  22. <EntityContainer Name="Хранилище studentsModelContainer">
  23. <EntitySet Name="stud" EntityType="Self.stud" Schema="dbo" store:Type="Tables" />
  24. </EntityContainer>
  25. </Schema>
  26. </edmx:StorageModels>
  27. <!-- CSDL content -->
  28. <edmx:ConceptualModels>
  29. <Schema Namespace="studentsModel" 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">
  30. <EntityType Name="stud">
  31. <Key>
  32. <PropertyRef Name="Id" />
  33. </Key>
  34. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  35. <Property Name="last_name" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
  36. <Property Name="first_name" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
  37. <Property Name="middle_name" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
  38. <Property Name="birthdate" Type="DateTime" Nullable="false" Precision="0" />
  39. <Property Name="year_entrance" Type="DateTime" Nullable="false" Precision="0" />
  40. <Property Name="course" Type="Int32" Nullable="false" />
  41. <Property Name="study_group" Type="Int32" Nullable="false" />
  42. <Property Name="average_score" Type="Double" Nullable="false" />
  43. </EntityType>
  44. <EntityContainer Name="studentsEntities" annotation:LazyLoadingEnabled="true">
  45. <EntitySet Name="stud" EntityType="Self.stud" />
  46. </EntityContainer>
  47. </Schema>
  48. </edmx:ConceptualModels>
  49. <!-- C-S mapping content -->
  50. <edmx:Mappings>
  51. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  52. <EntityContainerMapping StorageEntityContainer="Хранилище studentsModelContainer" CdmEntityContainer="studentsEntities">
  53. <EntitySetMapping Name="stud">
  54. <EntityTypeMapping TypeName="studentsModel.stud">
  55. <MappingFragment StoreEntitySet="stud">
  56. <ScalarProperty Name="Id" ColumnName="Id" />
  57. <ScalarProperty Name="last_name" ColumnName="last_name" />
  58. <ScalarProperty Name="first_name" ColumnName="first_name" />
  59. <ScalarProperty Name="middle_name" ColumnName="middle_name" />
  60. <ScalarProperty Name="birthdate" ColumnName="birthdate" />
  61. <ScalarProperty Name="year_entrance" ColumnName="year_entrance" />
  62. <ScalarProperty Name="course" ColumnName="course" />
  63. <ScalarProperty Name="study_group" ColumnName="study_group" />
  64. <ScalarProperty Name="average_score" ColumnName="average_score" />
  65. </MappingFragment>
  66. </EntityTypeMapping>
  67. </EntitySetMapping>
  68. </EntityContainerMapping>
  69. </Mapping>
  70. </edmx:Mappings>
  71. </edmx:Runtime>
  72. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  73. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  74. <Connection>
  75. <DesignerInfoPropertySet>
  76. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  77. </DesignerInfoPropertySet>
  78. </Connection>
  79. <Options>
  80. <DesignerInfoPropertySet>
  81. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  82. <DesignerProperty Name="EnablePluralization" Value="false" />
  83. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  84. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  85. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  86. </DesignerInfoPropertySet>
  87. </Options>
  88. <!-- Diagram content (shape and connector positions) -->
  89. <Diagrams></Diagrams>
  90. </Designer>
  91. </edmx:Edmx>