代码之家  ›  专栏  ›  技术社区  ›  itchi

具有多重抽象继承的实体框架TPH

  •  1
  • itchi  · 技术社区  · 16 年前

    我试图在实体框架(VS2008SP1,3.5)中按层次结构模型创建一个表。

    我的大多数模型都非常简单,是一个抽象类型,有多个子类型继承自它。

    然而,我一直在努力应对这一最新挑战。我有一些学生,我想从个人那里继承(摘要),这些人应该从政党那里继承(摘要)。

    那么这可能吗?我可以通过使PERSONS abstract=false并指定一个伪造的条件映射来解决这个问题。但这似乎是一个愚蠢的解决办法。

    1 回复  |  直到 16 年前
        1
  •  2
  •   Devart    16 年前

    使用XML编辑器编辑模型:找到映射并将IsTypeOf添加到相应的EntityTypeMapping标记。
    以下是一个与您的案例类似的示例:

    CREATE TABLE [dbo].[Student] (
        [Id] [int] IDENTITY(1,1) NOT NULL,
        [PartyInfo] [varchar](max) NOT NULL,
        [PersonInfo] [varchar](max) NOT NULL,
        [StudInfo] [varchar](max) NOT NULL,
        CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED (  [Id] ASC  )
      )

    EDMX:

    <?xml version="1.0" encoding="utf-8"?>
    <edmx:Edmx Version="1.0" 
    xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx">
    <!-- EF Runtime content -->
    <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
      <Schema Namespace="test_1Model.Store" Alias="Self" 
    Provider="System.Data.SqlClient" ProviderManifestToken="2005" 
    xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" 
    xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">
        <EntityContainer Name="test_1ModelStoreContainer">
          <EntitySet Name="Student" EntityType="test_1Model.Store.Student" 
    store:Type="Tables" Schema="dbo" />
        </EntityContainer>
        <EntityType Name="Student">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" Nullable="false" 
    StoreGeneratedPattern="Identity" />
          <Property Name="PartyInfo" Type="varchar(max)" Nullable="false" />
          <Property Name="PersonInfo" Type="varchar(max)" Nullable="false" />
          <Property Name="StudInfo" Type="varchar(max)" Nullable="false" />
        </EntityType>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="test_1Model" Alias="Self" 
    xmlns="http://schemas.microsoft.com/ado/2006/04/edm">
        <EntityContainer Name="test_Entities">
          <EntitySet Name="PartySet" EntityType="test_1Model.Party" />
        </EntityContainer>
        <EntityType Name="Party" Abstract="true">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" />
          <Property Name="PartyInfo" Type="String" Nullable="false" 
    MaxLength="Max" Unicode="false" FixedLength="false" />
        </EntityType>
        <EntityType Name="Person" BaseType="test_1Model.Party" Abstract="true" >
          <Property Name="PersonInfo" Type="String" Nullable="false" />
        </EntityType>
        <EntityType Name="Student" BaseType="test_1Model.Person" >
          <Property Name="StudInfo" Type="String" Nullable="false" />
        </EntityType>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" 
    xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS">
        <EntityContainerMapping 
    StorageEntityContainer="test_1ModelStoreContainer" 
    CdmEntityContainer="test_Entities">
          <EntitySetMapping Name="PartySet">
            <EntityTypeMapping TypeName="IsTypeOf(test_1Model.Party)">
              <MappingFragment StoreEntitySet="Student">
                <ScalarProperty Name="PartyInfo" ColumnName="PartyInfo" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
            <EntityTypeMapping TypeName="IsTypeOf(test_1Model.Person)">
              <MappingFragment StoreEntitySet="Student">
                <ScalarProperty Name="Id" ColumnName="Id" />
                <ScalarProperty Name="PersonInfo" ColumnName="PersonInfo" />
              </MappingFragment>
            </EntityTypeMapping>
            <EntityTypeMapping TypeName="test_1Model.Student">
              <MappingFragment StoreEntitySet="Student">
                <ScalarProperty Name="PartyInfo" ColumnName="PartyInfo" />
                <ScalarProperty Name="PersonInfo" ColumnName="PersonInfo" />
                <ScalarProperty Name="Id" ColumnName="Id" />
                <ScalarProperty Name="StudInfo" ColumnName="StudInfo" />
              </MappingFragment>
            </EntityTypeMapping>
         </EntitySetMapping>
      </EntityContainerMapping>
    </Mapping>
    </edmx:Mappings>
    </edmx:Runtime>
    <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
    <edmx:Designer xmlns="http://schemas.microsoft.com/ado/2007/06/edmx">
        <edmx:Connection>
          <DesignerInfoPropertySet>
            <DesignerProperty Name="MetadataArtifactProcessing" 
    Value="EmbedInOutputAssembly" />
          </DesignerInfoPropertySet>
        </edmx:Connection>
      <edmx:Options>
        <DesignerInfoPropertySet>
          <DesignerProperty Name="ValidateOnBuild" Value="true" />
        </DesignerInfoPropertySet>
      </edmx:Options>
      <!-- Diagram content (shape and connector positions) -->
      <edmx:Diagrams>
        <Diagram Name="SqlServer_Model" />
      </edmx:Diagrams>
    </edmx:Designer>
    </edmx:Edmx>