OrsysASPNETMVC/Formateur/SolutionANA/DAL/ModeleAnnuaire.edmx

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="AnnuaireModele.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">
        <EntityType Name="Personnes">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="uniqueidentifier" Nullable="false" />
          <Property Name="NumTitre" Type="smallint" Nullable="false" />
          <Property Name="Nom" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="Prenom" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="Telephone" Type="nchar" MaxLength="10" Nullable="false" />
        </EntityType>
        <EntityType Name="Titres">
          <Key>
            <PropertyRef Name="NumTitre" />
          </Key>
          <Property Name="NumTitre" Type="smallint" Nullable="false" />
          <Property Name="Titre" Type="varchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <Association Name="Personnes_Titres">
          <End Role="Titres" Type="Self.Titres" Multiplicity="1" />
          <End Role="Personnes" Type="Self.Personnes" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Titres">
              <PropertyRef Name="NumTitre" />
            </Principal>
            <Dependent Role="Personnes">
              <PropertyRef Name="NumTitre" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="AnnuaireModeleStoreContainer">
          <EntitySet Name="Personnes" EntityType="Self.Personnes" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Titres" EntityType="Self.Titres" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="Personnes_Titres" Association="Self.Personnes_Titres">
            <End Role="Titres" EntitySet="Titres" />
            <End Role="Personnes" EntitySet="Personnes" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="AnnuaireModele" 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">
        <EntityType Name="Titre">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int16" Nullable="false" />
          <Property Name="Civilite" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <NavigationProperty Name="Personnes" Relationship="AnnuaireModele.Personnes_Titres" FromRole="Titre" ToRole="Personne" />
        </EntityType>
        <EntityContainer Name="AnnuaireEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Titres" EntityType="Self.Titre" />
          <EntitySet Name="Personnes" EntityType="AnnuaireModele.Personne" />
          <AssociationSet Name="Personnes_Titres" Association="AnnuaireModele.Personnes_Titres">
            <End Role="Titre" EntitySet="Titres" />
            <End Role="Personne" EntitySet="Personnes" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Personne">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Guid" Nullable="false" />
          <Property Name="TitreId" Type="Int16" Nullable="false" />
          <Property Name="Nom" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="Prenom" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="Telephone" Type="String" Nullable="false" MaxLength="10" FixedLength="true" Unicode="true" />
          <NavigationProperty Name="Titre" Relationship="AnnuaireModele.Personnes_Titres" FromRole="Personne" ToRole="Titre" />
        </EntityType>
        <Association Name="Personnes_Titres">
          <End Type="AnnuaireModele.Titre" Role="Titre" Multiplicity="1" />
          <End Type="AnnuaireModele.Personne" Role="Personne" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Titre">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Personne">
              <PropertyRef Name="TitreId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="AnnuaireModeleStoreContainer" CdmEntityContainer="AnnuaireEntities">
          <EntitySetMapping Name="Titres">
            <EntityTypeMapping TypeName="AnnuaireModele.Titre">
              <MappingFragment StoreEntitySet="Titres">
                <ScalarProperty Name="Id" ColumnName="NumTitre" />
                <ScalarProperty Name="Civilite" ColumnName="Titre" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Personnes">
            <EntityTypeMapping TypeName="AnnuaireModele.Personne">
              <MappingFragment StoreEntitySet="Personnes">
                <ScalarProperty Name="Telephone" ColumnName="Telephone" />
                <ScalarProperty Name="Prenom" ColumnName="Prenom" />
                <ScalarProperty Name="Nom" ColumnName="Nom" />
                <ScalarProperty Name="TitreId" ColumnName="NumTitre" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="true" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="Aucun" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>