Are there any updates on support for jsonb in nhibernate? I was able to create a working solution using for saving jsonb to and from postgresql. This link in particular was very helpful: https://www.cloudconstruct.com/blog/using-postgresql-s-jsonb-data-type-with-nhibernate
I can use the raw query interface to create postgresql json queries, but I would like to be able use LINQ like I can I for non jsonb queries. Is this something that needs to be implemented in nhibernate or could I create an extension for it similar to the IUsetType for supporting jsonb? On Sunday, March 29, 2015 at 9:09:20 AM UTC-4, Dmitry Kalyanov wrote: > > Support JSON type is actually more complex than just custom IUserType. > > JSON type in postgresql also add several operators for constructing and > destructuring JSON values (e.g., you select only part of an object or use > JSON fields in `where` predicate). I guess that some of operators could be > implemented with custom SQL functions and appropriate HQL generators for > LINQ. But some JSON-related functions are more complex - e.g., you can > aggregate entire query result into one JSON value or "unnest" single JSON > value to multiple rows. > > On Monday, March 10, 2014 at 10:59:31 PM UTC+4, Oskar Berggren wrote: >> >> Sounds like you should implement IUserType, or not? >> >> Looks like Dru found an issue in Npgsql also: >> https://nhibernate.jira.com/browse/NH-3603 >> >> Apart from that, anyone is free to suggest what features NHibernate >> should have in relation to this, and come up with an implementation. I'm >> not aware of anyone working on something. >> >> /Oskar >> >> >> >> >> 2014-03-10 19:09 GMT+01:00 Namith <[email protected]>: >> >>> Sorry if this is the wrong place to ask this. >>> Is there planned surport for postgres hstore and json types posibly in >>> 4.0? >>> >> -- --- You received this message because you are subscribed to the Google Groups "nhibernate-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
