CopyCenter/CopyCenterTests/Model2.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="gr672_liiModel.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="Card">
          <Key>
            <PropertyRef Name="idCard" />
          </Key>
          <Property Name="idCard" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="NumberCard" Type="int" Nullable="false" />
          <Property Name="TypeCard" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="idClient" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="CategoryService">
          <Key>
            <PropertyRef Name="idCategory" />
          </Key>
          <Property Name="idCategory" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="NameCategory" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="Client">
          <Key>
            <PropertyRef Name="idClient" />
          </Key>
          <Property Name="idClient" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="NameClient" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="TypeClient" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="Discount">
          <Key>
            <PropertyRef Name="idDiscount" />
          </Key>
          <Property Name="idDiscount" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Procent" Type="int" Nullable="false" />
          <Property Name="idOrder" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Order">
          <Key>
            <PropertyRef Name="idOrder" />
          </Key>
          <Property Name="idOrder" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="NumberOrder" Type="int" Nullable="false" />
          <Property Name="ViewOrder" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="OrderDate" Type="date" Nullable="false" />
          <Property Name="CostOrder" Type="int" Nullable="false" />
          <Property Name="idClient" Type="int" Nullable="false" />
          <Property Name="idService" Type="int" Nullable="false" />
          <Property Name="idUser" Type="int" Nullable="false" />
          <Property Name="idPayment" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Payment">
          <Key>
            <PropertyRef Name="idPayment" />
          </Key>
          <Property Name="idPayment" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="NumberPayment" Type="int" Nullable="false" />
          <Property Name="DatePayment" Type="date" Nullable="false" />
        </EntityType>
        <EntityType Name="Service">
          <Key>
            <PropertyRef Name="idService" />
          </Key>
          <Property Name="idService" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="NameService" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="PriceService" Type="int" Nullable="false" />
          <Property Name="DescriptionService" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="idCategory" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="User">
          <Key>
            <PropertyRef Name="idUser" />
          </Key>
          <Property Name="idUser" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Login" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Password" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="LastName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="FirstName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="50" />
          <Property Name="ContactNumber" Type="int" Nullable="false" />
        </EntityType>
        <Association Name="FK_Card_Client">
          <End Role="Client" Type="Self.Client" Multiplicity="1" />
          <End Role="Card" Type="Self.Card" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Client">
              <PropertyRef Name="idClient" />
            </Principal>
            <Dependent Role="Card">
              <PropertyRef Name="idClient" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Discount_Order">
          <End Role="Order" Type="Self.Order" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Discount" Type="Self.Discount" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Order">
              <PropertyRef Name="idOrder" />
            </Principal>
            <Dependent Role="Discount">
              <PropertyRef Name="idOrder" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Order_Client">
          <End Role="Client" Type="Self.Client" Multiplicity="1" />
          <End Role="Order" Type="Self.Order" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Client">
              <PropertyRef Name="idClient" />
            </Principal>
            <Dependent Role="Order">
              <PropertyRef Name="idClient" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Order_Payment">
          <End Role="Payment" Type="Self.Payment" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Order" Type="Self.Order" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Payment">
              <PropertyRef Name="idPayment" />
            </Principal>
            <Dependent Role="Order">
              <PropertyRef Name="idPayment" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Order_Service">
          <End Role="Service" Type="Self.Service" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Order" Type="Self.Order" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Service">
              <PropertyRef Name="idService" />
            </Principal>
            <Dependent Role="Order">
              <PropertyRef Name="idService" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Order_User">
          <End Role="User" Type="Self.User" Multiplicity="1" />
          <End Role="Order" Type="Self.Order" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="User">
              <PropertyRef Name="idUser" />
            </Principal>
            <Dependent Role="Order">
              <PropertyRef Name="idUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Service_CategoryService">
          <End Role="CategoryService" Type="Self.CategoryService" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Service" Type="Self.Service" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CategoryService">
              <PropertyRef Name="idCategory" />
            </Principal>
            <Dependent Role="Service">
              <PropertyRef Name="idCategory" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="gr672_liiModelStoreContainer">
          <EntitySet Name="Card" EntityType="Self.Card" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="CategoryService" EntityType="Self.CategoryService" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Client" EntityType="Self.Client" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Discount" EntityType="Self.Discount" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Order" EntityType="Self.Order" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Payment" EntityType="Self.Payment" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Service" EntityType="Self.Service" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="User" EntityType="Self.User" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_Card_Client" Association="Self.FK_Card_Client">
            <End Role="Client" EntitySet="Client" />
            <End Role="Card" EntitySet="Card" />
          </AssociationSet>
          <AssociationSet Name="FK_Discount_Order" Association="Self.FK_Discount_Order">
            <End Role="Order" EntitySet="Order" />
            <End Role="Discount" EntitySet="Discount" />
          </AssociationSet>
          <AssociationSet Name="FK_Order_Client" Association="Self.FK_Order_Client">
            <End Role="Client" EntitySet="Client" />
            <End Role="Order" EntitySet="Order" />
          </AssociationSet>
          <AssociationSet Name="FK_Order_Payment" Association="Self.FK_Order_Payment">
            <End Role="Payment" EntitySet="Payment" />
            <End Role="Order" EntitySet="Order" />
          </AssociationSet>
          <AssociationSet Name="FK_Order_Service" Association="Self.FK_Order_Service">
            <End Role="Service" EntitySet="Service" />
            <End Role="Order" EntitySet="Order" />
          </AssociationSet>
          <AssociationSet Name="FK_Order_User" Association="Self.FK_Order_User">
            <End Role="User" EntitySet="User" />
            <End Role="Order" EntitySet="Order" />
          </AssociationSet>
          <AssociationSet Name="FK_Service_CategoryService" Association="Self.FK_Service_CategoryService">
            <End Role="CategoryService" EntitySet="CategoryService" />
            <End Role="Service" EntitySet="Service" />
          </AssociationSet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="gr672_liiModel" 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="Card">
          <Key>
            <PropertyRef Name="idCard" />
          </Key>
          <Property Name="idCard" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="NumberCard" Type="Int32" Nullable="false" />
          <Property Name="TypeCard" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="idClient" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Client" Relationship="Self.FK_Card_Client" FromRole="Card" ToRole="Client" />
        </EntityType>
        <EntityType Name="CategoryService">
          <Key>
            <PropertyRef Name="idCategory" />
          </Key>
          <Property Name="idCategory" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="NameCategory" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="Service" Relationship="Self.FK_Service_CategoryService" FromRole="CategoryService" ToRole="Service" />
        </EntityType>
        <EntityType Name="Client">
          <Key>
            <PropertyRef Name="idClient" />
          </Key>
          <Property Name="idClient" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="NameClient" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="TypeClient" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="Card" Relationship="Self.FK_Card_Client" FromRole="Client" ToRole="Card" />
          <NavigationProperty Name="Order" Relationship="Self.FK_Order_Client" FromRole="Client" ToRole="Order" />
        </EntityType>
        <EntityType Name="Discount">
          <Key>
            <PropertyRef Name="idDiscount" />
          </Key>
          <Property Name="idDiscount" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Procent" Type="Int32" Nullable="false" />
          <Property Name="idOrder" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Order" Relationship="Self.FK_Discount_Order" FromRole="Discount" ToRole="Order" />
        </EntityType>
        <EntityType Name="Order">
          <Key>
            <PropertyRef Name="idOrder" />
          </Key>
          <Property Name="idOrder" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="NumberOrder" Type="Int32" Nullable="false" />
          <Property Name="ViewOrder" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="OrderDate" Type="DateTime" Nullable="false" />
          <Property Name="CostOrder" Type="Int32" Nullable="false" />
          <Property Name="idClient" Type="Int32" Nullable="false" />
          <Property Name="idService" Type="Int32" Nullable="false" />
          <Property Name="idUser" Type="Int32" Nullable="false" />
          <Property Name="idPayment" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Client" Relationship="Self.FK_Order_Client" FromRole="Order" ToRole="Client" />
          <NavigationProperty Name="Discount" Relationship="Self.FK_Discount_Order" FromRole="Order" ToRole="Discount" />
          <NavigationProperty Name="Payment" Relationship="Self.FK_Order_Payment" FromRole="Order" ToRole="Payment" />
          <NavigationProperty Name="Service" Relationship="Self.FK_Order_Service" FromRole="Order" ToRole="Service" />
          <NavigationProperty Name="User" Relationship="Self.FK_Order_User" FromRole="Order" ToRole="User" />
        </EntityType>
        <EntityType Name="Payment">
          <Key>
            <PropertyRef Name="idPayment" />
          </Key>
          <Property Name="idPayment" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="NumberPayment" Type="Int32" Nullable="false" />
          <Property Name="DatePayment" Type="DateTime" Nullable="false" />
          <NavigationProperty Name="Order" Relationship="Self.FK_Order_Payment" FromRole="Payment" ToRole="Order" />
        </EntityType>
        <EntityType Name="Service">
          <Key>
            <PropertyRef Name="idService" />
          </Key>
          <Property Name="idService" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="NameService" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="PriceService" Type="Int32" Nullable="false" />
          <Property Name="DescriptionService" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="idCategory" Type="Int32" Nullable="false" />
          <NavigationProperty Name="CategoryService" Relationship="Self.FK_Service_CategoryService" FromRole="Service" ToRole="CategoryService" />
          <NavigationProperty Name="Order" Relationship="Self.FK_Order_Service" FromRole="Service" ToRole="Order" />
        </EntityType>
        <EntityType Name="User">
          <Key>
            <PropertyRef Name="idUser" />
          </Key>
          <Property Name="idUser" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Login" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Password" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="LastName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="FirstName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="ContactNumber" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Order" Relationship="Self.FK_Order_User" FromRole="User" ToRole="Order" />
        </EntityType>
        <Association Name="FK_Card_Client">
          <End Role="Client" Type="Self.Client" Multiplicity="1" />
          <End Role="Card" Type="Self.Card" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Client">
              <PropertyRef Name="idClient" />
            </Principal>
            <Dependent Role="Card">
              <PropertyRef Name="idClient" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Service_CategoryService">
          <End Role="CategoryService" Type="Self.CategoryService" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Service" Type="Self.Service" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CategoryService">
              <PropertyRef Name="idCategory" />
            </Principal>
            <Dependent Role="Service">
              <PropertyRef Name="idCategory" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Order_Client">
          <End Role="Client" Type="Self.Client" Multiplicity="1" />
          <End Role="Order" Type="Self.Order" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Client">
              <PropertyRef Name="idClient" />
            </Principal>
            <Dependent Role="Order">
              <PropertyRef Name="idClient" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Discount_Order">
          <End Role="Order" Type="Self.Order" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Discount" Type="Self.Discount" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Order">
              <PropertyRef Name="idOrder" />
            </Principal>
            <Dependent Role="Discount">
              <PropertyRef Name="idOrder" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Order_Payment">
          <End Role="Payment" Type="Self.Payment" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Order" Type="Self.Order" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Payment">
              <PropertyRef Name="idPayment" />
            </Principal>
            <Dependent Role="Order">
              <PropertyRef Name="idPayment" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Order_Service">
          <End Role="Service" Type="Self.Service" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Order" Type="Self.Order" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Service">
              <PropertyRef Name="idService" />
            </Principal>
            <Dependent Role="Order">
              <PropertyRef Name="idService" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Order_User">
          <End Role="User" Type="Self.User" Multiplicity="1" />
          <End Role="Order" Type="Self.Order" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="User">
              <PropertyRef Name="idUser" />
            </Principal>
            <Dependent Role="Order">
              <PropertyRef Name="idUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="gr672_liiEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Card" EntityType="Self.Card" />
          <EntitySet Name="CategoryService" EntityType="Self.CategoryService" />
          <EntitySet Name="Client" EntityType="Self.Client" />
          <EntitySet Name="Discount" EntityType="Self.Discount" />
          <EntitySet Name="Order" EntityType="Self.Order" />
          <EntitySet Name="Payment" EntityType="Self.Payment" />
          <EntitySet Name="Service" EntityType="Self.Service" />
          <EntitySet Name="User" EntityType="Self.User" />
          <AssociationSet Name="FK_Card_Client" Association="Self.FK_Card_Client">
            <End Role="Client" EntitySet="Client" />
            <End Role="Card" EntitySet="Card" />
          </AssociationSet>
          <AssociationSet Name="FK_Service_CategoryService" Association="Self.FK_Service_CategoryService">
            <End Role="CategoryService" EntitySet="CategoryService" />
            <End Role="Service" EntitySet="Service" />
          </AssociationSet>
          <AssociationSet Name="FK_Order_Client" Association="Self.FK_Order_Client">
            <End Role="Client" EntitySet="Client" />
            <End Role="Order" EntitySet="Order" />
          </AssociationSet>
          <AssociationSet Name="FK_Discount_Order" Association="Self.FK_Discount_Order">
            <End Role="Order" EntitySet="Order" />
            <End Role="Discount" EntitySet="Discount" />
          </AssociationSet>
          <AssociationSet Name="FK_Order_Payment" Association="Self.FK_Order_Payment">
            <End Role="Payment" EntitySet="Payment" />
            <End Role="Order" EntitySet="Order" />
          </AssociationSet>
          <AssociationSet Name="FK_Order_Service" Association="Self.FK_Order_Service">
            <End Role="Service" EntitySet="Service" />
            <End Role="Order" EntitySet="Order" />
          </AssociationSet>
          <AssociationSet Name="FK_Order_User" Association="Self.FK_Order_User">
            <End Role="User" EntitySet="User" />
            <End Role="Order" EntitySet="Order" />
          </AssociationSet>
        </EntityContainer>
      </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="gr672_liiModelStoreContainer" CdmEntityContainer="gr672_liiEntities">
          <EntitySetMapping Name="Card">
            <EntityTypeMapping TypeName="gr672_liiModel.Card">
              <MappingFragment StoreEntitySet="Card">
                <ScalarProperty Name="idCard" ColumnName="idCard" />
                <ScalarProperty Name="NumberCard" ColumnName="NumberCard" />
                <ScalarProperty Name="TypeCard" ColumnName="TypeCard" />
                <ScalarProperty Name="idClient" ColumnName="idClient" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="CategoryService">
            <EntityTypeMapping TypeName="gr672_liiModel.CategoryService">
              <MappingFragment StoreEntitySet="CategoryService">
                <ScalarProperty Name="idCategory" ColumnName="idCategory" />
                <ScalarProperty Name="NameCategory" ColumnName="NameCategory" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Client">
            <EntityTypeMapping TypeName="gr672_liiModel.Client">
              <MappingFragment StoreEntitySet="Client">
                <ScalarProperty Name="idClient" ColumnName="idClient" />
                <ScalarProperty Name="NameClient" ColumnName="NameClient" />
                <ScalarProperty Name="TypeClient" ColumnName="TypeClient" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Discount">
            <EntityTypeMapping TypeName="gr672_liiModel.Discount">
              <MappingFragment StoreEntitySet="Discount">
                <ScalarProperty Name="idDiscount" ColumnName="idDiscount" />
                <ScalarProperty Name="Procent" ColumnName="Procent" />
                <ScalarProperty Name="idOrder" ColumnName="idOrder" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Order">
            <EntityTypeMapping TypeName="gr672_liiModel.Order">
              <MappingFragment StoreEntitySet="Order">
                <ScalarProperty Name="idOrder" ColumnName="idOrder" />
                <ScalarProperty Name="NumberOrder" ColumnName="NumberOrder" />
                <ScalarProperty Name="ViewOrder" ColumnName="ViewOrder" />
                <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
                <ScalarProperty Name="CostOrder" ColumnName="CostOrder" />
                <ScalarProperty Name="idClient" ColumnName="idClient" />
                <ScalarProperty Name="idService" ColumnName="idService" />
                <ScalarProperty Name="idUser" ColumnName="idUser" />
                <ScalarProperty Name="idPayment" ColumnName="idPayment" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Payment">
            <EntityTypeMapping TypeName="gr672_liiModel.Payment">
              <MappingFragment StoreEntitySet="Payment">
                <ScalarProperty Name="idPayment" ColumnName="idPayment" />
                <ScalarProperty Name="NumberPayment" ColumnName="NumberPayment" />
                <ScalarProperty Name="DatePayment" ColumnName="DatePayment" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Service">
            <EntityTypeMapping TypeName="gr672_liiModel.Service">
              <MappingFragment StoreEntitySet="Service">
                <ScalarProperty Name="idService" ColumnName="idService" />
                <ScalarProperty Name="NameService" ColumnName="NameService" />
                <ScalarProperty Name="PriceService" ColumnName="PriceService" />
                <ScalarProperty Name="DescriptionService" ColumnName="DescriptionService" />
                <ScalarProperty Name="idCategory" ColumnName="idCategory" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="User">
            <EntityTypeMapping TypeName="gr672_liiModel.User">
              <MappingFragment StoreEntitySet="User">
                <ScalarProperty Name="idUser" ColumnName="idUser" />
                <ScalarProperty Name="Login" ColumnName="Login" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                <ScalarProperty Name="ContactNumber" ColumnName="ContactNumber" />
              </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="false" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>