oops.
just needed to add
.SetResultTransformer(new
NHibernate.Transform.DistinctRootEntityResultTransformer())
to my Criteria
------
Joe Brockhaus
[email protected]
------
On Thu, Sep 8, 2011 at 3:41 PM, Joe Brockhaus <[email protected]>wrote:
> I have a customer entity with a child collection of telephone numbers,
> mapped inverse with join fetch.
>
> I've been using this for awhile now without noticing an issue.
>
> -- session.Get/Load<customer>(id) returns one entity with all the TNs,
> --- issuing a single statement to the database
> (select c.*,t.* from customers c left outer join telephones t on c.id=
> t.cid where id = blah)
> -- supposing this customer has 2 TNs, the query returns 2 rows, but NHib is
> smart enough to merge that into one entity, as it should.
>
>
> however ... when i query for multiple customers .. my resulting list IS NOT
> distinct.
> -- For the same customer above, for example, I'll see 2 (identical)
> customers in my list, with 2 TNs each.
>
> Is this a bug or do I need to add something to my criteria to pare down the
> results?
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
