Is it possible to query properties of either the first or last element in a one-to-many collection? I can't seem to get the functions index() or min/maxElement() to behave like I need them to. Here is an example:

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="Company.Business.Container, Company.Business" table="containers">
<id name="Id" type="Int32" column="id">
<generator class="native"/>
</id>

<bag name="ContainerItems" inverse="true" table="container_items" order-by="created_on DESC" lazy="true">
<key column = "container_id" />
<one-to-many class="Company.Business.ContainerItem, Company.Business" />
</bag>
</class>
</hibernate-mapping>

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="Company.Business.ContainerItem, URAC.Business" table="container_items">
<id name="Id" type="Int32" column="id">
<generator class="native"/>
</id>

<property name="CreatedOn" column="created_on" />
<many-to-one name="Container" class="Company.Business.Container, URAC.Business" column="container_id" unique="true" />
</class>
</hibernate-mapping>

I am trying to formulate a query that would allow me to say return the Container with the most recently added ContainerItem. In code this amounts to looking at container.ContainerItems[0].CreatedOn. Any help or direction would be appriciated. thanks!

I'm just quessing, but...

Given the orderby on the Bag, I think it returns as an ordered list (ordered by CreatedOn). This means you may be able to do this to get the most recent containerItem like so(not sure if this would work):


just a guess...