﻿<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="testModel1.Store" Alias="Self" Provider="MySql.Data.MySqlClient" ProviderManifestToken="5.1" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
  <EntityContainer Name="testModel1StoreContainer">
    <EntitySet Name="people" EntityType="testModel1.Store.people" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="Companies" EntityType="testModel1.Store.Companies" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="Companyperson" EntityType="testModel1.Store.Companyperson" store:Type="Tables" Schema="dbo" />
    <AssociationSet Name="FK_Companyperson_Company" Association="testModel1.Store.FK_Companyperson_Company">
      <End Role="Company" EntitySet="Companies" />
      <End Role="Companyperson" EntitySet="Companyperson" />
    </AssociationSet>
    <AssociationSet Name="FK_Companyperson_person" Association="testModel1.Store.FK_Companyperson_person">
      <End Role="person" EntitySet="people" />
      <End Role="Companyperson" EntitySet="Companyperson" />
    </AssociationSet>
  </EntityContainer>
  <EntityType Name="people">
    <Key>
      <PropertyRef Name="PersonID" />
    </Key>
    <Property Name="FirstName" Type="nvarchar" Nullable="true" />
    <Property Name="LastName" Type="nvarchar" Nullable="true" />
    <Property Name="PersonID" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="Companies">
    <Key>
      <PropertyRef Name="CompanyID" />
    </Key>
    <Property Name="CompanyID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="CompanyName" Type="nvarchar" Nullable="false" />
  </EntityType>
  <EntityType Name="Companyperson">
    <Key>
      <PropertyRef Name="Companies_CompanyID" />
      <PropertyRef Name="people_PersonID" />
    </Key>
    <Property Name="Companies_CompanyID" Type="int" Nullable="false" />
    <Property Name="people_PersonID" Type="int" Nullable="false" />
  </EntityType>
  <Association Name="FK_Companyperson_Company">
    <End Role="Company" Type="testModel1.Store.Companies" Multiplicity="1" />
    <End Role="Companyperson" Type="testModel1.Store.Companyperson" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Company">
        <PropertyRef Name="CompanyID" />
      </Principal>
      <Dependent Role="Companyperson">
        <PropertyRef Name="Companies_CompanyID" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Companyperson_person">
    <End Role="Companyperson" Type="testModel1.Store.Companyperson" Multiplicity="*" />
    <End Role="person" Type="testModel1.Store.people" Multiplicity="1" />
    <ReferentialConstraint>
      <Principal Role="person">
        <PropertyRef Name="PersonID" />
      </Principal>
      <Dependent Role="Companyperson">
        <PropertyRef Name="people_PersonID" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
</Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="testModel1" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
        <EntityContainer Name="testEntities1" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="people" EntityType="testModel1.person" />
          <EntitySet Name="Companies" EntityType="testModel1.Company" />
          <AssociationSet Name="Companyperson" Association="testModel1.Companyperson">
            <End Role="Company" EntitySet="Companies" />
            <End Role="person" EntitySet="people" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="person">
          <Key>
            <PropertyRef Name="PersonID" />
          </Key>
          <Property Name="FirstName" Type="String" />
          <Property Name="LastName" Type="String" />
          <Property Name="PersonID" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Companies" Relationship="testModel1.Companyperson" FromRole="person" ToRole="Company" />
        </EntityType>
        <EntityType Name="Company">
          <Key>
            <PropertyRef Name="CompanyID" />
          </Key>
          <Property Type="Int32" Name="CompanyID" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Type="String" Name="CompanyName" Nullable="false" />
          <NavigationProperty Name="people" Relationship="testModel1.Companyperson" FromRole="Company" ToRole="person" />
        </EntityType>
        <Association Name="Companyperson">
          <End Type="testModel1.Company" Role="Company" Multiplicity="*" />
          <End Type="testModel1.person" Role="person" Multiplicity="*" />
        </Association>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
    <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
  <EntityContainerMapping StorageEntityContainer="testModel1StoreContainer" CdmEntityContainer="testEntities1">
    <EntitySetMapping Name="people">
      <EntityTypeMapping TypeName="IsTypeOf(testModel1.person)">
        <MappingFragment StoreEntitySet="people">
          <ScalarProperty Name="PersonID" ColumnName="PersonID" />
          <ScalarProperty Name="FirstName" ColumnName="FirstName" />
          <ScalarProperty Name="LastName" ColumnName="LastName" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Companies">
      <EntityTypeMapping TypeName="IsTypeOf(testModel1.Company)">
        <MappingFragment StoreEntitySet="Companies">
          <ScalarProperty Name="CompanyID" ColumnName="CompanyID" />
          <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <AssociationSetMapping Name="Companyperson" TypeName="testModel1.Companyperson" StoreEntitySet="Companyperson">
      <EndProperty Name="Company">
        <ScalarProperty Name="CompanyID" ColumnName="Companies_CompanyID" />
      </EndProperty>
      <EndProperty Name="person">
        <ScalarProperty Name="PersonID" ColumnName="people_PersonID" />
      </EndProperty>
    </AssociationSetMapping>
  </EntityContainerMapping>
</Mapping></edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2008/10/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" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams>
      <Diagram Name="Model2">
        <EntityTypeShape EntityType="testModel1.person" Width="1.5" PointX="0.75" PointY="0.75" Height="1.59568359375" IsExpanded="true" />
        <EntityTypeShape EntityType="testModel1.Company" Width="1.5" PointX="3.375" PointY="1.625" Height="1.4033821614583331" />
        <AssociationConnector Association="testModel1.Companyperson">
          <ConnectorPoint PointX="3.375" PointY="2.0814925130208337" />
          <ConnectorPoint PointX="2.25" PointY="2.0814925130208337" />
        </AssociationConnector>
      </Diagram>
    </Diagrams>
  </Designer>
</edmx:Edmx>