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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.