ResultSet to Object Mapper

sebenarnya klo di NHibernate ada subselect seperti di java gak bakalan buat yg ginian sih.

kemaren pas kerja dengan Java aku ada belajar bahwa sql query result dapat langsung di map ke object. kira2 mappingnya seperti ini.

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Welly.Exp.NHSubselect.ViewModel" namespace="Welly.Exp.NHSubselect.ViewModel">
  <class name="StockCardSnapshot" lazy="false">
    <subselect>
      select sc.scid, sc.partid, prt.prtname, prc.prcid, prc.prcname, prt.prtgroupid, prg.prgname, loc.locationid, loc.locname, sc.scavailable, sc.scbookingstock, sc.scbalance, uom.uomname
      from tblstockcard sc inner join
      tblpart prt on sc.partid = prt.partid inner join
      .......
    </subselect>
    <synchronize table="tblstockcard"/>
    <synchronize table="tblpart"/>
    .....
    
    <id name="ID" column="scid"/>
    <property name="Part" column="partid" type="String"/>
    <property name="Principal" column="prcname" type="String"/>
    ...
  </class>
</hibernate-mapping>

tapi aku coba jalanin di .NET. katanya subselect gak dikenalin di xml parser nya. Beh. Sial.

Advertisement