Convert IGrouping to IQueryable in LINQ

Question

if (model.ConnectedToOtherProfilesId != 0)
{
      var fooGroup = fans.GroupBy(x => x.FanId)
                         .Where(x => x.Any(z => z.ProfileId == model.ConnectedToOtherProfilesId));

      var fooGroup2 = fooGroup.Where(grp => grp.Count() > 1);
}

What I need is to put the results from fooGroup2 [IQueryable<IGrouping<int,PF>] into fans which is IQueryiable<PF>

Something like this:

fans = fooGroup2;

Do you mean `fooGroup2.SelectMany(x => x);`, your question is not clear? — DavidG, Jun 28 '19 at 14:14

score 1 · Answer 1 · answered Jun 28 '19 at 14:16

1

You could use a SelectMany.

//IQueryable<PF>
var fooGroup2 = fooGroup.Where(grp => grp.Count() > 1)
                        .SelectMany(pf => pf);

answered Jun 28 '19 at 14:16

Stefan

17,448
11
60
79

Convert IGrouping to IQueryable in LINQ

1 Answers1