What is Linq to SQL Deferred Loading?
Submitted by: Administrator(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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online LINQ Job Interview Questions And Answers
Top LINQ Questions
☺ | What is LINQ? |
☺ | What is a Lambda expression? |
☺ | What is the extension of the file, when LINQ to SQL is used? |
☺ | What is the LINQ file extension that interacts with Code Behind objects. |
☺ | How LINQ is beneficial than Stored Procedures? |
Top Application Program Categories
☺ | AutoCAD Interview Questions. |
☺ | Microsoft Office Interview Questions. |
☺ | Microsoft Outlook Interview Questions. |
☺ | Microsoft Excel Interview Questions. |
☺ | WPF Interview Questions. |