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.
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.
No comments:
Post a Comment