Daniel Auger (9/4/2009)
Here is a good description of N + 1:http://nhprof.com/Learn/Alert?name=SelectNPlusOne
EDIT: I will add that Select N + 1 is not a problem that directly stems from using an ORM framework. It stems from lazy loading (usually), so most hand rolled DALs are prone to this issue as well.
Excellent. Thank you very much.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning