C Sharp - Linq - Mixing And and Or

Here is a sample LINQ statement

var dbEntity = await _dbContext.Notes
    .Where(n => n.CompanyKey == companyKey &&
                n.ApplicationKey == applicationKey &&
                (applicationSubKey == "All" || n.ApplicationSubKey == applicationSubKey) &&
                (recordKey == "All" || n.RecordKey == recordKey))
    .Include(n => n.NoteTypeEntity)
    .ToListAsync();

The vertical bars || represent “or”, the ampersands “&&” represent “and”.

So I’m looking for records in a certain company key, and a certain application key, and a certain “application sub key” , and a certain “record key”.

If they provide a value of All to Application subkey then this effectively removes the Application SubKey from the where clause. Same with RecordKey.

Note in many languages the OR and the AND have precidece. In C# the AND has precidece over the OR.