BaseDatabase

public class BaseDatabase
    {
        private IConfiguration _configuration;
        private readonly ILogger<BaseDatabase> _logger;

        private static string connectionString = "";

        public BaseDatabase(IConfiguration configuration, ILogger<BaseDatabase> logger)
        {
            _configuration = configuration;
            _logger = logger;
        }

        public MySqlConnection GetOpenConnection()
        {
            if (connectionString.Length == 0)
            {
                connectionString = _configuration.GetConnectionString("DefaultConnection");
            }

            MySqlConnection connection = new MySqlConnection(connectionString);
            try
            {
                connection.Open();
            }
            catch (Exception ex)
            {
                _logger.LogError(ex.ToString());
            }

            return connection;
        }
    }