Unexpected SqlParameterExpression implementation when using Oracle spatial functions in EF Core 8

Unexpected SqlParameterExpression implementation when using Oracle spatial functions in EF Core 8

We are planning to upgrade EF Core 6 to EF Core 8 along with upgrade from .NET 6 to .NET 8. We frequently use Oracle spatial functions: "SDO_RELATE" and "SDO_WITHIN_DISTANCE", which unfortunately do not have built-in support in dotConnect for Oracle according to my question: https://support.devart.com/portal/en/community/topic/built-in-oracle-spatial-functions-for-ef-core
However we were able to implement that support ourselves using EF Core modelBuilder.HasDbFunction() method:
  1. [DbFunction("<namespace>", "SDO_RELATE")]
  2. public static string SdoRelate(Geometry geometry1, Geometry geometry2, string param)
  3. {
  4. throw NotSupportedOutsideLinq();
  5. }

  7. [DbFunction("<namespace>", "SDO_WITHIN_DISTANCE")]
  8. public static string SdoWithinDistance(Geometry geometry1, Geometry geometry2, string param)
  9. {
  10. throw NotSupportedOutsideLinq();
  11. }

  13. internal static void AddDbFunctions(ModelBuilder modelBuilder)
  14. {
  15. modelBuilder.HasDbFunction(typeof(OracleSpatialFunctions).GetMethod(
  16. nameof(OracleSpatialFunctions.SdoRelate), new[] { typeof(Geometry), typeof(Geometry), typeof(string) }))
  17. .HasName("SDO_RELATE");

  19. modelBuilder.HasDbFunction(typeof(OracleSpatialFunctions).GetMethod(
  20. nameof(OracleSpatialFunctions.SdoWithinDistance), new[] { typeof(Geometry), typeof(Geometry), typeof(string) }))
  21. .HasName("SDO_WITHIN_DISTANCE");
  22. }
and then later we can query database using such query:
  2. var query = await context.DATABASE_TABLE
  3. .Where(x =>
  4. OracleSpatialFunctions.SdoRelate(x.GEOMETRY, inputGeometry, "mask=ANYINTERACT") == "TRUE")
  5. .ToListAsync();
That way works nicely with EF Core 6 and 7 and older versions of dotConnect, but it fails with Devart.Data.Oracle.EFCore version 10.3.10.8 and EF Core 8. Has something changed in version 10.3.10.8 when it comes to handling geometries that causes that issue? Could you possibly fix it?

Here is an exception with the stacktrace:
  2. System.InvalidOperationException: Unexpected SqlParameterExpression implementation.
  3.     at Devart.Common.Entity.l.fe(String A_0, Type A_1, RelationalTypeMapping A_2)
  4.    at System.Data.Common.CommandTrees.a.a(SqlExpression A_0)
  5.    at System.Data.Common.CommandTrees.a.VisitSqlParameter(SqlParameterExpression sourceParameterExpression)
  6.    at Microsoft.EntityFrameworkCore.Query.SqlExpressionVisitor.VisitExtension(Expression extensionExpression)
  7.    at Devart.Common.Entity.y.VisitExtension(Expression extensionExpression)
  8.    at System.Data.Common.CommandTrees.a.a(s A_0)
  9.    at Devart.Common.Entity.y.b(s A_0)
  10.    at Devart.Common.Entity.w.Accept(ExpressionVisitor visitor)
  11.    at Devart.Common.Entity.y.h(SqlExpression A_0)
  12.    at Devart.Common.Entity.y.VisitSqlBinary(SqlBinaryExpression sqlBinaryExpression)
  13.    at System.Data.Common.CommandTrees.a.VisitSqlBinary(SqlBinaryExpression sqlBinaryExpression)
  14.    at Microsoft.EntityFrameworkCore.Query.SqlExpressionVisitor.VisitExtension(Expression extensionExpression)
  15.    at Devart.Common.Entity.y.VisitExtension(Expression extensionExpression)
  16.    at Devart.Common.Entity.y.h(SqlExpression A_0)
  17.    at Devart.Common.Entity.y.gb(SqlExpression A_0)
  18.    at Devart.Common.Entity.y.VisitSelect(SelectExpression selectExpression)
  19.    at System.Data.Common.CommandTrees.a.VisitSelect(SelectExpression selectExpression)
  20.    at System.Data.Common.CommandTrees.b.VisitSelect(SelectExpression source)
  21.    at Microsoft.EntityFrameworkCore.Query.SqlExpressionVisitor.VisitExtension(Expression extensionExpression)
  22.    at Devart.Common.Entity.y.VisitExtension(Expression extensionExpression)
  23.    at Microsoft.EntityFrameworkCore.Query.SqlExpressionVisitor.VisitExtension(Expression extensionExpression)
  24.    at Devart.Common.Entity.y.VisitExtension(Expression extensionExpression)
  25.    at Devart.Common.Entity.d0.Process(Expression query)
  26.    at Devart.Data.Oracle.Entity.i.Process(Expression query)
  27.    at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
  28.    at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](Expression query, Boolean async)
  29.    at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
  30.    at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass12_0`1.<ExecuteAsync>b__0()
  31.    at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
  32.    at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteAsync[TResult](Expression query, CancellationToken cancellationToken)
  33.    at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken)
  34.    at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.GetAsyncEnumerator(CancellationToken cancellationToken)
  35.    at System.Runtime.CompilerServices.ConfiguredCancelableAsyncEnumerable`1.GetAsyncEnumerator()
  36.    at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)