15.9. Using Fetch Plans and Fetch Groups

When you create your data model, by default, it's configured to use lazy loading. Lazy loading is a data loading technique that works by loading only the information that is needed at any precise moment. This works well most of the time, but when loading data from different tables, it queries all the tables independently whenever is needed. This fact can lead to excessive round trips to the database server, which can saturate the network and eventually reduce performance.

To solve this problem, Telerik OpenAccess ORM uses fetch plans and fetch groups. The idea is to instruct OpenAccess on what fields it must load, and it will build the right SQL queries to minimize the impact of query execution. This ...

Get Pro Telerik ASP.NET and Silverlight Controls: Master Telerik Controls for Advanced ASP.NET and Silverlight Projects now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.