LSL.EfCore.SettingsTable 1.0.5

LSL.EfCore.SettingsTable

This package provides ModelBuilder extension methods to allow you to produce a settings table.

NOTE: You will still need to create migrations to ensure the table gets created. Please see here for further details.

Quickstart

To add the required entities to your DbContext then following should be added to OnModelCreating as below:

    using LSL.EfCore.SettingsTable;
    ...
    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        ...
        modelBuilder.AddSettingsTable();
        ...
    }

The default table name is Settings with a Key field called Key and a value field called Value. Each value can be customised by overriding the defaults as below:

    using LSL.EfCore.SettingsTable;
    ...
    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        ...
        modelBuilder.AddSettingsTable("CustomSettingsTable", "CustomKeyField", "CustomValueField");
        ...
    }

Finer grained control

Another extension method exists that allows for finer-grained control over the entity used and its EF Core configuration:

using LSL.EfCore.SettingsTable;
...
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    ...
    modelBuilder.AddSettingsTable<OtherSettings>(c => c.ConfigureEntity(e => e.HasKey(ee => ee.MyKey)));
    ...
}

In the example above the delegate passed into ConfigureEntity receives an EntityTypeBuilder<OtherSettings> to configure the EF Core entity