Devart Forums

Initially, we wondered if hstore can be properly & automatically mapped to Dictionary<string, string> and vice versa. Now, we read hstore fields as a string and do the parsing on our own.

From the other hand, we need to be able to partially update those fields. Now we have to use raw SQL for such operations as:
- 'a=>b,c=>d'::hstore || 'e=>f' (adding a record or updating the existing one by key) - not sure if it can be done with Linq, most likely with the whole entity update only;
- Read the value for a particular key - it would be also nice to select from hstore to make a subquery.

Hi, we are licensed users of dotConnect for PostgreSQL. Some time ago we faced the issue that some of PostgreSQL issues like JSON functions were not supported by the dotConnect driver, and we do appreciate that now they have become available.

Is there any ability to map the hstore type to Dictionary using Entity Framework, and is there any option for us to use PostgreSQL functions for hstore? According to the release notes, it is supported since dotConnect for PostgreSQL 7.8, but declaring an entity's property of type Dictionary, with attribute [Column(Type="hstore")] gives an error. If it is supported, could you please point us to the documentation of the feature for Entity Framework Core? Thanks.