search

dotnet / EntityFramework.Docs

Documentation for Entity Framework Core and Entity Framework 6
https://docs.microsoft.com/ef/
Creative Commons Attribution 4.0 International
1.58k stars 1.94k forks source link

Document full impact of UseCompatibilityLevel #4663

Open clement911 opened 3 months ago

clement911 commented 3 months ago

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.

roji commented 3 months ago

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).