Method AsEnumerable

Namespace

Open.Database.Extensions

Assembly

Open.Database.Extensions.Core.dll

AsEnumerable(IDataReader)

Provides an enumerable for iterating all the remaining values of the current result set of a data reader.

public static IEnumerable<object[]> AsEnumerable(this IDataReader reader)

Parameters

reader IDataReader

The reader to enumerate.

Returns

IEnumerable<object[]>

An enumerable of the values returned from a data reader.

Remarks

DBNull values are retained.

AsEnumerable(IDataReader, ArrayPool<object>?)

Provides an enumerable for iterating all the remaining values of the current result set of a data reader.

public static IEnumerable<object[]> AsEnumerable(this IDataReader reader, ArrayPool<object>? arrayPool)

Parameters

reader IDataReader

The reader to enumerate.

arrayPool ArrayPool<object>

The array pool to acquire buffers from.

Returns

IEnumerable<object[]>

An enumerable of the values returned from a data reader.

Remarks

DBNull values are retained.

AsEnumerable(IDataReader, IEnumerable<int>)

Provides an enumerable for iterating all the remaining values of the current result set of a data reader.

public static IEnumerable<object[]> AsEnumerable(this IDataReader reader, IEnumerable<int> ordinals)

Parameters

reader IDataReader

The reader to enumerate.

ordinals IEnumerable<int>

The limited set of ordinals to include. If none are specified, the returned objects will be empty.

Returns

IEnumerable<object[]>

An enumerable of the values returned from a data reader.

Remarks

DBNull values are retained.

AsEnumerable(IDataReader, int, params IEnumerable<int>)

Provides an enumerable for iterating all the remaining values of the current result set of a data reader.

public static IEnumerable<object[]> AsEnumerable(this IDataReader reader, int n, params IEnumerable<int> others)

Parameters

reader IDataReader

The reader to enumerate.

n int

The first ordinal to include in the request to the reader for each record.

others IEnumerable<int>

The remaining ordinals to request from the reader for each record.

Returns

IEnumerable<object[]>

An enumerable of the values returned from a data reader.

Remarks

DBNull values are retained.

AsEnumerable(IDataReader, IEnumerable<int>, ArrayPool<object>?)

Provides an enumerable for iterating all the remaining values of the current result set of a data reader.

public static IEnumerable<object[]> AsEnumerable(this IDataReader reader, IEnumerable<int> ordinals, ArrayPool<object>? arrayPool)

Parameters

reader IDataReader

The reader to enumerate.

ordinals IEnumerable<int>

The limited set of ordinals to include. If none are specified, the returned objects will be empty.

arrayPool ArrayPool<object>

The array pool to acquire buffers from.

Returns

IEnumerable<object[]>

An enumerable of the values returned from a data reader.

Remarks

DBNull values are retained.

AsEnumerable(IDataReader, ArrayPool<object>?, int, params IEnumerable<int>)

Provides an enumerable for iterating all the remaining values of the current result set of a data reader.

public static IEnumerable<object[]> AsEnumerable(this IDataReader reader, ArrayPool<object>? arrayPool, int n, params IEnumerable<int> others)

Parameters

reader IDataReader

The reader to enumerate.

arrayPool ArrayPool<object>

The array pool to acquire buffers from.

n int

The first ordinal to include in the request to the reader for each record.

others IEnumerable<int>

The remaining ordinals to request from the reader for each record.

Returns

IEnumerable<object[]>

An enumerable of the values returned from a data reader.

Remarks

DBNull values are retained.