我创建了以下的存储过程：
PROCEDURE [dbo].[LeadScoring_CountClosedActions]
(@UserId INT,
 @StartDate INT,
 @EndDate INT)
AS
BEGIN
    SET NOCOUNT ON
    SELECT TOP 1 
        COUNT(l.Extra) OVER () AS TotalRecords
	FROM 
        [dbo].[LeadScoringActions] AS a
	INNER JOIN 
        [dbo].[LeadScoringLeads] AS l ON a.LeadId = l.LeadId
    WHERE 
        a.AssignedToUserId = @UserId 
    	AND a.DateCompleted > DATEADD(DAY, @StartDate, GETDATE())
    	AND a.DateCompleted <= DATEADD(DAY, @EndDate, GETDATE())
    	AND a.ActionResultType != 'System Closed'
    	AND l.Extra IS NOT NULL
    GROUP BY 
        l.Extra
END
而我尝试使用以下的EF Core代码来执行它：
var count = await _context.Database.ExecuteSqlRawAsync($"exec LeadScoring_CountClosedActions @UserId={userId}, @StartDate={request.StartDate}, @EndDate={request.EndDate}");
但它总是返回-1，所以我看了一下，似乎我应该将存储过程转换为Linq（参见[此问题的一条评论](https://stackoverflow.com/questions/70822830/ef-6-core-exec-proc-stock-with-count-returning-int)）。
我想知道如何做到这一点 - 我知道如何做一般的部分：
var count = await _context
                    .Actions
                    .Include(a => a.Lead)
                    .CountAsync(a => a.ActionResultType != LeadScoringConstants.SystemClosed &&
                                     a.DateCompleted > DateTime.Today.AddDays(request.StartDate) &&
                                     a.DateCompleted <= DateTime.Today.AddDays(request.EndDate) &&
                                     a.AssignedToUserId == userId &&
                                     a.Lead.Extra != null);
但我不确定如何做`GROUP BY`部分 - 在Linq中，它将按`a.Lead.Extra`进行分组，或者是否可以执行`COUNT OVER`？
是将其作为Linq更好，还是有一种执行存储过程并获取正确结果的方法？

var actions = await _context
    .Actions
    .Include(a => a.Lead)
    .Where(a =>
        a.ActionResultType != LeadScoringConstants.SystemClosed &&
        a.DateCompleted > DateTime.Today.AddDays(request.StartDate) &&
        a.DateCompleted <= DateTime.Today.AddDays(request.EndDate) &&
        a.AssignedToUserId == userId &&
        a.Lead.Extra != null)
    .ToListAsync();
var projectIds = actions.Select(a => a.Lead.Extra).Distinct().Count();

var count = await _context
    .Actions
    .Where(a =>
        a.ActionResultType != LeadScoringConstants.SystemClosed &&
        a.DateCompleted > DateTime.Today.AddDays(request.StartDate) &&
        a.DateCompleted <= DateTime.Today.AddDays(request.EndDate) &&
        a.AssignedToUserId == userId &&
        a.Lead.Extra != null)
    .Select(a => new { a.Lead.Extra, a.DateCompleted })
    .Distinct()
    .CountAsync();