Anyone know how to use Distinct() with Group By? I tried the following with no luck..
var q = from i in MetaData.ProcessRoundIssueInstance
group i by i.GroupID into g
select new
{
Group = g.Key,
UniqueUsers = g.Select(x => x.UserID).Distinct().Count()
};
Thanks!