Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jsonb[] mapping not working #3131

Open
sumit-sood-pluralsight opened this issue Mar 13, 2024 · 1 comment
Open

Jsonb[] mapping not working #3131

sumit-sood-pluralsight opened this issue Mar 13, 2024 · 1 comment

Comments

@sumit-sood-pluralsight
Copy link

sumit-sood-pluralsight commented Mar 13, 2024

Hi,
I am using these packages in my .Net Core 8project :

  • Microsoft.EntityFrameworkCore 8.0.2
  • Npgsql 8.0.2
  • Npgsql.EntityFrameworkCore.PostgreSQL 8.0.2
  • EFCore.NamingConventions 8.0.3

My DBContext looks like this :
services.AddDbContext<MyDbContext>( options => options.UseNpgsql(connectionStrings.ReadOnlyConnectionString) .UseSnakeCaseNamingConvention() .UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking)

When I am trying to map the jsonb[] (jsonb Array) using OwnsMany it's throwing error. I have added the mapping like this in the OnModelCreating :
builder.Entity<SomeEntity>() .OwnsMany(auth => auth.AllContent, d => { d.ToJson("all_content"); });

I have defined my POCO class as :

public class SomeEntity 
{     
 public List<SomeContent> AllContent { get; set; } = []; 
}
public class SomeContent {   
 [JsonPropertyName("guid")] 
 public string Id { get; set; } 
[JsonPropertyName("content_type")] 
public string ContentType { get; set; } 
[JsonPropertyName("status")] 
public string Status { get; set; } 
}

When I am trying to access my Entity I am getting error : "Reading as 'System.String' is not supported for fields having DataTypeName 'jsonb[]'\nType 'String' required dynamic JSON serialization, which requires an explicit opt-in; call 'EnableDynamicJson' on 'NpgsqlDataSourceBuilder' or NpgsqlConnection.GlobalTypeMapper (see https://www.npgsql.org/doc/types/json.html and the 8.0 release notes for more details). Alternatively, if you meant to use Newtonsoft JSON.NET instead of System.Text.Json, call UseJsonNet() instead."

Is jsob[] supported currently if yes Please suggest how to access jsonb[] or am I missing something. Thanks in Advance.

@zN3utr4l
Copy link

#3172 (comment)

I think my problem is related to this issue.

Have you found a way to fix it?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants