protected override void OnModelCreating(ModelBuilder builder)
{
var tableBuilder = new RelationalTableSettingsBuilder();
tableBuilder.Add(new RelationalTableSettings(typeof(Person), "admin"));
builder
.SetPrimaryKeyColumnNamesFormat(x => x.ClrType.Name + "Id") // sets primary key column name to <EntityName>Id
.SetDbColumnNamesFormat(x => x.ToLower()) // sets all property names to lowercase
.SetDbTableNamesFormat(x => x.ToLower()) // sets all table names to lowercase
.ApplyTableSettings(tableBuilder) // apply all of the settings from the tableBuilder variable above
.UseIndexConvention();
base.OnModelCreating(builder);
}
public static ModelBuilder ApplyTableSettings(this ModelBuilder modelBuilder, RelationalTableSettingsBuilder tableSettingsBuilder)
{
return(tableSettingsBuilder.Apply(modelBuilder));
}
