如何返回带有集合的对象，而不仅仅是来自Web API的集合

Question

目前，在我的控制器的服务方法GetSubAccounts(accountId)中，我有这样的：

Account account = await context.Accounts.SingleOrDefaultAsync(x => x.Id == accountId);
IQueryable<Account> subAccounts = context.Accounts.Include(x => x.AccountCodes).AsNoTracking();
return await mapper.ProjectTo<SubAccountViewModel>(subAccounts, null, x => x.SubAccounts)
.Where(x => x.PersonId == account.PersonId && x.AccountId != null).ToListAsync();

我的SubAccountViewModel如下：(注意它有一个自己的集合(

public class SubAccountViewModel : Base.AccountViewModel
{
public virtual ICollection<AccountCodeViewModel> AccountCodes { get; set; }
public virtual ICollection<SubAccountViewModel> SubAccounts { get; set; }
}

我的地图配置文件是：

internal class SubAccountMappingProfile : Profile
{
public SubAccountMappingProfile()
{
CreateMap<Account, SubAccountViewModel>()
.ForMember(x => x.AccountCodes, options => options.ExplicitExpansion())
.ForMember(x => x.SubAccounts, options => options.ExplicitExpansion())
.ReverseMap();
}
}

这就是我得到的JSON：

[
{
"id":"c236718f-9d91-4eea-91ee-66760a716343",
"personId":"06d3857d-6a49-4e1c-b63c-7edc83d30cbd",
"accountId":null,
"username":"test same person",
"email":"[e-mail]",
"birthDate":"2021-01-02",
"subaccounts":null
}
]

问题：

我正在为传递给该方法的accountId参数获取一个顶级子帐户数组。好的(只有一个，但别介意。(

我想要的是顶层的主账户，子账户阵列是其中的一部分。

即

{
"id":"f61fedc2-eb60-4ba9-9d17-8d41b9cae9f1",
"personId":"06d3857d-6a49-4e1c-b63c-7edc83d30cbd",
"accountId":"f61fedc2-eb60-4ba9-9d17-8d41b9cae9f1",
"username":"test person",
"email":"[e-mail]",
"birthDate":"2021-01-01",
"subaccounts":[
{
"id":"c236718f-9d91-4eea-91ee-66760a716343",
"personId":"06d3857d-6a49-4e1c-b63c-7edc83d30cbd",
"accountId":"f61fedc2-eb60-4ba9-9d17-8d41b9cae9f1",
"username":"test same person",
"email":"[e-mail]",
"birthDate":"2021-01-02",
"subaccounts":null
}
]
}

我该怎么做？

Answer 1

问题出在逻辑上。

首先，我的服务方法(和API控制器(返回Task<IEnumerable<SubAccountViewModel>>，而它应该返回Task<SubAccountViewModel>。

然后我的解决方案是：

Account account = await context.Accounts.SingleOrDefaultAsync(x => x.Id == accountId);

IQueryable<Account> accounts = context.Accounts.AsNoTracking();
SubAccountViewModel subAccountViewModel = await mapper.ProjectTo<SubAccountViewModel>(accounts, null, x => x.AccountCodes)
.SingleOrDefaultAsync(x => x.Id == accountId);
subAccountViewModel.SubAccounts = await mapper.ProjectTo<SubAccountViewModel>(accounts, null, x => x.AccountCodes, x => x.SubAccounts)
.Where(x => x.PersonId == account.PersonId && x.AccountId != null).ToListAsync();
return subAccountViewModel;

这将返回我想要的结果集。