Question

I have this situation:

我有几张表_1,表_2. 表格_n,它们属于不同数据,但有些领域是共同的,记录_id,表格_id,如果是主要关键。所有这些表格都有单一分类记录(Id,表格,表格)。

我有另一个表象,有附件_id,记录_id,表格_id(记录_不足,因为记录_id可在表格上重复。页: 1

我想要将财产贴在班级记录中,以便从 t中获取记录。

你们能否帮助我绘制关于祖国的地图,以便做到这一点?

我感谢任何帮助。

Edit: Forgot to say that a Record on table_X can have multiple attachments :)

Answer 1

您可以通过任何途径实现这一点

abstract class RecordBase
{
    public virtual int Id { get; set; }

    public virtual int FormId { get; set; }
    public virtual ICollection<Attachment> Attachments { get; set; }
}

class RecordA : RecordBase
{ }

class Attachment
{
    public virtual int id { get; set; }

    public virtual RecordBase Record { get; set; }
}

class RecordAMap : ClassMap<RecordA>
{
    public RecordAMap()
    {
        HasMany(x => x.Attachments)
            .Where("Form_Id = 5");
    }
}

class AttachmentMap : ClassMap<Attachment>
{
    public AttachmentMap()
    {
        ReferencesAny(x => x.Record)
            .EntityIdentifierColumn("record_id")
            .EntityTypeColumn("form_id")
            .IdentityType<int>()
            .AddMetaValue<RecordA>("5");
    }
}

最新资料:xml绘图

<bag where="form_id=5">
  <key column="record_id"/>
  <one-to-many class="Attachment1"/>
</bag>

<any name="Item" id-type="System.Int32" meta-type="System.Int32">
  <column name="form_id" />
  <column name="record_id" />
</any>

友情链接