Code: Select all
context.SomeEntities.Where(t => OracleJsonFunctions.Value(t.Json,"$.path").CompareTo("a") >0)
Code: Select all
SELECT ....
WHERE (JSON_VALUE("Extent1"."JSON",'$.path')) > TO_CLOB('a')
I think there is a logic in sql generation which tries to convert string types each other so comparison should be among same types (clob to clob) but in this case we are not trying to compare column itself but value returned from json_value function.
And some extra, Oracle's JSON_VALUE function has a syntax that can support different data types(number,date,timestamp like) with "RETURNING" clause. OracleJsonFunctions.Value should also support this kind of query generation.
My dotconnect version : 9.5.399.0