Language Integrated Query (LINQ) Question:
Download Job Interview Questions and Answers PDF
What is Linq to SQL Deferred Loading?
Answer:
(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.
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.
Download LINQ Interview Questions And Answers
PDF