fknx / linqpad-postgresql-driver

LINQPad PostgreSQL Driver
MIT License
43 stars 17 forks source link

Support columns of data type "JSON" #20

Open s-stoffel opened 8 years ago

s-stoffel commented 8 years ago

Example:

CREATE TABLE public.booking
(
  ...,
  message json NOT NULL,
  ...
)

According to the table explorer the json column is unsupported. image

The result in the data grid doesn't include the column at all. image

And of course there is no "message" property which can be selected in my LINQ statement.

It would be nice to have a rudimentary support for such columns. Treating the json values as strings, as well as the possibility to copy the (whole!) json string from the data grid would be a start. Or maybe also the C# "dynamic" could be used as "type" for the respective property, so that such properties could be used in LINQ statements.