Bug description. EF Core 8, only, but pending outcome of #36291.. When the ternary condition contains a == null check, the else branch doesn't eliminate null values in the else expression, resulting ...

Using the IF-EXISTS-UPDATE-ELSE-INSERT pattern in SQL can create deadlocks unless transacted and/or UPDLOCK'ed (or MERGE/HOLDOCK).This pattern in code is a race condition. A good example here of the ...