Issue Report: Transaction Conflict in EF Core Migration Process

[Buutyful]

Describe the issue or suggestion

https://github.com/dotnet/docs-aspire/blob/d94e59ddf76e1cc5f3e7b1b025f809a4de823a25/docs/database/ef-core-migrations.md
Exception:
System.NotSupportedException: 'User transaction is not supported with a TransactionSuppressed migrations or a retrying execution strategy.'

Context:
Attempting to apply database migrations using a worker service in a .NET Aspire application with PostgreSQL and EF Core 9.0.1.

Problem Summary
The error occurred due to a conflict between two transaction management mechanisms:

Manual Transaction
Explicit transaction created via BeginTransactionAsync

EF Core Execution Strategy
Retry mechanism enabled via CreateExecutionStrategy()

These two approaches cannot coexist when performing migrations, as they create conflicting transaction contexts.

The way I run the code on my application: