Using json type to serialize data

[ma3yta]

dotnet/efcore#5868

Does this scenario supported by Npgsql.EntityFrameworkCore.PostgreSQL?

I run Add-Migrations and this command produce few fields(Address_Stree, Address_Country) instead one for serialized data:

public class Cat
    {
        public Guid Id { get; set; }
        public string Name { get; set; }

        [Column(TypeName = "json")]
        public Address Address { get; set; }
    }

    public class Address
    {
        public string Street { get; set; }
        public string Country { get; set; }
    }

public override void Up()
        {
            CreateTable(
                "public.Cats",
                c => new
                    {
                        Id = c.Guid(nullable: false),
                        Name = c.String(),
                        Address_Street = c.String(),
                        Address_Country = c.String(),
                    })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "public.Users",
                c => new
                    {
                        Id = c.Guid(nullable: false),
                        Name = c.String(),
                        Email = c.String(),
                    })
                .PrimaryKey(t => t.Id);

        }

[roji]

Nope, that won't work - nobody knows how to magically convert your Address class into a PostgreSQL json column. This would be similar to dotnet/efcore#4021.

If you don't really care about JSON but just want to store a class/struct in a PostgreSQL column, you may want to look at composite support - that's not working yet either but will very probably make it into the 1.1.0 release.

Am going to close this as it needs attention in a more EFCore general way and not just in Npgsql.

[idudinov]

Hi @roji ! Is your resolution for this issue still actual?

nobody knows how to magically convert your Address class into a PostgreSQL json column

I mean, in the light of this new feature http://www.npgsql.org/doc/types/jsonnet.html - supporting JSON.NET serialization, and new versions of EF Core, have things been changed somehow?

Thanks!

[roji]

@idudinov JSON.NET will provide automatic JSON serialization at the ADO.NET layer, but there's no support for it yet at the EF Core level (see #334 for details). So unfortunately this is still not supported.