Complicated NHibernate component mapping

Answer 1

Hi, There is couple of tools that maps and builds class for you one of them is

mygeneration is the software http://sourceforge.net/projects/mygeneration/

In this page you find the templates that you need to run with the softwarehttp://www.mygenerationsoftware.com/TemplateLibrary/Archives/?query=nhibernate

After you have this in the mygeneration tool you only connect to your DB and it will generated for you

Answer 2

Unfortunately, you can't have a polymorphic structure in a component. But I'm acutally not sure if you need it.

The following code is straight from my head, so it certainly has errors or missing things and wouldn't compile. But it should show the direction:

public class ReportRow
{
  public int Id { get; private set; }
  public IList<IReportValue> Values { get; private set; }
}

public interface IReportValue
{
  public int Id{ get; set; }
  public object UntypedValue { get; }
}

public abstract class ReportValue<T> : IReportValue
{
  public int Id{ get; set; }
  public T Value { get; set; }
  public object UntypedValue { get { return Value; } }
}

public class ReportLongValue : ReportValue<long> {}
public class ReportStringValue : ReportValue<string> {}
public class ReportDateValue : ReportValue<DateTime>{}

Mapping:

<class ReportRow>
  <id ...>
  <bag name="Values" >
    <key column="RowNumber"/>
    <one-to-many class="IReportValue"/>
  </bag>
</class>

<class name="IReportValue" abstract="true">
  <id ...>
  <subclass name="ReportLongValue">
    <property name="Value" column="LongValue"/>
  </subclass>
  <subclass name="ReportStringValue">
    <property name="Value" column="StringValue"/>
  </subclass>
  <subclass name="ReportDateValue">
    <property name="Value" column="DateValue"/>
  </subclass>
</class>