EF Core LeftJoin 一对多查询

最新推荐文章于 2024-08-07 22:56:06 发布

小草_wang

最新推荐文章于 2024-08-07 22:56:06 发布

阅读量6.4k

点赞数 3

分类专栏： netcore 文章标签： ef core leftjoin 一对多结果直接生成对象

本文链接：https://blog.csdn.net/wulaihaoa/article/details/104060433

版权

netcore 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

var data = _dbContext.Users.Join(_dbContext.Roles, u => u.RoleId, r => r.Id, (u, r) => new {u, r})
                .Where(t => t.u.UserName == username && t.u.PassWord == password)
                .Where(t => t.u.UserSite.All(x => x.UserId == t.u.Id))
                .Where(t => t.r.RoleMenus.All(x => x.RoleId == t.r.Id))
                .Select(t => new UserDto()
                {
                    Id = t.u.Id,
                    UserName = t.u.UserName,
                    PassWord = t.u.PassWord,
                    RealName = t.u.RealName,
                    Phone = t.u.Phone,
                    RoleId = t.u.RoleId,
                    RoleName = t.r.RoleName,
                    LastIp = t.u.LastIp,
                    LastTime = t.u.LastTime,
                    Menus = t.r.RoleMenus.Select(x => (int) x.MenuId).ToList(),
                    Sites = t.u.UserSite.Select(x => x.SiteId).ToList()
                });

先死记个套路