EntityModel.edmx 8.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141
  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. <!-- Un seul provider doit être actif, il faut dé-commenter le bon -->
  8. <!-- Provider Oracle -->
  9. <Schema Namespace="Model.Store" Provider="Oracle.ManagedDataAccess.Client" ProviderManifestToken="11.2" 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">
  10. <!-- Provider SQL server -->
  11. <!--<Schema Namespace="Model.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2008" 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">-->
  12. <EntityType Name="EXEMPLE_TYPE_VIKING">
  13. <Key>
  14. <PropertyRef Name="ID" />
  15. </Key>
  16. <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" StoreGeneratedPattern="Identity" />
  17. <Property Name="TYPE" Type="varchar2" MaxLength="255" />
  18. </EntityType>
  19. <EntityType Name="EXEMPLE_VIKINGS">
  20. <Key>
  21. <PropertyRef Name="ID" />
  22. </Key>
  23. <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" StoreGeneratedPattern="Identity" />
  24. <Property Name="NOM" Type="varchar2" MaxLength="255" Nullable="false" />
  25. <Property Name="ID_TYPE" Type="number" Precision="38" Scale="0" Nullable="false" />
  26. <Property Name="DESCRIPTION" Type="varchar2" MaxLength="255" />
  27. <Property Name="DATE_INUTILE" Type="date" />
  28. </EntityType>
  29. <Association Name="EXEMPLE_VIKINGS_FK">
  30. <End Role="EXEMPLE_TYPE_VIKING" Type="Self.EXEMPLE_TYPE_VIKING" Multiplicity="1" />
  31. <End Role="EXEMPLE_VIKINGS" Type="Self.EXEMPLE_VIKINGS" Multiplicity="*" />
  32. <ReferentialConstraint>
  33. <Principal Role="EXEMPLE_TYPE_VIKING">
  34. <PropertyRef Name="ID" />
  35. </Principal>
  36. <Dependent Role="EXEMPLE_VIKINGS">
  37. <PropertyRef Name="ID_TYPE" />
  38. </Dependent>
  39. </ReferentialConstraint>
  40. </Association>
  41. <EntityContainer Name="ModelStoreContainer">
  42. <EntitySet Name="EXEMPLE_TYPE_VIKING" EntityType="Self.EXEMPLE_TYPE_VIKING" Schema="FER" store:Type="Tables" />
  43. <EntitySet Name="EXEMPLE_VIKINGS" EntityType="Self.EXEMPLE_VIKINGS" Schema="FER" store:Type="Tables" />
  44. <AssociationSet Name="EXEMPLE_VIKINGS_FK" Association="Self.EXEMPLE_VIKINGS_FK">
  45. <End Role="EXEMPLE_TYPE_VIKING" EntitySet="EXEMPLE_TYPE_VIKING" />
  46. <End Role="EXEMPLE_VIKINGS" EntitySet="EXEMPLE_VIKINGS" />
  47. </AssociationSet>
  48. </EntityContainer>
  49. </Schema></edmx:StorageModels>
  50. <!-- CSDL content -->
  51. <edmx:ConceptualModels>
  52. <Schema Namespace="Model" 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">
  53. <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
  54. <EntitySet Name="EXEMPLE_TYPE_VIKING" EntityType="Model.EXEMPLE_TYPE_VIKING" />
  55. <EntitySet Name="EXEMPLE_VIKINGS" EntityType="Model.EXEMPLE_VIKINGS" />
  56. <AssociationSet Name="EXEMPLE_VIKINGS_FK" Association="Model.EXEMPLE_VIKINGS_FK">
  57. <End Role="EXEMPLE_TYPE_VIKING" EntitySet="EXEMPLE_TYPE_VIKING" />
  58. <End Role="EXEMPLE_VIKINGS" EntitySet="EXEMPLE_VIKINGS" />
  59. </AssociationSet>
  60. </EntityContainer>
  61. <EntityType Name="EXEMPLE_TYPE_VIKING">
  62. <Key>
  63. <PropertyRef Name="ID" />
  64. </Key>
  65. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  66. <Property Name="TYPE" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
  67. <NavigationProperty Name="EXEMPLE_VIKINGS" Relationship="Model.EXEMPLE_VIKINGS_FK" FromRole="EXEMPLE_TYPE_VIKING" ToRole="EXEMPLE_VIKINGS" />
  68. </EntityType>
  69. <EntityType Name="EXEMPLE_VIKINGS">
  70. <Key>
  71. <PropertyRef Name="ID" />
  72. </Key>
  73. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  74. <Property Name="NOM" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="false" />
  75. <Property Name="ID_TYPE" Type="Int32" Nullable="false" />
  76. <Property Name="DESCRIPTION" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
  77. <NavigationProperty Name="EXEMPLE_TYPE_VIKING" Relationship="Model.EXEMPLE_VIKINGS_FK" FromRole="EXEMPLE_VIKINGS" ToRole="EXEMPLE_TYPE_VIKING" />
  78. <Property Name="DATE_INUTILE" Type="DateTime" />
  79. </EntityType>
  80. <Association Name="EXEMPLE_VIKINGS_FK">
  81. <End Type="Model.EXEMPLE_TYPE_VIKING" Role="EXEMPLE_TYPE_VIKING" Multiplicity="1" />
  82. <End Type="Model.EXEMPLE_VIKINGS" Role="EXEMPLE_VIKINGS" Multiplicity="*" />
  83. <ReferentialConstraint>
  84. <Principal Role="EXEMPLE_TYPE_VIKING">
  85. <PropertyRef Name="ID" />
  86. </Principal>
  87. <Dependent Role="EXEMPLE_VIKINGS">
  88. <PropertyRef Name="ID_TYPE" />
  89. </Dependent>
  90. </ReferentialConstraint>
  91. </Association>
  92. </Schema>
  93. </edmx:ConceptualModels>
  94. <!-- C-S mapping content -->
  95. <edmx:Mappings>
  96. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  97. <EntityContainerMapping StorageEntityContainer="ModelStoreContainer" CdmEntityContainer="Entities">
  98. <EntitySetMapping Name="EXEMPLE_TYPE_VIKING">
  99. <EntityTypeMapping TypeName="Model.EXEMPLE_TYPE_VIKING">
  100. <MappingFragment StoreEntitySet="EXEMPLE_TYPE_VIKING">
  101. <ScalarProperty Name="TYPE" ColumnName="TYPE" />
  102. <ScalarProperty Name="ID" ColumnName="ID" />
  103. </MappingFragment>
  104. </EntityTypeMapping>
  105. </EntitySetMapping>
  106. <EntitySetMapping Name="EXEMPLE_VIKINGS">
  107. <EntityTypeMapping TypeName="Model.EXEMPLE_VIKINGS">
  108. <MappingFragment StoreEntitySet="EXEMPLE_VIKINGS">
  109. <ScalarProperty Name="DATE_INUTILE" ColumnName="DATE_INUTILE" />
  110. <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" />
  111. <ScalarProperty Name="ID_TYPE" ColumnName="ID_TYPE" />
  112. <ScalarProperty Name="NOM" ColumnName="NOM" />
  113. <ScalarProperty Name="ID" ColumnName="ID" />
  114. </MappingFragment>
  115. </EntityTypeMapping>
  116. </EntitySetMapping>
  117. </EntityContainerMapping>
  118. </Mapping>
  119. </edmx:Mappings>
  120. </edmx:Runtime>
  121. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  122. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  123. <Connection>
  124. <DesignerInfoPropertySet>
  125. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  126. </DesignerInfoPropertySet>
  127. </Connection>
  128. <Options>
  129. <DesignerInfoPropertySet>
  130. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  131. <DesignerProperty Name="EnablePluralization" Value="false" />
  132. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  133. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  134. <DesignerProperty Name="CodeGenerationStrategy" Value="Aucun" />
  135. </DesignerInfoPropertySet>
  136. </Options>
  137. <!-- Diagram content (shape and connector positions) -->
  138. <Diagrams></Diagrams>
  139. </Designer>
  140. </edmx:Edmx>