Start Debugging

Tag: migrations

9 posts

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.

2026-09-19 ef-core ef-core-11 migrations

How to apply custom naming conventions for primary keys, foreign keys, and indexes in EF Core 11 migrations

Rename every PK_, FK_, AK_ and IX_ that EF Core 11 generates with one IModelFinalizingConvention, keep explicit names winning, stay under the identifier length limit, and avoid the clustered-index rebuild the next migration scaffolds on an existing database.

2026-08-30 errors ef-core ef-core-11

Fix: CREATE DATABASE permission denied in database 'master' when running dotnet ef database update

EF Core's Migrate() always checks whether the database exists and creates it if not, from a hardcoded master connection. Grant CREATE ANY DATABASE, fix the login's access to the existing database, or ship an idempotent SQL script instead.

2026-08-17 ef-core ef-core-11 sql-server

How to generate a primary key from a database sequence on insert in EF Core 11

Move a key off IDENTITY and onto a SQL Server sequence in EF Core 11 with UseSequence: the exact SQL EF emits, why explicit key values suddenly work without IDENTITY_INSERT, the bigint sequence feeding an int column, and the gaps you have to design around.

2026-08-09 ef-core ef-core-11 migrations

How to rename a table in an EF Core 11 migration without losing data

EF Core scaffolds RenameTable when you change the table name, but DropTable plus CreateTable when you rename the entity class. Here is how to tell the two apart, the ToTable trick that makes a class rename free, and the column-rename bug that silently swaps your data.

2026-07-30 errors ef-core ef-core-11

Fix: Your startup project doesn't reference Microsoft.EntityFrameworkCore.Design

Add Microsoft.EntityFrameworkCore.Design to the startup project that dotnet ef builds, not the project holding your DbContext, and pass -s in layered solutions.

2026-07-28 ef-core ef-core-11 dotnet

How to apply EF Core 11 migrations in production with dotnet ef migrations bundle

A complete guide to deploying EF Core 11 schema changes with migration bundles: building efbundle in CI, the appsettings.json trap with named connection strings, self-contained bundles and the Alpine musl RID, migration locking since EF Core 9, rolling back with a target migration, and why per-migration transactions do not save you on MySQL.

2026-05-14 errors csharp dotnet

Fix: SqlException: Timeout expired during EF Core migrations

Migrations use the design-time DbContext, not your runtime CommandTimeout. Set the timeout via UseSqlServer(o => o.CommandTimeout(...)), the connection string Command Timeout, or Database.SetCommandTimeout before Migrate().

2026-05-11 errors csharp dotnet

Fix: dotnet ef migrations add fails with 'Unable to create an object of type DbContext'

EF Core's design-time tools could not instantiate your DbContext. Either expose a host via WebApplication.CreateBuilder, point to the right startup project, or implement IDesignTimeDbContextFactory.