Program.cs

using Microsoft.EntityFrameworkCore.Infrastructure;
using Steeltoe.Configuration.CloudFoundry;
using Steeltoe.Connectors.EntityFrameworkCore.MySql;
using Steeltoe.Connectors.MySql;
using Steeltoe.Management.Endpoint.Actuators.All;
using Steeltoe.Samples.MySqlEFCore;
using Steeltoe.Samples.MySqlEFCore.Data;

WebApplicationBuilder builder = WebApplication.CreateBuilder(args);

// Add services to the container.
builder.Services.AddControllersWithViews();

// Steeltoe: Add Cloud Foundry Configuration Provider for Actuator integration (not required for connectors).
builder.AddCloudFoundryConfiguration();

// Steeltoe: Add actuator endpoints.
builder.Services.AddAllActuators();

// Steeltoe: Setup MySQL options, connection factory and health checks.
builder.AddMySql();

// Steeltoe: Review appsettings.development.json to see how local connection strings are provided.
bool useMultipleDatabases = builder.Configuration.GetValue("useMultipleDatabases", false);

if (useMultipleDatabases)
{
    // Steeltoe: When using multiple databases, specify the service binding name.
    const string serviceOneName = "sampleMySqlServiceOne";
    const string serviceTwoName = "sampleMySqlServiceTwo";

    // Steeltoe: optionally change the MySQL connection strings at runtime.
    builder.Services.Configure<MySqlOptions>(serviceOneName, options => options.ConnectionString += ";Use Compression=false");
    builder.Services.Configure<MySqlOptions>(serviceTwoName, options => options.ConnectionString += ";Use Compression=true");

    // Steeltoe: Setup DbContext connection strings, optionally changing MySQL options at runtime.
    builder.Services.AddDbContext<AppDbContext>((serviceProvider, options) => options.UseMySql(serviceProvider, serviceOneName, null, untypedOptions =>
    {
        var mySqlOptions = (MySqlDbContextOptionsBuilder)untypedOptions;
        mySqlOptions.CommandTimeout(20);
    }));

    builder.Services.AddDbContext<OtherDbContext>((serviceProvider, options) => options.UseMySql(serviceProvider, serviceTwoName, null, untypedOptions =>
    {
        var mySqlOptions = (MySqlDbContextOptionsBuilder)untypedOptions;
        mySqlOptions.CommandTimeout(25);
    }));
}
else
{
    // Steeltoe: optionally change the MySQL connection string at runtime.
    builder.Services.Configure<MySqlOptions>(options => options.ConnectionString += ";Use Compression=false");

    // Steeltoe: Setup DbContext connection string, optionally changing MySQL options at runtime.
    builder.Services.AddDbContext<AppDbContext>((serviceProvider, options) => options.UseMySql(serviceProvider, null, null, untypedOptions =>
    {
        var mySqlOptions = (MySqlDbContextOptionsBuilder)untypedOptions;
        mySqlOptions.CommandTimeout(15);
    }));
}

WebApplication app = builder.Build();

// Configure the HTTP request pipeline.
if (!app.Environment.IsDevelopment())
{
    app.UseExceptionHandler("/Home/Error");
    // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
    app.UseHsts();
}

app.UseHttpsRedirection();
app.UseStaticFiles();

app.UseRouting();

app.UseAuthorization();

app.MapControllerRoute("default", "{controller=Home}/{action=Index}/{id?}");

// Steeltoe: Insert some rows into MySQL table.
await MySqlSeeder.CreateSampleDataAsync(app.Services);

if (useMultipleDatabases)
{
    await MySqlSeeder.CreateOtherSampleDataAsync(app.Services);
}

app.Run();