LINQ to SQL, Lazy Loading and Prefetching
Posted by: Rick Strahls WebLog,
on 12 Oct 2009 |
View original | Bookmarked: 0 time(s)
LINQ to SQL by default loads related entities and entity sets by using Lazy Loading. Which means if you retrieve a list of entities in a query that references other entities these other entities are not actually loaded unless you physically access them. Lazy loading is quite useful in some scenarios typically when you load up individual instances for display purposes in simple record based UIs, but it can be a real problem when displaying list based data that needs to have access to related data....