efcore.pg icon indicating copy to clipboard operation
efcore.pg copied to clipboard

JsonPath column support

Open eknkc opened this issue 2 years ago • 0 comments

Hi,

Is there a way to define a JsonPath column in ef core model? While doing this generates the correct migration and schema:

  [Column("filter_jsonpath", TypeName = "jsonpath")]
  [StringLength(4096)]
  public string? Filter_Jsonpath { get; set; }

It does not allow saving a jsonpath query in the database resulting the following exception:

PostgresException: 42804: column "filter_jsonpath" is of type jsonpath but expression is of type character varying

Can I somehow map a string to jsonpath in db?

eknkc avatar Dec 27 '23 13:12 eknkc