What is Linq to SQL Deferred Loading?
(C#) -Deferred Loading is a property of Linq to sql, by default it is set true,
Example: Let’s have two tables -
Blogs Table (BlogID ,Blog Name,owner) and Post table ( PostID, BlogID, Title, Body)
To find Name and No’s of posts in each blog-
BlogDataContext ctx = new BlogDataContext( );
var query = from b in ctx.Blogs select b;
foreach (Blog b in query)
{
Console.WriteLine("{0} has {1} posts", b.BlogName, b.Posts.Count);
}
Output of queries Produce Blog name with no’s of post, But For each Blog
Looping will be occurs (in case long list of blogs) that’s reduces Overall Performance that’s called the Deferred loading.
