© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•17mo ago•
67 replies
v0fbu1vm

✅ Ef Core unexpected query behaviour

        var memberships = await db.OrganizationMembers.AsTracking()
            .Include(om => om.Organization)
            .Where(om => om.UserId == user.Id && om.InvitationStatus == InvitationStatus.Approved &&
                         om.Role > MemberRole.None)
            .ToListAsync(cancellationToken);
        var memberships = await db.OrganizationMembers.AsTracking()
            .Include(om => om.Organization)
            .Where(om => om.UserId == user.Id && om.InvitationStatus == InvitationStatus.Approved &&
                         om.Role > MemberRole.None)
            .ToListAsync(cancellationToken);

/// <summary>
///     Represents an enumeration of member roles.
/// </summary>
public enum MemberRole
{
    /// <summary>
    ///     Represents the None role.
    /// </summary>
    None,

    /// <summary>
    ///     Represents the Read role.
    /// </summary>
    Read,

    /// <summary>
    ///     Represents the Write role.
    /// </summary>
    Write,

    /// <summary>
    ///     Represents the Administrator role.
    /// </summary>
    Admin
}
/// <summary>
///     Represents an enumeration of member roles.
/// </summary>
public enum MemberRole
{
    /// <summary>
    ///     Represents the None role.
    /// </summary>
    None,

    /// <summary>
    ///     Represents the Read role.
    /// </summary>
    Read,

    /// <summary>
    ///     Represents the Write role.
    /// </summary>
    Write,

    /// <summary>
    ///     Represents the Administrator role.
    /// </summary>
    Admin
}

For some reason it's not including
MemberRole.admin
MemberRole.admin
. It's including
MemberRole.Write
MemberRole.Write
?
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
Next page

Similar Threads

✅ Ef-core query efficiency?
C#CC# / help
15mo 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