自连接及其中嵌子查询

最新推荐文章于 2022-11-01 18:38:28 发布

longer123123

最新推荐文章于 2022-11-01 18:38:28 发布

阅读量682

点赞数

分类专栏： linq To Sql数据操作文章标签： equals join

本文链接：https://blog.csdn.net/longer123123/article/details/4014691

版权

linq To Sql数据操作专栏收录该内容

6 篇文章 0 订阅

订阅专栏

//自连接查询角色信息及其父角色
            var result = from r1 in eDataContext.Role
                         join r2 in eDataContext.Role on r1.ParentRoleID equals r2.RoleID
                         where r1.IsDeleted == false
                         select new { RoleID = r1.RoleID, ParentRoleID = r1.ParentRoleID, RoleName = r1.RoleName, RoleDesc = r1.RoleDesc, ParentRoleName = r2.RoleName };

//联合查询（自连接中嵌子查询）没授过该角色的角色信息及其父角色
            var result = from r1 in eDataContext.Role
                         join r2 in eDataContext.Role on r1.ParentRoleID equals r2.RoleID
                         where !(from o in eDataContext.SecondaryRole select o.RoleID).Contains(r1.RoleID)
                         && r1.IsDeleted == false
                         select new { RoleID = r1.RoleID, ParentRoleID = r1.ParentRoleID, RoleName = r1.RoleName, RoleDesc = r1.RoleDesc, ParentRoleName = r2.RoleName };