Is this the right way to eager load child collections in NHibernate

by

I would like to append different point of view, not the answer how to use “future” to make only one round-trip to DB.

Not sure why you need to fetch all the properties. I guess it could be 1) to be used by your code, e.g. to render UI or 2) as the API which somehow serializes that and passes it to the client.

In the first scenario, I would suggest to use the session per request and use the lazy load. In the second, I would suggest to introduce one step: building the DTO before passing it to client. That could be done while session is still open, therefore use the lazy load.

Lazy load in both scenarios. So, in both cases I would suggest to use different approach then explicit fetching. It will use more or less the same amount of selects and round-trips to DB. But at the end it could be more effective. Because all that job would be left on the NHibernate

The thing is to change the eager-fetch (manual) loading with the batch-size (native) loading. See more here 19.1.5. Using batch fetching. In this case, NHibernate will process your query, and then will go again with few more queries to load the remaining data. But only if really needed

The advantage is, that you are not a prisoner of your queries. You can consume any property which could/should be available on the entity, until the session is open (I.e. during View rendering or serializing). You do not have to go and append another explicit query over join to get eager data.

So, while Future could be solution to the world were your connectivity to DB from APP is very slow… it is not the world were to use NHibernate (ORM). The advantage of the lazy mapping and ad hoc loading (with power of batching) is from maintenance perspective the right way… I’d say

More Related Contents:

  1. What is the difference between JoinQueryOver and JoinAlias?
  2. How to Eager Load Associations without duplication in NHibernate?
  3. Nhibernate: How to represent Many-To-Many relationships with One-to-Many relationships?
  4. What are the First and Second Level caches in (N)Hibernate?
  5. Inverse Attribute in NHibernate
  6. NHibernate QueryOver with Fetch resulting multiple sql queries and db hits
  7. Fighting cartesian product (x-join) when using NHibernate 3.0.0
  8. What’s the difference between session.Merge and session.SaveOrUpdate?
  9. How do you map an enum as an int value with fluent NHibernate?
  10. JSON.NET and nHibernate Lazy Loading of Collections
  11. List vs Set vs Bag in NHibernate
  12. When to use inverse=false on NHibernate / Hibernate OneToMany relationships?
  13. nHibernate mapping to custom types
  14. IndexOutOfRangeException Deep in the bowels of NHibernate
  15. Unable to cast object of type NHibernate.Collection.Generic.PersistentGenericBag to List
  16. How to create OR statements for NHibernate?
  17. Binary Blob truncated to 8000 bytes – SQL Server 2008 / varbinary(max)
  18. How to save a child with assigned id in nhibernate
  19. NHibernate configuration for uni-directional one-to-many relation
  20. Generate XML mappings from fluent Nhibernate
  21. How do I view the SQL that is generated by nHibernate?
  22. Get Distinct result set from NHibernate using Criteria API?
  23. DateTime precision in NHibernate and support for DateTime2 in NHibernate SchemeExport
  24. Why doesn’t Entity Framework support ODBC?
  25. NHibernate: difference between Interceptor and Listener
  26. What exactly is “persistence ignorance”?
  27. How do add NOLOCK with nHibernate?
  28. Syntax to define a NHibernate Filter with Fluent Nhibernate?
  29. Identifying NHibernate proxy classes
  30. What should be the lifetime of an NHibernate session?

Leave a Comment