Closed
Description
openedon Nov 25, 2020
Ask a question
We have in most of our tables a property bool Deleted (not nullable); and you guess in most of our queries we do Where(x => !x.Deleted).
No i notice that the query gets translated to Deleted <> 1 which is for sql different then Deleted == 0 making it for sql harder to use certain indexes. Are there any guidlines towards this?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment