Breaking Changes

Application Programming Interface Changes

• Oracle EF Core UseOracleSQLCompatibility extension method

  In EF Core 6 and higher versions with Oracle EF Core version 23, UseOracleSQLCompatibility extension method now takes an enumeration type as an argument rather than a string value. This extension method's default value will be the same as the Oracle EF Core version. For example, if you are using Oracle EF Core 23, then its value will be OracleSQLCompatibility.DatabaseVersion23.

  This default assumes the app is using the same database version as the Oracle EF Core version, that is, Oracle Database 23ai with Oracle 23ai client. If they are not the same version, then the developer should modify the enumeration value to match the database version they are connecting to. This ensures fewer compatibility errors and allows Oracle EF Core to use the latest Oracle Database features.

  See Also:

  UseOracleSQLCompatibility(enum version)

Desupported APIs

The desupported APIs are as follows:

• ModelBuilder.UseOracleIdentityColumn Extension Method

  Starting with EF Core 5, ODP.NET EF Core desupports UseOracleIdentityColumn. Developers should call the ModelBuilder.UseIdentityColumn extension method instead, which provides identical functionality. UseOracleIdentityColumn remains supported for EF Core 3.1 and earlier releases.

• ModelBuilder and PropertyBuilder ForOracleUseSequenceHiLo Extension Method

  Starting with EF Core 5, ODP.NET EF Core desupports ForOracleUseSequenceHiLo. Developers should call the ModelBuilder.UseHiLo extension method instead, which provides identical functionality. ForOracleUseSequenceHiLo remains supported for EF Core 3.1 and earlier releases.

• Oracle.EntityFrameworkCore.Migrations.Operations.OracleCreateUserOperation Class

  Starting with Oracle EF Core 21c, the OracleCreateUserOperation class is desupported. Developers should call the MigrationBuilder.Sql method instead with a CREATE USER SQL statement to create a user if they are using the desupported API directly.

• Oracle.EntityFrameworkCore.Migrations.Operations.OracleDropUserOperation Class

  Starting with Oracle EF Core 21c, the OracleDropUserOperation class is desupported. Developers should call the MigrationBuilder.Sql method instead with a DROP USER SQL statement to drop a user if they are using the desupported API directly.