© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•15mo ago•
26 replies
v0fbu1vm

✅ Ef-core query efficiency?

I have a question regarding querying data. Which one is more efficient since I only need the department ids. The first one
    private async Task<OrganizationMemberDTO?> RetrieveMemberAsync(CancellationToken ct)
    {
        return await db.OrganizationMembers
            .AsNoTracking()
            .Where(e => e.Id == MemberId && e.OrganizationId == OrganizationId)
            .Select(e => new OrganizationMemberDTO
            {
                Id = e.Id,
                Position = e.Position,
                Departments = e.Departments.Select(d => d.DepartmentId)
            }).FirstOrDefaultAsync(ct);
    }
    private async Task<OrganizationMemberDTO?> RetrieveMemberAsync(CancellationToken ct)
    {
        return await db.OrganizationMembers
            .AsNoTracking()
            .Where(e => e.Id == MemberId && e.OrganizationId == OrganizationId)
            .Select(e => new OrganizationMemberDTO
            {
                Id = e.Id,
                Position = e.Position,
                Departments = e.Departments.Select(d => d.DepartmentId)
            }).FirstOrDefaultAsync(ct);
    }
or second one
    private async Task<OrganizationMember?> RetrieveMemberAsync(CancellationToken ct)
    {
        return await db.OrganizationMembers
            .AsNoTracking()
            .Include(e => e.Departments)
            .FirstOrDefaultAsync(e => e.Id == MemberId && e.OrganizationId == OrganizationId, ct);
    }
    private async Task<OrganizationMember?> RetrieveMemberAsync(CancellationToken ct)
    {
        return await db.OrganizationMembers
            .AsNoTracking()
            .Include(e => e.Departments)
            .FirstOrDefaultAsync(e => e.Id == MemberId && e.OrganizationId == OrganizationId, ct);
    }
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

✅ Ef Core unexpected query behaviour
C#CC# / help
17mo ago
✅ EF Core Query Filter Exception
C#CC# / help
3y ago
EF Core Global Query Filter Exception
C#CC# / help
4y ago
EF Core
C#CC# / help
2y ago