Hi all!

I have a map:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="Picture"
table="tb_picture">
<id name="id" column="id" type="Int64" unsaved-value="0"> <generator class="identity" />
</id>
<discriminator column="dsc"></discriminator>
<property name="caption" column="caption" type="String(50)"/>
<property name="idGoods" column="id_goods" type="Int64"/>
<many-to-one name="type"
class="PictureType"
column="id_picture_type"/>

<subclass name="PictureData, Core" discriminator-value="1">
<property name="data" column="data" type="BinaryBlob"></property>
</subclass>

</class>
</hibernate-mapping>

and when I make the following query:
FROM Picture picture WHERE picture.idGoods = :idGoods

it returns objects of PictureData class but I need objects of Picture class

How can I get this result?

Thanks.

Does your query return just PictureData objects or all objects?

I had a similar query that was returning all objects:
(pardon my vb)

After adding " where dsc='x'" to the hql, the list was narrowed down correctly. Maybe someone else knows the correct technique?

I really don't see where the problem is, since PictureDate object ARE Picture object...

Besides, nhibernate should be returning a collection of Picture and PictureData objects depending on the discriminator value. The whole point of inheritance is that you can use both as if they where Picture objects.