c# - asp.net core 中的文档总数

Question

我有一个文档表，这是我的查询，如何对我现在在 sql 中拥有的文档进行求和，并通过 linq 在 asp.net core 3.1 中显示在 viewmodel 中

public async Task<PagedResult<DocumentsVm>> GetTotal(GetDocumentsPagingRequest request)
    {
        var query = from d in _context.Documents //This is my query
                    join u in _context.Users on d.UserID equals u.Id
                    select new { d, u };
        int TotalRow = await query.CountAsync();
        var data = await query.Skip((request.PageIndex - 1) * request.PageSize)
            .Take(request.PageSize)
            .Select(x => new DocumentsVm()
            {
                ID = x.d.ID,
                Caption = x.d.Caption,
                FacultyID = x.d.FacultyOfDocumentID,
                Status = x.d.Status,
                CreateOn = x.d.CreateOn.Date,
                ViewCount = ??? //I want to display total document here
            }).ToListAsync();
        var pagedResult = new PagedResult<DocumentsVm>()
        {
            TotalRecord = TotalRow,
            Items = data
        };
        return pagedResult;
    }

标签： c#asp.netasp.net-mvclinqasp.net-core