Archive
Posts Tagged ‘Reflection’
ResultSet to Object Mapper
March 10, 2010
1 comment
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.
Read more…
Categories: .NET
.NET, Mapper, Reflection, Spring .NET