假设我在下图中有3个连接在一起的表.如何访问"UserReferralJoins"表查询中"Users"表中的"Email"字段?
有人能帮我吗?
var referalId = await _dbContext.UserReferrals.Where(x => x.UserId == CurrentUserId).Select(x => x.UserReferralId).FirstOrDefaultAsync();
var list = await _dbContext.UserReferralJoins
.Where(i => i.UserReferralId == referalId)
.Select(x => new
{
Id = x.UserReferralJoinId,
UserEmail = ???
x.JoinDate
}).ToListAsync(cancellationToken);