Generic SQL with T

Generic SQL Get

/// <summary>
/// Generic type SQL Query Fetch
/// </summary>
/// <typeparam name="T">Generic</typeparam>
/// <param name="connectionString">SQL Connection string</param>
/// <param name="sql">SQL select query</param>
/// <returns>List Object of type inferred</returns>
public async Task<IEnumerable<T>> QueryTask<T>(string connectionString, string sql)
{
    using IDbConnection db = new SqlConnection(connectionString);
    var result = await db.QueryAsync<T>(sql);
    return result;
}

//Usage:
var resultList = await QueryTask<string>(connString, queryString);

/// <summary>
/// Generic type SQL Query Fetch
/// </summary>
/// <typeparam name="T">Generic</typeparam>
/// <param name="connectionString">SQL Connection string</param>
/// <param name="sql">SQL select query</param>
/// <returns>Object of type inferred</returns>
public async Task<T> QueryTask<T>(string connectionString, string sql)
{
    using IDbConnection db = new SqlConnection(connectionString);
    var result = await db.QueryFirstOrDefaultAsync<T>(sql);
    return result;
}

//Usage:
var result = await QueryTask<string>(connString, queryString);