using nHibernate to cast unmapped data into a DTO

Question

So I'm doing a postcode lookup provided by an outside data provider on a database that we're controlling with nHibernate. This involves calling a stored procedure and supplying a postcode. In return I get a number of rows each one of which contains multiple columns that make up the parts of the address.

We have an address DTO. But I'm struggling with how to cast the DB results into this object since it's not mapped to anything in the database. I'm doing this:

    Dim spCall As String = String.Format("exec AddressFindListPostCode '{0}'", postcode)
    Dim tran As Global.NHibernate.Transform.IResultTransformer = Global.NHibernate.Transform.Transformers.AliasToBean(GetType(Concrete.Cms.DataTransferObjects.Address))
    Dim streetList As IList(Of Concrete.Cms.DataTransferObjects.Address) = session.CreateSQLQuery(spCall).SetResultTransformer(tran).List(Of Concrete.Cms.DataTransferObjects.Address)()

But of course it can't transform the result set into an object without some help from a mapping of some kind.

The problem, essentially, is that the SP returns a List of objects. Each object (equivalent to a row) contains sub-objects which correspond to columns within the row. But I see no way of getting the sub-objects. streetList(i, j) won't work and there are no methods or properties on streetList that allow me to access them.

How do I get my data out to map it?

Cheers, Matt

rebelliard · Accepted Answer · 2014-10-17 22:31:07Z

7

You could try bulk loading the data into a bulk class, like:

 Dim result As IList(Of BulkLoadAddressList) = session.CreateSQLQuery(spCall)
    .SetResultTransformer(Transformers.AliasToBean(typeof(BulkLoadAddressList)))
    .List(Of BulkLoadAddressList)()

More: NHibernate Ad-hoc mapping

edited Oct 17, 2014 at 22:31

answered Sep 27, 2010 at 12:08

rebelliard

9,6217 gold badges49 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bob Tway Over a year ago

I've just tried that, and although it compiles and runs. my list object comes back empty. The Dto I've built is rather longer than your two-property example but no more complex (just a bunch of strings) .. any ideas what's going on?

Bob Tway Over a year ago

Got it - there was a naming mismatch between the recordset and the Dto. Thanks - as usual nHibernate turns out to be smarter than I expected :)

Collectives™ on Stack Overflow

using nHibernate to cast unmapped data into a DTO

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related