✅ 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.adminMemberRole.admin. It's including MemberRole.WriteMemberRole.Write?