EVCB_OCPP.OCPPServer.16J/EVCB_OCPP.WSServer/Service/WebDbService.cs

using Dapper;
using Microsoft.Data.SqlClient;
using Microsoft.Extensions.Configuration;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EVCB_OCPP.WSServer.Service;

public class WebDbService
{
    public WebDbService(IConfiguration configuration)
    {
        this.webConnectionString = configuration.GetConnectionString("WebDBContext");
    }

    private readonly string webConnectionString;

    public async Task<List<string>> GetDenyModelNames()
    {
        using SqlConnection conn = new SqlConnection(webConnectionString) ;
        string strSql = """
                SELECT [Value] 
                FROM [StandardOCPP_Web].[dbo].[KernelConfig]
                where SystemKey = 'DenyModelNames';
                """;

        var result = await conn.QueryFirstOrDefaultAsync<string>(strSql);

        return result.Split(',').ToList();

    }
}