AipGateway/AipGateway.API/Infrastructures/DatabaseFactory.cs

using Microsoft.Data.SqlClient;
using System.Data;

namespace AipDatabase.API.Infrastructures
{
    public class DatabaseFactory : IDatabaseFactory
    {
        private readonly string _connectionString;

        public DatabaseFactory(IConfiguration configuration)
        {
            _connectionString = configuration.GetConnectionString("DefaultConnection") ?? throw new ApplicationException("Missing Database connection string.");
        }

        IDbConnection IDatabaseFactory.GetDbConnection()
        {
            return new SqlConnection(_connectionString);
        }
    }

}