Open mcpgza opened 3 days ago
That's not a bug - it's a limitation that's by-design. Such complex LINQ querying over an array are implemented by sending the data as a JSON array, and using SQL Server's OPENJSON function to parse it and apply the operators to it. But OPENJSON isn't available with compatibility level 120.
Exception in the following case
Using compatibility level 120 (to avoid JSON arrays), the following query throws exception:
Exception
EF Core version: 8.0.6 Database provider: Microsoft.EntityFrameworkCore.SqlServer Target framework: .NET 8.0 Operating system: Win 11 professional IDE: Visual Studio 2022 17.4