QueryAsync.cs

//used as an example DTO type.
class Crosslink
{
    public string Code { get; set; }
    public string FullDescription { get; set; }
}

public async Task<Crosslink[]> QueryAsync(CommandType commandType, string query, params DbParameter[] parameters)
{
    var list = new List<Crosslink>();

    var dbFactory = DbProviderFactories.GetFactory("System.Data.SqlClient");
    using (var conn = dbFactory.CreateConnection())
    using (var cmd = conn.CreateCommand())
    {
        conn.ConnectionString = db.ConnectionString;

        if (parameters != null) {
            cmd.Parameters.AddRange(parameters);
        }

        cmd.CommandType = commandType;
        cmd.CommandText = query;

        await conn.OpenAsync();
        using (var reader = await cmd.ExecuteReaderAsync(CommandBehavior.CloseConnection | CommandBehavior.SingleResult))
        {
            int ciCode = reader.GetOrdinal("Code");
            int ciDesc = reader.GetOrdinal("FullDescription");
            while (await reader.ReadAsync())
            {
                list.Add(new Crosslink(reader.GetString(ciCode), reader.GetString(ciDesc)));
            }
        }
    }

    return list.ToArray();
}