DataContext.Translate Method

Definition

Converts an existing IDataReader to objects.

Overloads

Translate(DbDataReader)

Converts an existing DbDataReader to objects.

Translate(Type, DbDataReader)

Converts an existing DbDataReader to objects.

Translate<TResult>(DbDataReader)

Converts an existing DbDataReader to objects.

Remarks

Each row in the IDataReader is converted to an object in the IEnumerable<T>.

C#
public IEnumerable<T> Translate<T>(IDataReader reader) {}  

Description: This method is used to convert an existing DbDataReader to objects. Each row in the DbDataReader is converted to an object in the IEnumerable<T>.

Generic parameters:

T: See ExecuteQuery.

Parameters:

Query: See the description for command under ExecuteCommand.

Parameters: See the description for parameters under ExecuteCommand.

Return type:

IEnumerable<T>: collection of objects returned by the conversion.

Translate(DbDataReader)

Converts an existing DbDataReader to objects.

C#
public System.Data.Linq.IMultipleResults Translate (System.Data.Common.DbDataReader reader);

Parameters

reader
DbDataReader

The IDataReader to be converted.

Returns

A list of objects returned by the conversion.

Applies to

.NET Framework 4.8.1 and other versions
Product Versions
.NET Framework 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1

Translate(Type, DbDataReader)

Converts an existing DbDataReader to objects.

C#
public System.Collections.IEnumerable Translate (Type elementType, System.Data.Common.DbDataReader reader);

Parameters

elementType
Type

The type of the IEnumerable<T> to be returned.

The algorithm for matching columns in the result to fields and properties in the object works as follows:

If a field or property is mapped to a particular column name, that column name is expected in the resultset.

If a field or property is not mapped, a column with the same name as the field or property is expected in the resultset.

The comparison is performed by looking for a case-sensitive match first. If this match is not found, a subsequent search is occurs for a case-insensitive match.

The query must return all the tracked fields and properties of the object (except those that are loaded on a deferred basis) when all the following conditions are true:

T is an entity explicitly tracked by the DataContext.

ObjectTrackingEnabled is true.

The entity has a primary key.

Otherwise an exception is thrown.

reader
DbDataReader

The IDataReader to be converted.

Returns

A list of objects returned by the conversion.

Applies to

.NET Framework 4.8.1 and other versions
Product Versions
.NET Framework 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1

Translate<TResult>(DbDataReader)

Converts an existing DbDataReader to objects.

C#
public System.Collections.Generic.IEnumerable<TResult> Translate<TResult> (System.Data.Common.DbDataReader reader);

Type Parameters

TResult

The type of the IEnumerable<T> to be returned.

Parameters

reader
DbDataReader

The IDataReader to be converted.

Returns

IEnumerable<TResult>

A collection of objects returned by the conversion.

Applies to

.NET Framework 4.8.1 and other versions
Product Versions
.NET Framework 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1