开发者

Linq Count Group on List<List<string>>

I have a list of objects each with a child list of string. I am trying to get a count on unique strings in the child lists.

Example objects:

private class ForumUser
{
    public List<string> RegisteredForums { get; set; }
}

Pupulating the example

List<ForumUser> forumUsers = new List<ForumUser>
    {
        new ForumUser {RegisteredForums = {"Forum1", "Forum2"}},
        new ForumUser {RegisteredForums = {"Forum1", "Forum2", "Forum3"}},
        new ForumUser {RegisteredForums = {"Forum1", "Forum2", "Forum3", "Forum4"}},
        new ForumUser {RegisteredForums = {"Forum1", "Forum2", "Forum3", "Forum4", "Forum5"}}
    };

Expected output:

Dictionary<'distinct forum name', 'count of forum'> result

Dictionary<string, int> result = forumUsers.GroupBy(&lt;your cle开发者_开发百科verness here&gt;
Forum1, 4
Forum2, 4
Forum3, 3
Forum4, 2
Forum5, 1

thank you


forumUsers.SelectMany (x=> x.RegisteredForums ).GroupBy (x => x).ToDictionary (x =>x.Key,x=>x.Count())


forumUsers.SelectMany(f => f.RegisteredForums).GroupBy(s => s)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜