Getting duplicate results in query

Question

I have Three tables A, B, and C. A is a parent table with mutiple child records in B and C.

When I query into A I am getting too many records, as though FNH is doing a Cartesian product.

My query is of the form:

var list = session.Query<A>()
  .Fetch(a=> a.Bs)
  .Fetch(a=> a.Cs)

Where Bs is the IList property of A, and Cs is the IList property of A.

I should get only as many Bs as relate to A, and only as many Cs relate to A. Instead I get BxC elements of each.

Is there a better way to load these? I am pretty sure I avoided this exact issue in the past, but don't see it in my old example code.

Firo · Accepted Answer · 2012-10-24 11:21:39Z

2

I'm not sure if this is a NH bug or a mapping issue, however the query could be optimised to

session.Query<A>()
    .Fetch(a=> a.Bs)
    .ToFuture();

var results = session.Query<A>()
    .Fetch(a=> a.Cs)
    .ToFuture()
    .ToList();

answered Oct 24, 2012 at 11:21

Firo

30.8k4 gold badges57 silver badges97 bronze badges

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

2 Comments

Daniel Williams Over a year ago

That did it, thank you. I am not familiar with ToFuture, but I son will be!

Firo Over a year ago

Future will batch to selects together and each will initialise one collection. The session cache will correlate the results together and results in both collections initialized

Sly · Accepted Answer · 2012-10-24 09:15:49Z

2

You could use a Transformer to get a distinct result:

var list = session.Query<A>()
  .Fetch(a=> a.Bs)
  .Fetch(a=> a.Cs)
  .SetResultTransformer( Transformers.DistinctRootEntity )

This is NH3.2 syntax, for 2.1 you need to use new DistinctRootEntityTransformer() (I think) as parameter to SetResultTransformer instead.

edited Oct 24, 2012 at 9:15

Sly

15.3k13 gold badges64 silver badges90 bronze badges

answered Oct 24, 2012 at 9:11

jishi

24.7k6 gold badges52 silver badges78 bronze badges

Collectives™ on Stack Overflow

Getting duplicate results in query

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related