© 2026 Hedgehog Software, LLC

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

✅ How to get all data without Include?

maybe stupid question but I want to ask it:

I have two methods:
[UseProjection]
[Authorize(Roles = [Permissions.Rms.Task.Read])]
public Task<WorkingTaskWithFlights?> SingleWorkingTaskWithFlightAsync([Service(ServiceKind.Resolver)] ReadModelDbContext dbContext, IResolverContext context, string identity, [Service] NpgsqlHealthChecker npgsqlHealthChecker, CancellationToken cancellationToken)
    => HealthCheck(npgsqlHealthChecker, async () =>
    {
        var workingTask = await dbContext.WorkingTasks
            .Include(workingTask => workingTask.RequiredQualifications)
                .ThenInclude(workingTask => workingTask.Qualification)
            .Include(workingTask => workingTask.StartLocation)
            .Include(workingTask => workingTask.EndLocation)
            .Include(workingTask => workingTask.WorkingShift)
            .FirstOrDefaultAsync(workingTask => workingTask.Identity == identity, cancellationToken)
            .ConfigureAwait(false);

        if(workingTask == null)
            return default;

        var inboundIdentity = workingTask.CustomData?.InboundFlightLegIdentity;
        var outboundIdentity = workingTask.CustomData?.OutboundFlightLegIdentity;

        var flights = await dbContext.Flights
            .Where(flight => flight.Identity == inboundIdentity || flight.Identity == outboundIdentity)
            .ToListAsync(cancellationToken)
            .ConfigureAwait(false);

        return new WorkingTaskWithFlights { WorkingTask = workingTask, Flights = flights.AsReadOnly()};
    });

[UseProjection]
[Authorize(Roles = [Permissions.Rms.Task.Read])]
public Task<WorkingTaskEntity?> SingleWorkingTaskAsync([Service(ServiceKind.Resolver)] ReadModelDbContext dbContext, IResolverContext context, string identity, [Service] NpgsqlHealthChecker npgsqlHealthChecker, CancellationToken cancellationToken)
    => GetByIdentityAsync(dbContext.WorkingTasks, identity, w => w.Project(context), npgsqlHealthChecker, cancellationToken);
[UseProjection]
[Authorize(Roles = [Permissions.Rms.Task.Read])]
public Task<WorkingTaskWithFlights?> SingleWorkingTaskWithFlightAsync([Service(ServiceKind.Resolver)] ReadModelDbContext dbContext, IResolverContext context, string identity, [Service] NpgsqlHealthChecker npgsqlHealthChecker, CancellationToken cancellationToken)
    => HealthCheck(npgsqlHealthChecker, async () =>
    {
        var workingTask = await dbContext.WorkingTasks
            .Include(workingTask => workingTask.RequiredQualifications)
                .ThenInclude(workingTask => workingTask.Qualification)
            .Include(workingTask => workingTask.StartLocation)
            .Include(workingTask => workingTask.EndLocation)
            .Include(workingTask => workingTask.WorkingShift)
            .FirstOrDefaultAsync(workingTask => workingTask.Identity == identity, cancellationToken)
            .ConfigureAwait(false);

        if(workingTask == null)
            return default;

        var inboundIdentity = workingTask.CustomData?.InboundFlightLegIdentity;
        var outboundIdentity = workingTask.CustomData?.OutboundFlightLegIdentity;

        var flights = await dbContext.Flights
            .Where(flight => flight.Identity == inboundIdentity || flight.Identity == outboundIdentity)
            .ToListAsync(cancellationToken)
            .ConfigureAwait(false);

        return new WorkingTaskWithFlights { WorkingTask = workingTask, Flights = flights.AsReadOnly()};
    });

[UseProjection]
[Authorize(Roles = [Permissions.Rms.Task.Read])]
public Task<WorkingTaskEntity?> SingleWorkingTaskAsync([Service(ServiceKind.Resolver)] ReadModelDbContext dbContext, IResolverContext context, string identity, [Service] NpgsqlHealthChecker npgsqlHealthChecker, CancellationToken cancellationToken)
    => GetByIdentityAsync(dbContext.WorkingTasks, identity, w => w.Project(context), npgsqlHealthChecker, cancellationToken);
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

✅ How to get data from entity without includes?
C#CC# / help
4mo ago
❔ Include several include within get method
C#CC# / help
4y ago
❔ How to Select Data with Included nested objects?
C#CC# / help
4y ago
❔ How to get all children of parent node?
C#CC# / help
3y ago