Embedding data from a database into a class using ASP.NET MVC Core

Question

I want to add some email configuration data from the database to a configuration class named AuthMessageSenderOptions, this class has the following properties:

public class AuthMessageSenderOptions
{
    public int PortNumber { get; set; }
    public string SmtpServer { get; set; }
    public string UserName { get; set; }
    public string Password { get; set; }
}

To enter the configuration details in the class appsettings.jsonin AuthMessageSenderOptionsI use this piece of code in Startup.cs:

services.Configure<AuthMessageSenderOptions>(Configuration.GetSection("SMTP"));

Now my question is:

How to read this data from the database instead appsettings.jsonand enter it into my class AuthMessageSenderOptionsfor future use?

Answer 1

, , IConfigurationSource , ConfigurationProvider.

-, :

public class CustomMailConfigSource: IConfigurationSource
{
    private readonly Action<DbContextOptionsBuilder> _dbOptions;

    public CustomMailConfigSource(Action<DbContextOptionsBuilder> dbOptions)
    {
        _dbOptions = dbOptions;
    }

    public IConfigurationProvider Build(IConfigurationBuilder builder)
    {
        return new CustomMailConfigProvider(_dbOptions);
    }
}

:

public class CustomMailConfigProvider: ConfigurationProvider
{
    public CustomMailConfigProvider(Action<DbContextOptionsBuilder> dbOptions)
    {
        DbOptions = dbOptions;
    }

    Action<DbContextOptionsBuilder> DbOptions { get; }

    public override void Load()
    {
        var builder = new DbContextOptionsBuilder<ConfigurationContext>();
        DbOptions(builder);

        using (var dbContext = new ConfigurationContext(builder.Options))
        {
            dbContext.Database.EnsureCreated();
            //Modify this to suit your needs, here is an example assuming you have a table called AuthMessageSenderOption with the same fields as the class in your question
            var authMessageSender = db.Context.AuthMessageSenders.FirstOrDefault();

            // You should add some code here to check if the settings exist and provide defaults if necessary

            Data = new Dictionary<string, string>
            {
                { "PortNumber", authMessageSenderOption.PortNumber},
                { "SmtpServer", authMessageSenderOption.SmtpServer },
                { "UserName", authMessageSenderOption.UserName},
                { "Password", authMessageSenderOption.Password}
            };
        }
    }
}

, .

IConfigurationBuilder:

public static class CustomProviderExtensions
{
    public static IConfigurationBuilder AddCustomMailConfigProvider(
        this IConfigurationBuilder builder, Action<DbContextOptionsBuilder> dbOptions)
    {
        return builder.Add(new CustomMailConfigSource(dbOptions));
    }
}

Main() , :

var config = new ConfigurationBuilder()
        .SetBasePath(Directory.GetCurrentDirectory())
        // Add "appsettings.json" to bootstrap EF config.
        .AddJsonFile("appsettings.json")
        // Add the EF configuration provider, which will override any
        // config made with the JSON provider.
        .AddCustomMailConfigProvider(dbOptions =>
            dbOptions .UseSqlServer(connectionStringConfig.GetConnectionString(
                "DefaultConnection"))
        )
        .Build();

:

https://docs.microsoft.com/en-us/aspnet/core/fundamentals/configuration/?tabs=basicconfiguration

https://docs.microsoft.com/en-us/dotnet/api/Microsoft.Extensions.Configuration.ConfigurationProvider?view=aspnetcore-2.0