ef导航属性

最新推荐文章于 2025-03-06 15:35:29 发布

weixin_30747253

最新推荐文章于 2025-03-06 15:35:29 发布

阅读量106

点赞数

原文链接：http://www.cnblogs.com/wcLT/p/4730691.html

版权

https://msdn.microsoft.com/en-us/data/jj574232.aspx

场景是 A表中有B，B表中又C。都是一堆多的关系。怎样Mapping是个问题啊。

var blogs1 = context.Blogs
                       .Include(b => b.Posts.Select(p => p.Comments))
                       .ToList();

// Load all blogs, all related posts, and all related comments
    var blogs1 = context.Blogs
                       .Include(b => b.Posts.Select(p => p.Comments))
                       .ToList();

    // Load all users their related profiles, and related avatar
    var users1 = context.Users
                        .Include(u => u.Profile.Avatar)
                        .ToList();

    // Load all blogs, all related posts, and all related comments
    // using a string to specify the relationships
    var blogs2 = context.Blogs
                       .Include("Posts.Comments")
                       .ToList();

    // Load all users their related profiles, and related avatar
    // using a string to specify the relationships
    var users2 = context.Users
                        .Include("Profile.Avatar")
                        .ToList();

returnValue=context.Assessments.Where(item=>item.State== AssessmentType.Used).Include(item=>item.QuestionList.Select(p=>p.Options)).ToList();

转载于:https://www.cnblogs.com/wcLT/p/4730691.html