fichecollege/CD67.FicheCollege.Entity/EntityModel.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="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">
        <EntityType Name="Colleges">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="nvarchar" MaxLength="8" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Adresse" Type="nvarchar" MaxLength="255" />
          <Property Name="Code_Postal" Type="nvarchar" MaxLength="5" />
          <Property Name="TypeCollege_Id" Type="int" Nullable="false" />
          <Property Name="Commune_Insee" Type="nvarchar" MaxLength="5" />
          <Property Name="Commune" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Canton" Type="nvarchar" MaxLength="255" />
          <Property Name="Territoire_Id" Type="nvarchar" MaxLength="10" />
          <Property Name="TAD" Type="nvarchar" MaxLength="255" />
          <Property Name="CDC" Type="nvarchar" MaxLength="255" />
          <Property Name="Tel" Type="nvarchar" MaxLength="255" />
          <Property Name="Fax" Type="nvarchar" MaxLength="255" />
          <Property Name="Email" Type="nvarchar" MaxLength="255" />
        </EntityType>
        <EntityType Name="Territoires">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Referent_SID" Type="nvarchar" MaxLength="64" />
          <Property Name="Referent_Nom" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Prenom" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Structure" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Login" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Email" Type="nvarchar" MaxLength="255" />
          <Property Name="Ordre" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="TypesCollege">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Ordre" Type="int" Nullable="false" />
        </EntityType>
        <Association Name="FK_Colleges_Territoires">
          <End Role="Territoires" Type="Self.Territoires" Multiplicity="0..1" />
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Territoires">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Colleges">
              <PropertyRef Name="Territoire_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Colleges_TypesCollege">
          <End Role="TypesCollege" Type="Self.TypesCollege" Multiplicity="1" />
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="TypesCollege">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Colleges">
              <PropertyRef Name="TypeCollege_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="ModeleMVCStoreContainer">
          <EntitySet Name="Colleges" EntityType="Self.Colleges" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Territoires" EntityType="Self.Territoires" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="TypesCollege" EntityType="Self.TypesCollege" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_Colleges_Territoires" Association="Self.FK_Colleges_Territoires">
            <End Role="Territoires" EntitySet="Territoires" />
            <End Role="Colleges" EntitySet="Colleges" />
          </AssociationSet>
          <AssociationSet Name="FK_Colleges_TypesCollege" Association="Self.FK_Colleges_TypesCollege">
            <End Role="TypesCollege" EntitySet="TypesCollege" />
            <End Role="Colleges" EntitySet="Colleges" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <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">
        <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="TypesCollege" EntityType="CD67.FicheCollege.TypeCollege" />
          <EntitySet Name="Territoires" EntityType="CD67.FicheCollege.Territoire" />
          <EntitySet Name="Colleges" EntityType="CD67.FicheCollege.College" />
          <AssociationSet Name="FK_Colleges_Territoires" Association="CD67.FicheCollege.FK_Colleges_Territoires">
            <End Role="Territoire" EntitySet="Territoires" />
            <End Role="College" EntitySet="Colleges" />
          </AssociationSet>
          <AssociationSet Name="FK_Colleges_TypesCollege" Association="CD67.FicheCollege.FK_Colleges_TypesCollege">
            <End Role="TypeCollege" EntitySet="TypesCollege" />
            <End Role="College" EntitySet="Colleges" />
          </AssociationSet>
          </EntityContainer>
        <EntityType Name="TypeCollege">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.FK_Colleges_TypesCollege" FromRole="TypeCollege" ToRole="College" />
        </EntityType>
        <EntityType Name="Territoire">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.FK_Colleges_Territoires" FromRole="Territoire" ToRole="College" />
        </EntityType>
        <EntityType Name="College">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="String" Nullable="false" MaxLength="8" FixedLength="false" Unicode="true" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adresse" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Code_Postal" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
          <Property Name="TypeCollege_Id" Type="Int32" Nullable="false" />
          <Property Name="Commune_Insee" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
          <Property Name="Commune" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Canton" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Territoire_Id" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="TAD" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="CDC" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Fax" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Territoire" Relationship="CD67.FicheCollege.FK_Colleges_Territoires" FromRole="College" ToRole="Territoire" />
          <NavigationProperty Name="TypeCollege" Relationship="CD67.FicheCollege.FK_Colleges_TypesCollege" FromRole="College" ToRole="TypeCollege" />
        </EntityType>
        <Association Name="FK_Colleges_Territoires">
          <End Type="CD67.FicheCollege.Territoire" Role="Territoire" Multiplicity="0..1" />
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Territoire">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="College">
              <PropertyRef Name="Territoire_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Colleges_TypesCollege">
          <End Type="CD67.FicheCollege.TypeCollege" Role="TypeCollege" Multiplicity="1" />
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="TypeCollege">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="College">
              <PropertyRef Name="TypeCollege_Id" />
            </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="ModeleMVCStoreContainer" CdmEntityContainer="Entities">
          <EntitySetMapping Name="TypesCollege">
            <EntityTypeMapping TypeName="CD67.FicheCollege.TypeCollege">
              <MappingFragment StoreEntitySet="TypesCollege">
                <ScalarProperty Name="Ordre" ColumnName="Ordre" />
                <ScalarProperty Name="Libelle" ColumnName="Libelle" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Territoires">
            <EntityTypeMapping TypeName="CD67.FicheCollege.Territoire">
              <MappingFragment StoreEntitySet="Territoires">
                <ScalarProperty Name="Ordre" ColumnName="Ordre" />
                <ScalarProperty Name="Referent_Email" ColumnName="Referent_Email" />
                <ScalarProperty Name="Referent_Login" ColumnName="Referent_Login" />
                <ScalarProperty Name="Referent_Structure" ColumnName="Referent_Structure" />
                <ScalarProperty Name="Referent_Prenom" ColumnName="Referent_Prenom" />
                <ScalarProperty Name="Referent_Nom" ColumnName="Referent_Nom" />
                <ScalarProperty Name="Referent_SID" ColumnName="Referent_SID" />
                <ScalarProperty Name="Libelle" ColumnName="Libelle" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Colleges">
            <EntityTypeMapping TypeName="CD67.FicheCollege.College">
              <MappingFragment StoreEntitySet="Colleges">
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="Fax" ColumnName="Fax" />
                <ScalarProperty Name="Tel" ColumnName="Tel" />
                <ScalarProperty Name="CDC" ColumnName="CDC" />
                <ScalarProperty Name="TAD" ColumnName="TAD" />
                <ScalarProperty Name="Territoire_Id" ColumnName="Territoire_Id" />
                <ScalarProperty Name="Canton" ColumnName="Canton" />
                <ScalarProperty Name="Commune" ColumnName="Commune" />
                <ScalarProperty Name="Commune_Insee" ColumnName="Commune_Insee" />
                <ScalarProperty Name="TypeCollege_Id" ColumnName="TypeCollege_Id" />
                <ScalarProperty Name="Code_Postal" ColumnName="Code_Postal" />
                <ScalarProperty Name="Adresse" ColumnName="Adresse" />
                <ScalarProperty Name="Libelle" ColumnName="Libelle" />
                <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>