IGrouping几个要查看的组

Question

如何构造该查询所选择的ViewModels？

var result =
from company in repository.CompanyRepository.Get()
join account in repository.AccountRepository.Get() on company.Uid equals account.UserId
from notice in company.Notices
join request in
    repository.RequestRepository.Get() on
    notice.SubcategoryId equals request.Subcategoryid
group new {notice, request} by new {company, account}
into g
select new {g.Key, value = g};

我在玩不同类型的游戏，但我搞不懂。

IQueryable<IGrouping<IGrouping<Company, Account>, IGrouping<Notice, Request>>> testGroup;

Answer 1

因此，您可以调用ToList来执行它，并删除IGgrouping，也可以对select clause做一些修改，如

select new ViewModelClass{Company=g.Key.Company, Account=g.Key.Account, Notices=g.Select(n=>n.notice), Requests=g.Select(r=>r.request)}

像这样的viewModelClass

class ViewModelClass{
    public Company Company { get; set; };
    public Account Account { get; set; };
    public IEnumerable<Notice> Notices { get; set; };
    public IEnumerable<Request> Requests { get; set; };
}

可能您需要使用IQueryable而不是IEnumerable