using System.Data;

using System.Data.SqlClient;

using Dapper;

​

public class DatabaseService

{

    private readonly string _connectionString;

​

    public DatabaseService(string connectionString)

    {

        _connectionString = connectionString;

    }

​

    public async Task<IEnumerable<T>> QueryAsync<T>(string sql, object? parameters = null)

    {

        using (IDbConnection connection = new SqlConnection(_connectionString))

        {

            await connection.OpenAsync();

            return await connection.QueryAsync<T>(sql, parameters);

        }

    }

}