In addition to needing to order, I needed to limit the results of the children. I did it like this:
var transactions = await _context.Transaction .Include(x => x.User) .OrderByDescending(x => x.CreatedAt) .Where(x => x.User.Id == _tenantInfo.UserId) .Take(10) .ToListAsync(); var viewmodel = _mapper.Map<UserViewModel>(transactions.First().User); Hope this helps!