Entity Framework Power Tools & PostgreSQL JSON Data Type

Question

I have been playing around with the PostgreSQL JSON Data Type and when I try to reverse engineer code first with EF Power Tools JSON Data Type is ignored. If one manually configures the JSON filed in the FluentAPI configuration then everything is working. I have been using DevArt PostgreSQL driver, .NET 4.5.1, EF 6.x.

Is there a way to generate the JSON Data Type via EF Power Tools ?

Sounds like you need to report a bug to the folks who wrote the reverse engineering tool. It should be emitting unknown data types as "String" with a warning, or doing something along those lines, not ignoring them. — Craig Ringer
– Craig Ringer, Commented Jan 30, 2014 at 9:05
Yup done that entityframework.codeplex.com/workitem/2031 I hope they solve this soon, otherwise we need to manually add a lot of fields. — khorvat
– khorvat, Commented Jan 30, 2014 at 9:26

Devart · Accepted Answer · 2014-02-03 11:39:48Z

1

We will investigate the possibility of adding runtime support for the JSON data type in EF-provider of dotConnect for PostgreSQL and notify you about the result. This should fix the described problem with EF Power Tools.

answered Feb 3, 2014 at 11:39

Devart

120k23 gold badges172 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Devart Over a year ago

The JSON data type is supported in the latest (7.2.100) build of dotConnect for PostgreSQL: forums.devart.com/viewtopic.php?f=3&t=28936.

khorvat Over a year ago

We will try the build and get back to you if we find any issues. Thanks

khorvat Over a year ago

Sorry for so late response, I have an issue with the 7.3.115 version I get the following error when I try to include the object that has a json field "UNION types json and character varying cannot be matched", any ideas ?

Devart Over a year ago

Please send us ( devart.com/company/contactform.html ) a small test project with the corresponding DDL/DML script for reproducing the issue.

Collectives™ on Stack Overflow

Entity Framework Power Tools & PostgreSQL JSON Data Type

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related