database: postgres
In Entity Developer, what column data type do you use to store JSON objects?
Storing JSON objects
Re: Storing JSON objects
JSON is mapped to System.String. Refer to https://www.devart.com/dotconnect/postg ... pping.html.
JIC: you can change default mapping via Visual Studio > Tools > Entity Developer > Options > Devart Entity Developer > Servers Options > PostgreSQL.
JIC: you can change default mapping via Visual Studio > Tools > Entity Developer > Options > Devart Entity Developer > Servers Options > PostgreSQL.
Re: Storing JSON objects
If you work with Devart EF Core Model (*.efml) using Npgsql provider, you can map JSON to JsonDocument and JsonElement.
Refer to https://www.devart.com/entitydeveloper/ ... story.html:
6.11.1213 01-Apr-21
System.Text.Json (JsonDocument and JsonElement as property types) is supported for Pomelo.EntityFrameworkCore.MySql and Npgsql in EF Core Model
Refer to https://www.devart.com/entitydeveloper/ ... story.html:
6.11.1213 01-Apr-21
System.Text.Json (JsonDocument and JsonElement as property types) is supported for Pomelo.EntityFrameworkCore.MySql and Npgsql in EF Core Model