✅ Mapping IDataReader into typed class

public static TestDataObject Create(IDataRecord record)
{
    return new TestDataObject
    {
        Id = (Guid)record["id"],
        Name = (string)record["name"],
        Value = (string)record["value"]
    };
}

private static IEnumerable<T> BuildResult<T>(IDataReader response, Func<IDataRecord, T> buildObject)
{
    Console.WriteLine("Building result");
    try
    {
        while (response.Read())
        {
            Console.WriteLine($"Working on nth response {response.NextResult()}");

            yield return buildObject(response);
        }
    }
    finally
    {
        response.Dispose();
    }
}

// Calling it like this:
TestDataObject[] result = BuildResult(response, TestDataObject.Create).ToArray();