EntityModel.edmx 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116
  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="ModeleMVC.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="Territoires">
  9. <Key>
  10. <PropertyRef Name="Id" />
  11. </Key>
  12. <Property Name="Id" Type="nvarchar" MaxLength="10" Nullable="false" />
  13. <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
  14. <Property Name="Referent_SID" Type="nvarchar" MaxLength="64" />
  15. <Property Name="Referent_Nom" Type="nvarchar" MaxLength="255" />
  16. <Property Name="Referent_Prenom" Type="nvarchar" MaxLength="255" />
  17. <Property Name="Referent_Structure" Type="nvarchar" MaxLength="255" />
  18. <Property Name="Referent_Login" Type="nvarchar" MaxLength="255" />
  19. <Property Name="Referent_Email" Type="nvarchar" MaxLength="255" />
  20. <Property Name="Ordre" Type="int" Nullable="false" />
  21. </EntityType>
  22. <EntityType Name="TypesCollege">
  23. <Key>
  24. <PropertyRef Name="Id" />
  25. </Key>
  26. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  27. <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
  28. <Property Name="Ordre" Type="int" Nullable="false" />
  29. </EntityType>
  30. <EntityContainer Name="ModeleMVCStoreContainer">
  31. <EntitySet Name="Territoires" EntityType="Self.Territoires" Schema="dbo" store:Type="Tables" />
  32. <EntitySet Name="TypesCollege" EntityType="Self.TypesCollege" Schema="dbo" store:Type="Tables" />
  33. </EntityContainer>
  34. </Schema></edmx:StorageModels>
  35. <!-- CSDL content -->
  36. <edmx:ConceptualModels>
  37. <Schema Namespace="CD67.FicheCollege" 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">
  38. <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
  39. <EntitySet Name="TypesCollege" EntityType="CD67.FicheCollege.TypeCollege" />
  40. <EntitySet Name="Territoires" EntityType="CD67.FicheCollege.Territoire" />
  41. </EntityContainer>
  42. <EntityType Name="TypeCollege">
  43. <Key>
  44. <PropertyRef Name="Id" />
  45. </Key>
  46. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  47. <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
  48. <Property Name="Ordre" Type="Int32" Nullable="false" />
  49. </EntityType>
  50. <EntityType Name="Territoire">
  51. <Key>
  52. <PropertyRef Name="Id" />
  53. </Key>
  54. <Property Name="Id" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
  55. <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
  56. <Property Name="Referent_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
  57. <Property Name="Referent_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  58. <Property Name="Referent_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  59. <Property Name="Referent_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  60. <Property Name="Referent_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  61. <Property Name="Referent_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  62. <Property Name="Ordre" Type="Int32" Nullable="false" />
  63. </EntityType>
  64. </Schema>
  65. </edmx:ConceptualModels>
  66. <!-- C-S mapping content -->
  67. <edmx:Mappings>
  68. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  69. <EntityContainerMapping StorageEntityContainer="ModeleMVCStoreContainer" CdmEntityContainer="Entities">
  70. <EntitySetMapping Name="TypesCollege">
  71. <EntityTypeMapping TypeName="CD67.FicheCollege.TypeCollege">
  72. <MappingFragment StoreEntitySet="TypesCollege">
  73. <ScalarProperty Name="Ordre" ColumnName="Ordre" />
  74. <ScalarProperty Name="Libelle" ColumnName="Libelle" />
  75. <ScalarProperty Name="Id" ColumnName="Id" />
  76. </MappingFragment>
  77. </EntityTypeMapping>
  78. </EntitySetMapping>
  79. <EntitySetMapping Name="Territoires">
  80. <EntityTypeMapping TypeName="CD67.FicheCollege.Territoire">
  81. <MappingFragment StoreEntitySet="Territoires">
  82. <ScalarProperty Name="Ordre" ColumnName="Ordre" />
  83. <ScalarProperty Name="Referent_Email" ColumnName="Referent_Email" />
  84. <ScalarProperty Name="Referent_Login" ColumnName="Referent_Login" />
  85. <ScalarProperty Name="Referent_Structure" ColumnName="Referent_Structure" />
  86. <ScalarProperty Name="Referent_Prenom" ColumnName="Referent_Prenom" />
  87. <ScalarProperty Name="Referent_Nom" ColumnName="Referent_Nom" />
  88. <ScalarProperty Name="Referent_SID" ColumnName="Referent_SID" />
  89. <ScalarProperty Name="Libelle" ColumnName="Libelle" />
  90. <ScalarProperty Name="Id" ColumnName="Id" />
  91. </MappingFragment>
  92. </EntityTypeMapping>
  93. </EntitySetMapping>
  94. </EntityContainerMapping>
  95. </Mapping></edmx:Mappings>
  96. </edmx:Runtime>
  97. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  98. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  99. <Connection>
  100. <DesignerInfoPropertySet>
  101. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  102. </DesignerInfoPropertySet>
  103. </Connection>
  104. <Options>
  105. <DesignerInfoPropertySet>
  106. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  107. <DesignerProperty Name="EnablePluralization" Value="True" />
  108. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  109. <DesignerProperty Name="UseLegacyProvider" Value="False" />
  110. <DesignerProperty Name="CodeGenerationStrategy" Value="Aucun" />
  111. </DesignerInfoPropertySet>
  112. </Options>
  113. <!-- Diagram content (shape and connector positions) -->
  114. <Diagrams></Diagrams>
  115. </Designer>
  116. </edmx:Edmx>