How to make EF Core retry on socket error when connecting to Pgsql
I am connecting to a PostgreSQL server using EF Core and Npgsql.
EF Core – Configure row version for all entities that derive from a base class
In order to have a row version on an entity the documentation guides to do this:
MSDataSetGenerator generates references to obsolete type NpgsqlTypes.NpgsqlDbType.TimestampTZ
Like the title says, in my .Net Core 8 project, MSDataSetGenerator generates references to obsolete type TimestampTZ instead of TimestampTz (note the case difference!). Every time I change my .xsd file, I have to search/replace TimestampTZ for TimestampTz to compile.
Is it possible to have a secondary mapping of a field(json) in NPGSQL/EF Core for querying purposes only?
I have a very dynamic json data(extracted from a diagnostic tool) and mapping everything is very tedious, and there’s a possibility that the data content might change, so I have to store everything.