We have an issue with Json support when using EF 6.0.1 and Contains (translated to Like) in our query.
EF query
Code: Select all
query.Where(p => p.Json.Contains(text).First()
Code: Select all
... ("Filter1"."Json" LIKE :p__linq__4 ESCAPE '/') ...
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 '/') ...