EF Core 6 LINQ查询报错：QueryBody需以Select或Group子句结尾

错误根源 #

你混合使用了LINQ的查询语法（from...in）和方法语法（.Where()/.Skip()等），且写法不符合规则。查询语法要求from之后的查询体必须以select或group结尾，但你直接在from的数据源后面链式调用方法语法，导致IntelliSense无法正确解析结构，误以为查询体未完成，从而抛出错误。

修复方案：改用纯方法语法 #

移除开头的查询语法部分，全部使用方法语法链式调用，IntelliSense错误会立即消失，代码逻辑保持不变：

var data = ctx.CommitteeMemberships.Include(ct => ct.Term)
    .Where(cm =>
        cm.PartitionKey == controllerStateManager.PartitionKey &&
        cm.CommitteeId == committeeId &&
        (
            (
                (cm.StartDate != null ? cm.StartDate >= effectiveDateStart : cm.Term != null && cm.Term.StartDate >= effectiveDateStart) &&
                (cm.StartDate != null ? cm.StartDate <= effectiveDateEnd : cm.Term != null && cm.Term.StartDate <= effectiveDateEnd)
            )
            ||
            (
                (cm.EndDate != null ? effectiveDateStart >= cm.EndDate : cm.Term != null && cm.Term.EndDate >= effectiveDateStart) &&
                (cm.EndDate != null ? cm.EndDate <= effectiveDateEnd : cm.Term != null && cm.Term.EndDate <= effectiveDateEnd)
            )
            ||
            (
                effectiveDateStart >= (cm.StartDate != null ? cm.StartDate : cm.Term != null ? cm.Term.StartDate : cm.StartDate) &&
                effectiveDateStart <= (cm.EndDate != null ? cm.EndDate : cm.Term != null ? cm.Term.EndDate : cm.EndDate)
            )
            ||
            (
                effectiveDateEnd >= (cm.StartDate != null ? cm.StartDate : cm.Term != null ? cm.Term.StartDate : cm.StartDate) &&
                effectiveDateEnd <= (cm.EndDate != null ? cm.EndDate : cm.Term != null ? cm.Term.EndDate : cm.EndDate)
            )
        )
    )
    .Skip((pageFilter.PageNumber - 1) * pageFilter.PageSize)
    .Take(pageFilter.PageSize)
    .Select(cm => new CommitteeMembershipDto
    {
        Row = cm.Row,
        Id = cm.Id,
        PartitionKey = cm.PartitionKey,
        Name = cm.Name,
        Type = cm.Type,
        CommitteeId = cm.CommitteeId,
        MemberId = cm.MemberId,
        TermId = cm.TermId,
        PositionId = cm.PositionId,
        StartDate = cm.StartDate,
        EndDate = cm.EndDate,
        Notes = cm.Notes,
        Keywords = cm.Keywords,
        SecurityLock = cm.SecurityLock,
        LockedForDeletion = cm.LockedForDeletion,
        IsConfiguration = cm.IsConfiguration,
        IsSealed = cm.IsSealed,
        LastModifiedById = cm.LastModifiedById,
        LastModifiedDate = cm.LastModifiedDate,
        CreatedById = cm.CreatedById,
        CreatedDate = cm.CreatedDate,
        SystemTimestamp = cm.SystemTimestamp,
        GrantPortalAdministratorPrivileges = cm.GrantPortalAdministratorPrivileges,
        CreatedByName = cm.CreatedByName,
        LastModifiedByName = cm.LastModifiedByName,
        EffectiveStartDate = cm.Term != null ? cm.Term.StartDate : (cm.StartDate != null) ? cm.StartDate : new DateTime(1900, 1, 1),
        EffectiveEndDate = cm.Term != null ? cm.Term.EndDate : (cm.EndDate != null) ? cm.EndDate : new DateTime(9999, 1, 1)
    });

额外优化建议（可选） #

你代码中的日期判断逻辑重复度很高，可以抽成局部函数简化代码，提升可读性：

bool DateOverlaps(DateTime? start, DateTime? termStart, DateTime? end, DateTime? termEnd, DateTime rangeStart, DateTime rangeEnd)
{
    var effectiveStart = start ?? termStart ?? new DateTime(1900,1,1);
    var effectiveEnd = end ?? termEnd ?? new DateTime(9999,1,1);
    return (effectiveStart >= rangeStart && effectiveStart <= rangeEnd) 
        || (effectiveEnd >= rangeStart && effectiveEnd <= rangeEnd)
        || (rangeStart >= effectiveStart && rangeStart <= effectiveEnd)
        || (rangeEnd >= effectiveStart && rangeEnd <= effectiveEnd);
}

var data = ctx.CommitteeMemberships.Include(ct => ct.Term)
    .Where(cm =>
        cm.PartitionKey == controllerStateManager.PartitionKey &&
        cm.CommitteeId == committeeId &&
        DateOverlaps(cm.StartDate, cm.Term?.StartDate, cm.EndDate, cm.Term?.EndDate, effectiveDateStart, effectiveDateEnd)
    )
    .Skip((pageFilter.PageNumber - 1) * pageFilter.PageSize)
    .Take(pageFilter.PageSize)
    .Select(cm => new CommitteeMembershipDto
    {
        // 保持原有Dto赋值逻辑
        EffectiveStartDate = cm.Term?.StartDate ?? cm.StartDate ?? new DateTime(1900, 1, 1),
        EffectiveEndDate = cm.Term?.EndDate ?? cm.EndDate ?? new DateTime(9999, 1, 1)
    });

内容的提问来源于stack exchange，提问作者Ronald Herhuth