Lambda表达式去重

最新推荐文章于 2024-02-27 11:41:37 发布

liuhaixin995710690

最新推荐文章于 2024-02-27 11:41:37 发布

阅读量3.4k

点赞数 1

CC 4.0 BY-SA版权

文章标签：代替Distinct

本文链接：https://blog.youkuaiyun.com/liuhaixin995710690/article/details/90171928

        string sql = $@"SELECT g.GroupID, g.GroupName,ge.EmployeeId,e.employeename FROM dbo.tab_UserGroup g
                                LEFT JOIN dbo.tab_GroupEmployee ge ON g.GroupId = ge.GroupID
                                LEFT JOIN dbo.tabEmployee e ON ge.EmployeeId = e.employeeid
                                WHERE g.EmployeeId = '{user.data.employeeid}'";

        var result = db.SqlQueryable<GroupInfo>(sql).ToList();


        var items = result.Where((x, i) => result.FindIndex(z => z.GroupID == x.GroupID) == i).ToList();//Lambda表达式去重