Reuse component in projection (NHibernate)

Question

Is it possible to reuse a component mapping in a projection?

Here is the mapping for the Vendor entity:

   <class name="Vendor" table="vendor">
     ...
     <property name="Name" column="Name" />
     <component name="Address" class="MyProject.Address, MyAssembly" >
       <property name="Street" column="street" />
       <property name="City" column="City" />
     </component>
   </class>

For a report I'd like to retrieve these vendors in a data transfer object but reuse the Address component (because there are many fields and some useful formatting behavour).

public class VendorDTO
{
    public string Name;
    public Address Address;

}

public class Address
{
    public string Street;
    public string City;
    public string SomeUsefulBehavour();
}

Is this possible without splitting Address out into it's own table?

Thanks!

Do you want a query? What do you mean by "reuse a component mapping in a projection"? I don't understand the question... — Stefan Steinegger, Sep 30 '09 at 08:27
Possible hints - you can write your own ResultTranslators; you can try using HQL construct new Address(); I haven't tried either of them, so just hints. — Rashack, Sep 30 '09 at 13:43
Yes I was hoping for a query similar to: select new VendorDTO(vendor.Name, vendor.Address) from Vendor vendor Thanks for the hints. — Brian Low, Sep 30 '09 at 22:55
select new VendorDTO(vendor.Name, vendor.Address) does not work? — Stefan Steinegger, Oct 07 '09 at 07:48
I think you should be able to achieve this using AliasToBeanResultTransformer — Buthrakaur, Jul 05 '11 at 14:48

score 0 · Answer 1 · answered Sep 24 '12 at 08:04

0

I believe this should 'just work':

Session.QueryOver<Vendor>()
    .SelectList(builder =>
        builder.Select(x => x.Name)
            .Select(x => x.Address))
    .TransformUsing(Transformers.AliasToBean<VendorDTO>())
    .List<VendorDTO>();

answered Sep 24 '12 at 08:04

cbp

25,252
29
125
205

Reuse component in projection (NHibernate)

1 Answers1