LINQ 查询到字典

本文关键字：字典查询 LINQ | 更新日期: 2023-09-27 18:36:16

>我正在尝试将下面的 LINQ 查询结果转换为字典

var browser = (from tbf in context.tblFeedBacks
                        where tbf.email == dboard.userEmail
                        select tbf).GroupBy(l => l.browser)
                        .Select(g => new
                        {
                            browser = g.Key,
                            count = g.Select(l => l.browser).Distinct().Count()
                        });

它给了我一个编译错误。

var browser = (from tbf in context.tblFeedBacks
                            where tbf.email == dboard.userEmail
                            select tbf).GroupBy(l => l.browser)
                            .Select(g => new
                            {
                                browser = g.Key,
                                count = g.Select(l => l.browser).Distinct().Count()
                            }).ToDictionary<string, double>(x => x.browser,y=>y.count);

实例参数：无法从 'System.Linq.IQueryable' to 'System.Linq.ParallelQuery'

LINQ 查询到字典

让它工作了。

var browser = (from tbf in context.tblFeedBacks
                            where tbf.email == dboard.userEmail
                            select tbf).GroupBy(l => l.browser)
                            .Select(g => new
                            {
                                browser = g.Key,
                                count = g.Select(l => l.browser).Count()
                            }).ToDictionary(x => x.browser, x => x.count);