Json column type instead of jsonb with .ToJson()

[Mandrakia]

I haven't found a place where we can specify the column type. If I write something like

  modelBuilder.Entity<ProspectAdFilter>(entity =>
  {
      entity.OwnsOne(a => a.Model, x =>
      {
          x.ToJson("ModelJson").HasColumnType("json");
      });
  }); 

It results in a an error as the property is mapped to a string in the model instead of an object.

Switching from json to jsonb is not really an option for us as it pushes the database from a measly 2Gb to a 65Gb one.

[roji]

Duplicate of dotnet/efcore#28452

[roji]

This should be available on 9.0 - give 9.0.0-rc.2 a try and let me know if you're hitting issues.