AipGateway/AipDatabase.API/Repositories/AipConfigRepository.cs

using AipDatabase.API.Infrastructures;
using AipDatabase.API.Interfaces;
using AipDatabase.API.Models;
using Dapper;
using Microsoft.Data.SqlClient;
using System.Data;

namespace AipDatabase.API.Repositories
{
    public class AipConfigRepository : IAipConfigRepository
    {
        private readonly ILogger<AipConfigRepository> _log;
        private readonly IDatabaseFactory _databaseFactory;
        readonly SqlHelper<AipConfigRepository> _sqlHelper;
        
        public AipConfigRepository(ILogger<AipConfigRepository> log, IDatabaseFactory databaseFactory)
        {
            _log = log;
            _databaseFactory = databaseFactory;
            _sqlHelper = new SqlHelper<AipConfigRepository>();
        }

        public async Task<List<AipConfig>> FindAll()
        {
            try
            {
                string sql = _sqlHelper.GetSqlFromEmbeddedResource("AipConfig.Get");
                using var connection = _databaseFactory.GetDbConnection();
                IEnumerable<AipConfig> result = await connection.QueryAsync<AipConfig>(
                    sql,
                    commandType: CommandType.Text
                    );
                return result.ToList();
            }
            catch (Exception)
            {
                throw;
            }
        }
    }
}