© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•2y ago•
10 replies
SWEETPONY

System.InvalidOperationException: The LINQ expression 'DbSet<WorkingTask>() .Where(w => new Work

I have following code:
[UsePaging]
    [UseProjection]
    [UseFiltering]
    [UseSorting]
    [Authorize(Roles = [Permissions.Rms.Task.Read])]
    public IQueryable<WorkingTask> WorkingTasks([Service(ServiceKind.Resolver)] ReadModelDbContext dbContext, IResolverContext context, [Service] NpgsqlHealthChecker npgsqlHealthChecker)
    {
        var workingTasks = dbContext.WorkingTasks
            .AsQueryable()
            .Project(context)
            .Filter(context)
            .Sort(context)
            .ToList(); // Force client-side evaluation

        return workingTasks.AsQueryable();
    }
[UsePaging]
    [UseProjection]
    [UseFiltering]
    [UseSorting]
    [Authorize(Roles = [Permissions.Rms.Task.Read])]
    public IQueryable<WorkingTask> WorkingTasks([Service(ServiceKind.Resolver)] ReadModelDbContext dbContext, IResolverContext context, [Service] NpgsqlHealthChecker npgsqlHealthChecker)
    {
        var workingTasks = dbContext.WorkingTasks
            .AsQueryable()
            .Project(context)
            .Filter(context)
            .Sort(context)
            .ToList(); // Force client-side evaluation

        return workingTasks.AsQueryable();
    }


I don't know why but I always get error after
.Sort(context).ToList();
.Sort(context).ToList();
. how to fix this?
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

✅ System.InvalidOperationException: The LINQ expression
C#CC# / help
2y ago
❔ System.Linq.Expressions custom expression
C#CC# / help
3y ago
Await Linq Expression
C#CC# / help
4y ago
LINQ Lambda-Expression Diff
C#CC# / help
4y ago