Ayende proposes solutions for the Select N+1 problem in NHibernate.
Some will say it is a sign that lazy load is the work of the devil. But I can remember the time when people were saying that garbage collectors are evil.
We all would like to have non intrusive data fetching strategy that work 99% of the time !
The problem is not about lazy load or not. It is that you must take care about your data fetching strategy whenever you make a data access.
There is currently no technology smart enough to infer the right fetching strategy.
If someone builds it, this won't be a problem anymore.
If you know about it, please tell the world !