how to connect mysql to .net program as 2nd db

        // Replace 'YourDbContext' with the name of your own DbContext derived class.
        services.AddDbContext<YourDbContext>(
            dbContextOptions => dbContextOptions
                .UseMySql(connectionString, serverVersion)
                // The following three options help with debugging, but should
                // be changed or removed for production.
                .LogTo(Console.WriteLine, LogLevel.Information)
                .EnableSensitiveDataLogging()
                .EnableDetailedErrors()
        );

        // Replace 'YourDbContext' with the name of your own DbContext derived class.
        services.AddDbContext<YourDbContext>(
            dbContextOptions => dbContextOptions
                .UseMySql(connectionString, serverVersion)
                // The following three options help with debugging, but should
                // be changed or removed for production.
                .LogTo(Console.WriteLine, LogLevel.Information)
                .EnableSensitiveDataLogging()
                .EnableDetailedErrors()
        );

public class TestAppContext : DbContext
{
    public TestAppContext(DbContextOptions<TestAppContext> contextOptions) : base(contextOptions)
    {
    }

public class TestAppContext : DbContext
{
    public TestAppContext(DbContextOptions<TestAppContext> contextOptions) : base(contextOptions)
    {
    }

public Follow GetFollowById(int id)
{
    using(var conn = new SqlConnection(_connectionString))
    using(var cmd = conn.CreateCommand())
    {
        conn.Open();
        cmd.CommandText = "SELECT id, name FROM followedUsername WHERE id = @id";
        cmd.Parameters.AddWithValue("id", id);
        using (var reader = cmd.ExecuteReader())
        {
            if (!reader.Read())
            {
                return null;
            }
            return new Follow
            {
                Id = reader.GetInt32(reader.GetOrdinal("id")),
                FollowedUsername = reader.GetString(reader.GetOrdinal("username")),
            };
        }
    }
}

public Follow GetFollowById(int id)
{
    using(var conn = new SqlConnection(_connectionString))
    using(var cmd = conn.CreateCommand())
    {
        conn.Open();
        cmd.CommandText = "SELECT id, name FROM followedUsername WHERE id = @id";
        cmd.Parameters.AddWithValue("id", id);
        using (var reader = cmd.ExecuteReader())
        {
            if (!reader.Read())
            {
                return null;
            }
            return new Follow
            {
                Id = reader.GetInt32(reader.GetOrdinal("id")),
                FollowedUsername = reader.GetString(reader.GetOrdinal("username")),
            };
        }
    }
}

docker run --name mysql-demo -e MYSQL_ROOT_PASSWORD=ensar1234 -d -p 3307:3306 mysql

docker run --name mysql-demo -e MYSQL_ROOT_PASSWORD=ensar1234 -d -p 3307:3306 mysql