Devart Forums

Posted: **Wed 19 Mar 2014 13:50**

Hi,

We have an issue with Json support when using EF 6.0.1 and Contains (translated to Like) in our query.

EF query

query.Where(p => p.Json.Contains(text).First()

EF Output:

Code: Select all

... ("Filter1"."Json" LIKE :p__linq__4 ESCAPE '/') ...

Error that we get:
operator does not exist: json ~~ text

I think that in case of Contains/Like you should cast the Json field to text if possible e.g.

Code: Select all

... ("Filter1"."Json"::text LIKE :p__linq__4 ESCAPE '/') ...

Regards

Posted: **Thu 20 Mar 2014 09:13**

Thank you for the report on this. We have reproduced this issue. We will investigate it and inform you about the results as soon as possible.

Posted: **Fri 28 Mar 2014 06:29**

The use of the JSON data type in string canonical functions and comparison operators (equality and inequality) is supported.
New build of dotConnect for PostgreSQL 7.3.125 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=29241.

Devart Forums

Entity Framework & JSON support

Entity Framework & JSON support

Re: Entity Framework & JSON support

Re: Entity Framework & JSON support