NHIbernate fetch returning multiple parent objects

Question

Can anyone explain why this query would return 12 companies (it has 12 UserAccessList children)

var list = session.QueryOver<Company>()
        .Where(x => x.Id == 1) //x => x.Id.IsIn(ids))
        .Fetch(l => l.UserAccessList).Eager()
        .List<Company>();

See answer to this question stackoverflow.com/questions/6221362/… — hazzik
– hazzik, Commented Aug 12, 2011 at 11:09

Owen Pauling · Accepted Answer · 2016-01-08 16:19:42Z

2

Because in SQL its going to be something like:

select * from 
Companies c left outer join UserAccessLists uac on c.Id == uac.CompanyId
where c.id = id

And it is giving duplicates in results. How to fix such issues you can read here.

edited Jan 8, 2016 at 16:19

Owen Pauling

12.1k20 gold badges58 silver badges67 bronze badges

answered Aug 12, 2011 at 11:51

Sly

15.3k13 gold badges64 silver badges90 bronze badges

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

Comments

jenson-button-event · Accepted Answer · 2011-08-12 14:53:39Z

1

This also works

var c = session.QueryOver<Company>()
        .Future();

 session.QueryOver<Company>()
        .Fetch(l => l.UserAccessList).Eager()
        .Future();

var list = c.ToList();

answered Aug 12, 2011 at 14:53

jenson-button-event

19k13 gold badges99 silver badges165 bronze badges

Collectives™ on Stack Overflow

NHIbernate fetch returning multiple parent objects

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related