OrderBy operator on query

[gkama]

There is a missing OrderBy that makes Entity Framework throw a warning log message when generating a JWT for a user.

This warning is appearing even though the following query is setup via LINQ:

public async Task<IUserRefreshToken> GetRefreshTokenAsync(int userId)
{
    return await GetRefreshTokensQuery()
        .Where(x => x.UserId == userId
            && x.Revoked == null)
        .OrderByDescending(x => x.Expires)
        .Take(1)
        .FirstOrDefaultAsync();
}

In this specific example, it essentially checks if there are any existing refresh tokens. If not (the call from this function is null), then create one. Else, return the token