OracleSQLCompatibility with EF Core 8

OracleSQLCompatibility with EF Core 8


I am working on an application that uses the Devart.Data.Oracle.EFCore nuget package to read data from an Oracle data base.

I want to update the application to EFCore 8 but I have a problem with Contains in LINQ queries when I use
a older Oracle database.

I have already discovered that Oracle have an extension Method to configure EF Core for older DB versions.

  1. optionsBuilder.UseOracle("User Id=hr;Password=<password>;Data Source = inst1", b =>b.UseOracleSQLCompatibility(OracleSQLCompatibility.DatabaseVersion19));
I havenĀ“t found a way to achieve this with Devart yet and keep the support for older Oracle versions.
Do you have any suggestions what I could do to resolve this issue?

Thanks and best regards,