CodoMetis.ValueRanges 10.4 and EFCore.ComplexIndexes are used to build a holiday-cottage booking API end to end. Date ranges are modelled as single values, overlapping bookings are blocked by a PostgreSQL exclusion constraint, and free nights are computed in one query. A practical example for EF Core developers working with PostgreSQL.
Microsoft's PostgreSQL extension brings connecting, browsing schemas, writing and running SQL, and asking GitHub Copilot about the connected database into VS Code. The post walks through four workflows, from exploring a first table to reviewing a performance recommendation. It is a practical guide for .NET developers who work against PostgreSQL and want to stay in their editor.
EF Core 10 with Npgsql 10 maps a .NET complex type to a PostgreSQL jsonb column using ToJson(). The article shows how LINQ property access becomes ->> SQL, which index types serve which queries, and when a jsonb column beats a separate EAV table. It is a practical guide for models with many sparse optional fields.