Start Debugging

Tag: ef-core-10

4 posts

2026-10-06 errors ef-core ef-core-10

Fix: There is already an object named 'X' in the database after resetting EF Core migrations

After you delete the Migrations folder and scaffold a new InitialCreate, EF Core does not know your tables exist. Drop a dev database, or record the new migration in __EFMigrationsHistory without running it.

2026-10-04 ef-core ef-core-10 postgresql

How to set PostgreSQL session parameters such as search_path or statement_timeout on every EF Core connection with Npgsql

A SET statement run once is wiped by DISCARD ALL the moment Npgsql returns the connection to its pool. Put search_path and statement_timeout in the startup packet with the Search Path and Options connection string keywords, fall back to ALTER ROLE or a ConnectionOpened interceptor, and know why UsePhysicalConnectionInitializer silently loses its SET.

2026-09-21 ef-core ef-core-10 postgresql

How to atomically append to a PostgreSQL jsonb array with EF Core and Npgsql

Loading an entity, calling List.Add, and saving rewrites the whole jsonb document and silently loses concurrent appends. Push the append into one UPDATE with the jsonb || operator, either through ExecuteSqlAsync or a mapped function inside ExecuteUpdateAsync, and make it idempotent with a @> guard.

2026-09-21 ef-core ef-core-10 oracle

How to use an Oracle sequence to generate primary keys in EF Core

Map an EF Core key to an Oracle sequence with UseSequence in Oracle.EntityFrameworkCore 10: the DDL and INSERT SQL the provider really emits, how to point at an existing sequence or a legacy trigger, why quoting and HiLo trip people up, and how to move an identity column onto a sequence without ORA-00001.