"ORA-00936: missing expression" error when using latest Oracle.EntityFrameworkCore 9.23.60 and .net 9.0.1

[tegrit-joe-trupiano]

Does not work on.
Oracle.EntityFrameworkCore 9.23.60
.NET 9.0.1

Worked on.
Oracle.EntityFrameworkCore 8.23.60
.NET 8.0.11

This query worked before moving to latest Oracle.ManagedDataAccess.Client and .net9.

Query in question from Debug view

Code used the generate query

Trace files set to TraceLevel = 7

APPLICATION.EXE_PID_32892_DATE_2025_01_23_TIME_14_16_44_560915.txt

[alexkeh]

Can you share the SQL generated during the Oracle EF Core 8.23.60 run?

What is the difference between the two SELECT statements in Oracle EF Core 9 and 8?

[tegrit-joe-trupiano]

Can you share the SQL generated during the Oracle EF Core 8.23.60 run?

What is the difference between the two SELECT statements in Oracle EF Core 9 and 8?

Before .net 9

After .net 9

[alexkeh]

I filed bug 37518067 to have the Oracle EF Core dev team look into this issue.

[jomaxso]

We encountered the same issue after updating to Oracle.EntityFrameworkCore version 9.23.60.

[alexkeh]

@tegrit-joe-trupiano and @jomaxso, Could either of you provide a console application with EF model classes and model configuration that reproduces the issue? You can upload the code to this thread or email it to dotnet_us(at)oracle.com.

Thanks!

[tegrit-joe-trupiano]

@tegrit-joe-trupiano and @jomaxso, Could either of you provide a console application with EF model classes and model configuration that reproduces the issue? You can upload the code to this thread or email it to dotnet_us(at)oracle.com.

Thanks!

Full example - run the app and the console will output the problem query.
ConsoleApp1.zip