Welcome to the Lounge

var connectionString = builder.Configuration.GetConnectionString("DefaultConnection") ??
                       throw new InvalidOperationException("Connection string 'DefaultConnection' not found.");
builder.Services.AddDbContext<ApplicationDbContext>(options =>
{
  options.UseNpgsql(connectionString, o => o.UseQuerySplittingBehavior(QuerySplittingBehavior.SplitQuery))
    .UseSnakeCaseNamingConvention()
    .ConfigureWarnings(warnings => warnings.Throw(RelationalEventId.QueryPossibleUnintendedUseOfEqualsWarning));
});

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
  // Apply the naming convention to all relationships
  foreach (var relationship in modelBuilder.Model.GetEntityTypes().SelectMany(e => e.GetForeignKeys()))
  {
    relationship.SetConstraintName(relationship.GetConstraintName().Replace("_id", "_key"));
  }
  base.OnModelCreating(modelBuilder);
}

Christian Graus wrote:

EF