I've posted a link to an interesting article by Rick Strahl that explains times when LinqToSql’s native behavior of “Lazy Loading” is not a good thing (from a database performance standpoint), and explains a pre-fetching technique that you can can use when you want to avoid lazy loading hits to SQL Server.


http://therealmattslay.blogspot.com/2009/10/linq-to-sql-lazy-loading-and.html

.