需要NHibernate /流利NHibernate映射的帮助 [英] Need help with NHibernate / Fluent NHibernate mapping

问题描述

假设你的表结构如下：

  ============== ================ 
 |案例| 
 ============================== 
 | Id | int | 
 |引用类型| varchar（10）| 
 + --------- | ReferralId | int | --------- + 
 | ============================== | 
 | | | 
 | | | 
 ====================== ====================== == ==================== 
 | SourceA | | SourceB | | SourceC | 
 ====================== ====================== == ==================== 
 | Id | int | | Id | int | | Id | int | 
 |名称| varchar（50）| |名称| varchar（50）| |名称| varchar（50）| 
 ====================== ====================== == ==================== 
  

基于在ReferralType的ReferralId包含id到SourceA，SourceB或SourceC

我试图弄清楚如何映射这个使用流利NHibernate或只是普通的NHibernate到一个对象模型。我尝试了一堆不同的东西，但我还没有成功。任何想法？

对象模型可能类似于：

pre $ 公共类Case {
{
public int Id {get;组; }
public referral {get;组; }
}

public class Referral
{
public string Type {get;组; }
public int Id {get;组; }
public string Name {get;组; }
}


解决方案

通过执行以下操作：

  public class Case 
 {
 public virtual int？ Id {get;组; } 
 public virtual CaseReferral Referral {get;组; } 
} 
 public class CaseReferral 
 {
 public virtual string Type {get;保护组} 
 public virtual int？ ReferralId {get;保护组} 
 public virtual string Name {get {return null; } 
 
 //注意：我们需要这个映射的原因
 protected virtual int CaseId {get;组; } 
 protected CaseSourceAReferral：CaseReferral 
 {
 private SourceA _sourceA; 
 public virtual SourceA Source 
 {
 get {return _sourceA; } 
保护集
 {
 _sourceA = value; 
 
 Type =SourceA; 
 ReferralId =（_sourceA！= null？_sourceA.Id：null）; 
} 
} 
 
 public override string Name {get {return Source.Name; 
保护CaseSourceAReferral（）{} $ b $ public CaseSourceAReferral（int caseId，SourceA source）
 {
 CaseId = caseId; 
来源=来源; 
} 
} 
 
 public class CaseMap：ClassMap< Case> 
 {
 public CaseMap（）
 {
 Id（c => c.Id）; 
参考文献（c => c.Referral）.Column（Id）; 
} 
} 
 
 public class CaseReferralMap：ClassMap< CaseReferral> 
 {
 public CaseReferralMap（）
 {
 Id（Reveal.Property< CaseReferral>（CaseId））.Column（Id）; 
 Map（r => r.Type）.Column（ReferralType）; 
 Map（r => r.ReferralId）.Column（ReferralId）; 
 DiscriminateSubClassesOnColumn（ReferralType）; 
} 
} 
 
 public class CaseSourceAReferralMap：SubclassMap< CaseSourceAReferral> 
 {
 public CaseSourceAReferralMap（）
 {
 DiscriminatorValue（SourceA）; 
引用（r => r.Source）.Column（ReferralId）; 
} 
} 
  

Let's say your have the following table structure:

                  ==============================  
                  | Case                       |
                  ==============================
                  | Id           | int         |
                  | ReferralType | varchar(10) |
        +---------| ReferralId   | int         |---------+
        |         ==============================         |
        |                      |                         |
        |                      |                         |
======================  ======================  ======================        
| SourceA            |  | SourceB            |  | SourceC            |
======================  ======================  ======================
| Id   | int         |  | Id   | int         |  | Id   | int         |
| Name | varchar(50) |  | Name | varchar(50) |  | Name | varchar(50) |
======================  ======================  ======================

Based on the ReferralType the ReferralId contains id to the SourceA, SourceB, or SourceC

I'm trying to figure out how to map this using Fluent NHibernate or just plain NHibernate into an object model. I've tried a bunch of different things but I haven't been succesful. Any ideas?

The object model might be something like:

public class Case
{ 
  public int Id { get; set; }
  public Referral { get; set; }
}

public class Referral
{
  public string Type { get; set; }
  public int Id { get; set; }
  public string Name { get; set; }
}

解决方案

I managed to get it working by doing the following:

public class Case
{
  public virtual int? Id { get; set; }
  public virtual CaseReferral Referral { get; set; }
}
public class CaseReferral
{
  public virtual string Type { get; protected set; }
  public virtual int? ReferralId { get; protected set; }
  public virtual string Name { get { return null; }

  //NOTE: We need this for mapping reasons
  protected virtual int CaseId { get; set; }
  protected CaseReferral() { }
}

public class CaseSourceAReferral : CaseReferral
{
  private SourceA _sourceA;
  public virtual SourceA Source
  {
    get { return _sourceA; }
    protected set
    {
      _sourceA = value;

      Type = "SourceA";
      ReferralId = ( _sourceA != null ? _sourceA.Id : null );
    }
  }

  public override string Name { get { return Source.Name; } }

  //NOTE: Default constructor for mapping reasons
  protected CaseSourceAReferral() { }
  public CaseSourceAReferral( int caseId, SourceA source )
  {
    CaseId = caseId;
    Source = source;
  }
}

public class CaseMap : ClassMap<Case>
{
  public CaseMap()
  {
    Id( c => c.Id );
    References( c => c.Referral ).Column( "Id" );
  }
}

public class CaseReferralMap : ClassMap<CaseReferral>
{
  public CaseReferralMap()
  {
    Id( Reveal.Property<CaseReferral>( "CaseId") ).Column( "Id" );
    Map( r => r.Type ).Column( "ReferralType" );
    Map( r => r.ReferralId ).Column( "ReferralId" );
    DiscriminateSubClassesOnColumn( "ReferralType" );
  }
}

public class CaseSourceAReferralMap : SubclassMap<CaseSourceAReferral>
{
  public CaseSourceAReferralMap()
  {
    DiscriminatorValue( "SourceA" );
    References( r => r.Source ).Column( "ReferralId" );
  }
}

这篇关于需要NHibernate /流利NHibernate映射的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！