Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.Sign up
Expose PostgreSQL JSON operators #771
PostgreSQL supports a wide array of JSON operations. We may be able to translate at least some JSON operations in LINQ queries to PostgreSQL for backend processing - this would prevent the entire resultset from being pulled in to the client.
Explore the Newtonsoft.JSON API to see what can be done. We also probably don't want to take a dependency on Newtonsoft.JSON from the EF7 provider, so reference the JSON methods via reflection.
It may be a good idea to provide an opt-out for this in case there's trouble or client-side evaluation is preferred. At the query and model levels.