123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155 |
- <?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="Хранилище P_ShabaninModel" 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="Book">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Title" Type="varchar" MaxLength="1000" Nullable="false" />
- <Property Name="Style" Type="varchar" MaxLength="100" Nullable="false" />
- <Property Name="Author" Type="varchar" MaxLength="1000" Nullable="false" />
- <Property Name="Cost" Type="varchar" MaxLength="100" Nullable="false" />
- <Property Name="Store" Type="int" Nullable="false" />
- <Property Name="Stock" Type="int" Nullable="false" />
- <Property Name="Description" Type="varchar" MaxLength="3500" Nullable="false" />
- <Property Name="Img" Type="varchar" MaxLength="100" Nullable="false" />
- </EntityType>
- <EntityType Name="BuyOrder">
- <Key>
- <PropertyRef Name="id" />
- </Key>
- <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="IdBook" Type="int" Nullable="false" />
- <Property Name="Count" Type="int" Nullable="false" />
- <Property Name="DateOrder" Type="date" Nullable="false" />
- </EntityType>
- <Association Name="FK_BuyOrder_Book">
- <End Role="Book" Type="Self.Book" Multiplicity="1" />
- <End Role="BuyOrder" Type="Self.BuyOrder" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Book">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="BuyOrder">
- <PropertyRef Name="IdBook" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <EntityContainer Name="Хранилище P_ShabaninModelContainer">
- <EntitySet Name="Book" EntityType="Self.Book" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="BuyOrder" EntityType="Self.BuyOrder" Schema="dbo" store:Type="Tables" />
- <AssociationSet Name="FK_BuyOrder_Book" Association="Self.FK_BuyOrder_Book">
- <End Role="Book" EntitySet="Book" />
- <End Role="BuyOrder" EntitySet="BuyOrder" />
- </AssociationSet>
- </EntityContainer>
- </Schema>
- </edmx:StorageModels>
- <!-- CSDL content -->
- <edmx:ConceptualModels>
- <Schema Namespace="P_ShabaninModel" 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="Book">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Title" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="Style" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="Author" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="Cost" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="Store" Type="Int32" Nullable="false" />
- <Property Name="Stock" Type="Int32" Nullable="false" />
- <Property Name="Description" Type="String" MaxLength="3500" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="Img" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
- <NavigationProperty Name="BuyOrder" Relationship="Self.FK_BuyOrder_Book" FromRole="Book" ToRole="BuyOrder" />
- </EntityType>
- <EntityType Name="BuyOrder">
- <Key>
- <PropertyRef Name="id" />
- </Key>
- <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="IdBook" Type="Int32" Nullable="false" />
- <Property Name="Count" Type="Int32" Nullable="false" />
- <Property Name="DateOrder" Type="DateTime" Nullable="false" Precision="0" />
- <NavigationProperty Name="Book" Relationship="Self.FK_BuyOrder_Book" FromRole="BuyOrder" ToRole="Book" />
- </EntityType>
- <Association Name="FK_BuyOrder_Book">
- <End Role="Book" Type="Self.Book" Multiplicity="1" />
- <End Role="BuyOrder" Type="Self.BuyOrder" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Book">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="BuyOrder">
- <PropertyRef Name="IdBook" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
- <EntitySet Name="Book" EntityType="Self.Book" />
- <EntitySet Name="BuyOrder" EntityType="Self.BuyOrder" />
- <AssociationSet Name="FK_BuyOrder_Book" Association="Self.FK_BuyOrder_Book">
- <End Role="Book" EntitySet="Book" />
- <End Role="BuyOrder" EntitySet="BuyOrder" />
- </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="Хранилище P_ShabaninModelContainer" CdmEntityContainer="Entities">
- <EntitySetMapping Name="Book">
- <EntityTypeMapping TypeName="P_ShabaninModel.Book">
- <MappingFragment StoreEntitySet="Book">
- <ScalarProperty Name="Id" ColumnName="Id" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="Style" ColumnName="Style" />
- <ScalarProperty Name="Author" ColumnName="Author" />
- <ScalarProperty Name="Cost" ColumnName="Cost" />
- <ScalarProperty Name="Store" ColumnName="Store" />
- <ScalarProperty Name="Stock" ColumnName="Stock" />
- <ScalarProperty Name="Description" ColumnName="Description" />
- <ScalarProperty Name="Img" ColumnName="Img" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="BuyOrder">
- <EntityTypeMapping TypeName="P_ShabaninModel.BuyOrder">
- <MappingFragment StoreEntitySet="BuyOrder">
- <ScalarProperty Name="id" ColumnName="id" />
- <ScalarProperty Name="IdBook" ColumnName="IdBook" />
- <ScalarProperty Name="Count" ColumnName="Count" />
- <ScalarProperty Name="DateOrder" ColumnName="DateOrder" />
- </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="Нет" />
- </DesignerInfoPropertySet>
- </Options>
- <!-- Diagram content (shape and connector positions) -->
- <Diagrams></Diagrams>
- </Designer>
- </edmx:Edmx>
|