CREATE TABLE IF NOT EXISTS `__EFMigrationsHistory` (
    `migration_id` varchar(150) CHARACTER SET utf8mb4 NOT NULL,
    `product_version` varchar(32) CHARACTER SET utf8mb4 NOT NULL,
    CONSTRAINT `pk___ef_migrations_history` PRIMARY KEY (`migration_id`)
) CHARACTER SET=utf8mb4;

CREATE TABLE IF NOT EXISTS `__EFMigrationsHistory` (
    `migration_id` varchar(150) CHARACTER SET utf8mb4 NOT NULL,
    `product_version` varchar(32) CHARACTER SET utf8mb4 NOT NULL,
    CONSTRAINT `pk___ef_migrations_history` PRIMARY KEY (`migration_id`)
) CHARACTER SET=utf8mb4;

An error occurred while accessing the Microsoft.Extensions.Hosting services. Continuing without the application service provider.

An error occurred while accessing the Microsoft.Extensions.Hosting services. Continuing without the application service provider.

The Entity Framework tools version '8.0.3' is older than that of the runtime '8.0.4'. Update the tools for the latest features and bug fixes. See https://aka.ms/AAc1fbw for more information.

The Entity Framework tools version '8.0.3' is older than that of the runtime '8.0.4'. Update the tools for the latest features and bug fixes. See https://aka.ms/AAc1fbw for more information.

var connectionString = config.GetConnectionString("Default");

if (string.IsNullOrEmpty(connectionString))
{
    throw new Exception("Default connection string is missing");
}

var connectionString = config.GetConnectionString("Default");

if (string.IsNullOrEmpty(connectionString))
{
    throw new Exception("Default connection string is missing");
}

serviceCollection.AddDbContext<SadieContext>(options =>
{
    options.UseMySql(connectionString, MySqlServerVersion.LatestSupportedServerVersion, mySqlOptions =>
        mySqlOptions.EnableRetryOnFailure(
            maxRetryCount: 10,
            maxRetryDelay: TimeSpan.FromSeconds(30),
            errorNumbersToAdd: null
        ))
        .UseSnakeCaseNamingConvention();
});

serviceCollection.AddDbContext<SadieContext>(options =>
{
    options.UseMySql(connectionString, MySqlServerVersion.LatestSupportedServerVersion, mySqlOptions =>
        mySqlOptions.EnableRetryOnFailure(
            maxRetryCount: 10,
            maxRetryDelay: TimeSpan.FromSeconds(30),
            errorNumbersToAdd: null
        ))
        .UseSnakeCaseNamingConvention();
});

public static class ServerServiceCollection
{
    public static void AddServices(IServiceCollection serviceCollection, IConfiguration config)
    {
        DatabaseServiceCollection.AddServices(serviceCollection, config);
        MapperServiceCollection.AddServices(serviceCollection, config); 
        // ... 
    }
}

public static class ServerServiceCollection
{
    public static void AddServices(IServiceCollection serviceCollection, IConfiguration config)
    {
        DatabaseServiceCollection.AddServices(serviceCollection, config);
        MapperServiceCollection.AddServices(serviceCollection, config); 
        // ... 
    }
}

var host = Host.CreateDefaultBuilder()
    .ConfigureServices((context, collection) => ServerServiceCollection.AddServices(collection, context.Configuration))
    .UseSerilog((hostContext, _, logger) => 
        logger.ReadFrom.Configuration(hostContext.Configuration)
        .MinimumLevel.Override("Microsoft", LogEventLevel.Warning))
    .Build();

var host = Host.CreateDefaultBuilder()
    .ConfigureServices((context, collection) => ServerServiceCollection.AddServices(collection, context.Configuration))
    .UseSerilog((hostContext, _, logger) => 
        logger.ReadFrom.Configuration(hostContext.Configuration)
        .MinimumLevel.Override("Microsoft", LogEventLevel.Warning))
    .Build();