NHibernate: References still being eagerly selected after specifying AddJoin
- by cbp
I have a query which is something like this:
Session.CreateSQLQuery(
@"SELECT f.*, b.*, z.* FROM Foo f
LEFT OUTER JOIN Bar b ON b.Id = f.BarId
LEFT OUTER JOIN Zar z ON z.Id = b.ZarId"
)
.AddEntity("f", typeof(Foo))
.AddJoin("b", "f.BarId")
.AddJoin("z", "f.ZarId")
.List<Foo>();
The problem is that I am still getting hundreds of SELECT requests
made to the Zar table, even though I have specified that Zar should be
joined.
As far as I am aware the only relationship is Foo-Bar-Zar, i.e. the
reference to Zar is not occurring anywhere else.
Is my understanding of AddJoin correct?
What could be going wrong?
List item
