Getting first element of an IEnumerable item

Question

I am returning an IEnumerable<object[]> element from a function that uses yield return in a loop.

public static IEnumerable<object[]> GetData()
{
        ...

        connection.Open();

        using (OleDbDataReader dr = command.ExecuteReader())
        {
            while (dr.Read())
            {
            object[] array = new object[dr.FieldCount];
                dr.GetValues(array);
            yield return array;
            }
        }

        connection.Close();
}

What's the best way to retrieve the first element without using a loop preferably?

var result = Adapter.GetData();

Answer 1

In short:

enumerator=result.GetEnumerator();
enumerator.MoveNext();
enumerator.Current;

This is what a foreach does in a loop to iterate through all the elements.

Proper way:

using (IEnumerator<object[]> enumerator = result.GetEnumerator()) {
    if (enumerator.MoveNext()) e = enumerator.Current;

}

With LINQ:

var e = result.First();

or

var e = result.FirstOrDefault(default);

Also:

var e = result.ElementAt(0);

Answer 2

If your .Net 3.5 or higher

Adapter.GetData().First()