EntityFramework.Docs icon indicating copy to clipboard operation
EntityFramework.Docs copied to clipboard
verified publisher icon dotnet

Document full impact of UseCompatibilityLevel

Open clement911 opened this issue 1 year ago • 1 comments

It would be great to have a doc page about the impact of using the various compatibility level on sql server with UseCompatibilityLevel.

We're considering using UseCompatibilityLevel to avoid the new Contains to OPENJSON translation. However, we can't figure out whether there will be other impacts.

clement911 avatar Feb 22 '24 23:02 clement911

In 8.0 it's really only the Contains/OPENJSON translation. For 9.0 we'll probably introduce a better mechanism for opting out of the OPENJSON translation for this case.

Regardless, I agree that we should probably include a note on the actual effects of UseCompatibilityLevel (moving to the docs repo).

roji avatar Feb 22 '24 23:02 roji