Exam_Khasanov_V24/VideoprokatApp/Model1.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="Хранилище VideoprokatModel" 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="KlassifikatsionnyKod">
          <Key>
            <PropertyRef Name="KodFilma" />
          </Key>
          <Property Name="KodFilma" Type="int" Nullable="false" />
          <Property Name="NazvanieFilma" Type="nvarchar" MaxLength="100" />
          <Property Name="Zhanr" Type="nvarchar" MaxLength="50" />
        </EntityType>
        <EntityType Name="Klient">
          <Key>
            <PropertyRef Name="KodKlienta" />
          </Key>
          <Property Name="KodKlienta" Type="int" Nullable="false" />
          <Property Name="FIO" Type="nvarchar" MaxLength="100" />
          <Property Name="Adres" Type="nvarchar" MaxLength="255" />
          <Property Name="Telefon" Type="nvarchar" MaxLength="20" />
        </EntityType>
        <EntityType Name="OboorotnayaVedomost">
          <Key>
            <PropertyRef Name="KodKlienta" />
            <PropertyRef Name="NomerKassety" />
          </Key>
          <Property Name="KodKlienta" Type="int" Nullable="false" />
          <Property Name="NomerKassety" Type="int" Nullable="false" />
          <Property Name="DataVydachi" Type="date" />
          <Property Name="DataVozvrata" Type="date" />
          <Property Name="StoimostProkata" Type="decimal" Precision="10" Scale="2" />
        </EntityType>
        <EntityType Name="Videoteka">
          <Key>
            <PropertyRef Name="NomerKassety" />
          </Key>
          <Property Name="NomerKassety" Type="int" Nullable="false" />
          <Property Name="KodFilma" Type="int" />
          <Property Name="PriznakNalichiya" Type="bit" />
        </EntityType>
        <Association Name="FK__Oboorotna__KodKl__3D5E1FD2">
          <End Role="Klient" Type="Self.Klient" Multiplicity="1" />
          <End Role="OboorotnayaVedomost" Type="Self.OboorotnayaVedomost" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Klient">
              <PropertyRef Name="KodKlienta" />
            </Principal>
            <Dependent Role="OboorotnayaVedomost">
              <PropertyRef Name="KodKlienta" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Oboorotna__Nomer__3E52440B">
          <End Role="Videoteka" Type="Self.Videoteka" Multiplicity="1" />
          <End Role="OboorotnayaVedomost" Type="Self.OboorotnayaVedomost" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Videoteka">
              <PropertyRef Name="NomerKassety" />
            </Principal>
            <Dependent Role="OboorotnayaVedomost">
              <PropertyRef Name="NomerKassety" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Videoteka_KlassifikatsionnyKod">
          <End Role="KlassifikatsionnyKod" Type="Self.KlassifikatsionnyKod" Multiplicity="0..1" />
          <End Role="Videoteka" Type="Self.Videoteka" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="KlassifikatsionnyKod">
              <PropertyRef Name="KodFilma" />
            </Principal>
            <Dependent Role="Videoteka">
              <PropertyRef Name="KodFilma" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Function Name="fn_diagramobjects" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" ReturnType="int" />
        <Function Name="sp_alterdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
          <Parameter Name="version" Type="int" Mode="In" />
          <Parameter Name="definition" Type="varbinary(max)" Mode="In" />
        </Function>
        <Function Name="sp_creatediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
          <Parameter Name="version" Type="int" Mode="In" />
          <Parameter Name="definition" Type="varbinary(max)" Mode="In" />
        </Function>
        <Function Name="sp_dropdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
        </Function>
        <Function Name="sp_helpdiagramdefinition" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
        </Function>
        <Function Name="sp_helpdiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
        </Function>
        <Function Name="sp_renamediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
          <Parameter Name="new_diagramname" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="sp_upgraddiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
        <EntityContainer Name="Хранилище VideoprokatModelContainer">
          <EntitySet Name="KlassifikatsionnyKod" EntityType="Self.KlassifikatsionnyKod" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Klient" EntityType="Self.Klient" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="OboorotnayaVedomost" EntityType="Self.OboorotnayaVedomost" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Videoteka" EntityType="Self.Videoteka" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK__Oboorotna__KodKl__3D5E1FD2" Association="Self.FK__Oboorotna__KodKl__3D5E1FD2">
            <End Role="Klient" EntitySet="Klient" />
            <End Role="OboorotnayaVedomost" EntitySet="OboorotnayaVedomost" />
          </AssociationSet>
          <AssociationSet Name="FK__Oboorotna__Nomer__3E52440B" Association="Self.FK__Oboorotna__Nomer__3E52440B">
            <End Role="Videoteka" EntitySet="Videoteka" />
            <End Role="OboorotnayaVedomost" EntitySet="OboorotnayaVedomost" />
          </AssociationSet>
          <AssociationSet Name="FK_Videoteka_KlassifikatsionnyKod" Association="Self.FK_Videoteka_KlassifikatsionnyKod">
            <End Role="KlassifikatsionnyKod" EntitySet="KlassifikatsionnyKod" />
            <End Role="Videoteka" EntitySet="Videoteka" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="VideoprokatModel" 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="KlassifikatsionnyKod">
          <Key>
            <PropertyRef Name="KodFilma" />
          </Key>
          <Property Name="KodFilma" Type="Int32" Nullable="false" />
          <Property Name="NazvanieFilma" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="Zhanr" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Videoteka" Relationship="VideoprokatModel.FK_Videoteka_KlassifikatsionnyKod" FromRole="KlassifikatsionnyKod" ToRole="Videoteka" />
        </EntityType>
        <EntityType Name="Klient">
          <Key>
            <PropertyRef Name="KodKlienta" />
          </Key>
          <Property Name="KodKlienta" Type="Int32" Nullable="false" />
          <Property Name="FIO" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="Adres" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Telefon" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="OboorotnayaVedomost" Relationship="Self.FK__Oboorotna__KodKl__3D5E1FD2" FromRole="Klient" ToRole="OboorotnayaVedomost" />
        </EntityType>
        <EntityType Name="OboorotnayaVedomost">
          <Key>
            <PropertyRef Name="KodKlienta" />
            <PropertyRef Name="NomerKassety" />
          </Key>
          <Property Name="KodKlienta" Type="Int32" Nullable="false" />
          <Property Name="NomerKassety" Type="Int32" Nullable="false" />
          <Property Name="DataVydachi" Type="DateTime" Precision="0" />
          <Property Name="DataVozvrata" Type="DateTime" Precision="0" />
          <Property Name="StoimostProkata" Type="Decimal" Precision="10" Scale="2" />
          <NavigationProperty Name="Klient" Relationship="Self.FK__Oboorotna__KodKl__3D5E1FD2" FromRole="OboorotnayaVedomost" ToRole="Klient" />
          <NavigationProperty Name="Videoteka" Relationship="Self.FK__Oboorotna__Nomer__3E52440B" FromRole="OboorotnayaVedomost" ToRole="Videoteka" />
        </EntityType>
        <EntityType Name="Videoteka">
          <Key>
            <PropertyRef Name="NomerKassety" />
          </Key>
          <Property Name="NomerKassety" Type="Int32" Nullable="false" />
          <Property Name="KodFilma" Type="Int32" />
          <Property Name="PriznakNalichiya" Type="Boolean" />
          <NavigationProperty Name="OboorotnayaVedomost" Relationship="Self.FK__Oboorotna__Nomer__3E52440B" FromRole="Videoteka" ToRole="OboorotnayaVedomost" />
          <NavigationProperty Name="KlassifikatsionnyKod" Relationship="VideoprokatModel.FK_Videoteka_KlassifikatsionnyKod" FromRole="Videoteka" ToRole="KlassifikatsionnyKod" />
        </EntityType>
        <Association Name="FK__Oboorotna__KodKl__3D5E1FD2">
          <End Role="Klient" Type="Self.Klient" Multiplicity="1" />
          <End Role="OboorotnayaVedomost" Type="Self.OboorotnayaVedomost" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Klient">
              <PropertyRef Name="KodKlienta" />
            </Principal>
            <Dependent Role="OboorotnayaVedomost">
              <PropertyRef Name="KodKlienta" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Oboorotna__Nomer__3E52440B">
          <End Role="Videoteka" Type="Self.Videoteka" Multiplicity="1" />
          <End Role="OboorotnayaVedomost" Type="Self.OboorotnayaVedomost" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Videoteka">
              <PropertyRef Name="NomerKassety" />
            </Principal>
            <Dependent Role="OboorotnayaVedomost">
              <PropertyRef Name="NomerKassety" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="VideoprokatEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="KlassifikatsionnyKod" EntityType="Self.KlassifikatsionnyKod" />
          <EntitySet Name="Klient" EntityType="Self.Klient" />
          <EntitySet Name="OboorotnayaVedomost" EntityType="Self.OboorotnayaVedomost" />
          <EntitySet Name="Videoteka" EntityType="Self.Videoteka" />
          <AssociationSet Name="FK__Oboorotna__KodKl__3D5E1FD2" Association="Self.FK__Oboorotna__KodKl__3D5E1FD2">
            <End Role="Klient" EntitySet="Klient" />
            <End Role="OboorotnayaVedomost" EntitySet="OboorotnayaVedomost" />
          </AssociationSet>
          <AssociationSet Name="FK__Oboorotna__Nomer__3E52440B" Association="Self.FK__Oboorotna__Nomer__3E52440B">
            <End Role="Videoteka" EntitySet="Videoteka" />
            <End Role="OboorotnayaVedomost" EntitySet="OboorotnayaVedomost" />
          </AssociationSet>
          <AssociationSet Name="FK_Videoteka_KlassifikatsionnyKod" Association="VideoprokatModel.FK_Videoteka_KlassifikatsionnyKod">
            <End Role="KlassifikatsionnyKod" EntitySet="KlassifikatsionnyKod" />
            <End Role="Videoteka" EntitySet="Videoteka" />
          </AssociationSet>
          <FunctionImport Name="sp_alterdiagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
            <Parameter Name="version" Mode="In" Type="Int32" />
            <Parameter Name="definition" Mode="In" Type="Binary" />
          </FunctionImport>
          <FunctionImport Name="sp_creatediagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
            <Parameter Name="version" Mode="In" Type="Int32" />
            <Parameter Name="definition" Mode="In" Type="Binary" />
          </FunctionImport>
          <FunctionImport Name="sp_dropdiagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="sp_helpdiagramdefinition" ReturnType="Collection(VideoprokatModel.sp_helpdiagramdefinition_Result)">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="sp_helpdiagrams" ReturnType="Collection(VideoprokatModel.sp_helpdiagrams_Result)">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="sp_renamediagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
            <Parameter Name="new_diagramname" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="sp_upgraddiagrams" />
        </EntityContainer>
        <Association Name="FK_Videoteka_KlassifikatsionnyKod">
          <End Type="VideoprokatModel.KlassifikatsionnyKod" Role="KlassifikatsionnyKod" Multiplicity="0..1" />
          <End Type="VideoprokatModel.Videoteka" Role="Videoteka" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="KlassifikatsionnyKod">
              <PropertyRef Name="KodFilma" />
            </Principal>
            <Dependent Role="Videoteka">
              <PropertyRef Name="KodFilma" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <ComplexType Name="sp_helpdiagramdefinition_Result">
          <Property Type="Int32" Name="version" Nullable="true" />
          <Property Type="Binary" Name="definition" Nullable="true" />
        </ComplexType>
        <ComplexType Name="sp_helpdiagrams_Result">
          <Property Type="String" Name="Database" Nullable="true" MaxLength="128" />
          <Property Type="String" Name="Name" Nullable="false" MaxLength="128" />
          <Property Type="Int32" Name="ID" Nullable="false" />
          <Property Type="String" Name="Owner" Nullable="true" MaxLength="128" />
          <Property Type="Int32" Name="OwnerID" Nullable="false" />
        </ComplexType>
      </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="Хранилище VideoprokatModelContainer" CdmEntityContainer="VideoprokatEntities">
          <EntitySetMapping Name="KlassifikatsionnyKod">
            <EntityTypeMapping TypeName="VideoprokatModel.KlassifikatsionnyKod">
              <MappingFragment StoreEntitySet="KlassifikatsionnyKod">
                <ScalarProperty Name="KodFilma" ColumnName="KodFilma" />
                <ScalarProperty Name="NazvanieFilma" ColumnName="NazvanieFilma" />
                <ScalarProperty Name="Zhanr" ColumnName="Zhanr" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Klient">
            <EntityTypeMapping TypeName="VideoprokatModel.Klient">
              <MappingFragment StoreEntitySet="Klient">
                <ScalarProperty Name="KodKlienta" ColumnName="KodKlienta" />
                <ScalarProperty Name="FIO" ColumnName="FIO" />
                <ScalarProperty Name="Adres" ColumnName="Adres" />
                <ScalarProperty Name="Telefon" ColumnName="Telefon" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="OboorotnayaVedomost">
            <EntityTypeMapping TypeName="VideoprokatModel.OboorotnayaVedomost">
              <MappingFragment StoreEntitySet="OboorotnayaVedomost">
                <ScalarProperty Name="KodKlienta" ColumnName="KodKlienta" />
                <ScalarProperty Name="NomerKassety" ColumnName="NomerKassety" />
                <ScalarProperty Name="DataVydachi" ColumnName="DataVydachi" />
                <ScalarProperty Name="DataVozvrata" ColumnName="DataVozvrata" />
                <ScalarProperty Name="StoimostProkata" ColumnName="StoimostProkata" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Videoteka">
            <EntityTypeMapping TypeName="VideoprokatModel.Videoteka">
              <MappingFragment StoreEntitySet="Videoteka">
                <ScalarProperty Name="NomerKassety" ColumnName="NomerKassety" />
                <ScalarProperty Name="KodFilma" ColumnName="KodFilma" />
                <ScalarProperty Name="PriznakNalichiya" ColumnName="PriznakNalichiya" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="sp_alterdiagram" FunctionName="Хранилище VideoprokatModel.sp_alterdiagram" />
          <FunctionImportMapping FunctionImportName="sp_creatediagram" FunctionName="Хранилище VideoprokatModel.sp_creatediagram" />
          <FunctionImportMapping FunctionImportName="sp_dropdiagram" FunctionName="Хранилище VideoprokatModel.sp_dropdiagram" />
          <FunctionImportMapping FunctionImportName="sp_helpdiagramdefinition" FunctionName="Хранилище VideoprokatModel.sp_helpdiagramdefinition">
            <ResultMapping>
              <ComplexTypeMapping TypeName="VideoprokatModel.sp_helpdiagramdefinition_Result">
                <ScalarProperty Name="version" ColumnName="version" />
                <ScalarProperty Name="definition" ColumnName="definition" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="sp_helpdiagrams" FunctionName="Хранилище VideoprokatModel.sp_helpdiagrams">
            <ResultMapping>
              <ComplexTypeMapping TypeName="VideoprokatModel.sp_helpdiagrams_Result">
                <ScalarProperty Name="Database" ColumnName="Database" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="Owner" ColumnName="Owner" />
                <ScalarProperty Name="OwnerID" ColumnName="OwnerID" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="sp_renamediagram" FunctionName="Хранилище VideoprokatModel.sp_renamediagram" />
          <FunctionImportMapping FunctionImportName="sp_upgraddiagrams" FunctionName="Хранилище VideoprokatModel.sp_upgraddiagrams" />
        </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="Нет" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>