efcore.pg
efcore.pg copied to clipboard
JsonPath column support
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?