Migrations

dotnet ef migrations add <MigrationAdi> \
  --project    src/DiyanetCleanArchitecture.Infrastructure.EFCore \
  --startup-project src/DiyanetCleanArchitecture.API

dotnet ef migrations remove \
  --project    src/DiyanetCleanArchitecture.Infrastructure.EFCore \
  --startup-project src/DiyanetCleanArchitecture.API

dotnet ef migrations script --idempotent \
  --project    src/DiyanetCleanArchitecture.Infrastructure.EFCore \
  --startup-project src/DiyanetCleanArchitecture.API \
  --output     migration.sql

public class DiyanetCleanArchitectureDesignTimeDbContextFactory
    : DesignTimeDbContextFactoryBase<DiyanetCleanArchitectureDbContext>
{
    protected override DiyanetCleanArchitectureDbContext CreateNewInstance(
        DbContextOptions<DiyanetCleanArchitectureDbContext> options)
        => new(options, new NoMediator(), new NoEventBus(),
               new AuditInterceptor(new NoAuditUserContext()));
}

private const string ConnectionStringName = "DiyanetCleanArchitectureDatabaseConnection";
private readonly string BasePath =
    Path.Combine(Directory.GetCurrentDirectory(), "../DiyanetCleanArchitecture.API");

// appsettings.json + appsettings.{ASPNETCORE_ENVIRONMENT}.json + env değişkenleri
optionsBuilder.UseNpgsql(connectionString)
              .UseSnakeCaseNamingConvention();

public async Task StartAsync(CancellationToken cancellationToken)
{
    if (_options.CurrentValue.AutoDeploy == false)
    {
        _logger.LogInformation("📢 Migration servisi kapalı.");
        return;
    }

    using var scope = _serviceProvider.CreateScope();
    var dbContext = scope.ServiceProvider.GetRequiredService<DiyanetCleanArchitectureDbContext>();

    int retryCount = 0;
    while (retryCount < MaxRetryCount && !cancellationToken.IsCancellationRequested) // MaxRetryCount = 3
    {
        try
        {
            if (!await dbContext.Database.CanConnectAsync(cancellationToken))
                _logger.LogWarning("🆕 Veritabanı bulunamadı. İlk kurulum başlatılıyor...");

            await dbContext.Database.MigrateAsync(cancellationToken);
            return;
        }
        catch (Exception ex)
        {
            retryCount++;
            if (retryCount >= MaxRetryCount) throw;
            await Task.Delay(TimeSpan.FromSeconds(5), cancellationToken);
        }
    }
}

{
  "Services": {
    "Migration": {
      "AutoDeploy": true
    }
  }
}