DataContext.Translate Method

  • Reference

Definition

Namespace:
System.Data.Linq
Assembly:
System.Data.Linq.dll

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>.

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.

public:
 System::Data::Linq::IMultipleResults ^ Translate(System::Data::Common::DbDataReader ^ reader);
public System.Data.Linq.IMultipleResults Translate (System.Data.Common.DbDataReader reader);
member this.Translate : System.Data.Common.DbDataReader -> System.Data.Linq.IMultipleResults
Public Function Translate (reader As DbDataReader) As IMultipleResults

Parameters

reader
DbDataReader

The IDataReader to be converted.

Returns

IMultipleResults

A list of objects returned by the conversion.

Applies to

Translate(Type, DbDataReader)

Converts an existing DbDataReader to objects.

public:
 System::Collections::IEnumerable ^ Translate(Type ^ elementType, System::Data::Common::DbDataReader ^ reader);
public System.Collections.IEnumerable Translate (Type elementType, System.Data.Common.DbDataReader reader);
member this.Translate : Type * System.Data.Common.DbDataReader -> System.Collections.IEnumerable
Public Function Translate (elementType As Type, reader As DbDataReader) As IEnumerable

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

IEnumerable

A list of objects returned by the conversion.

Applies to

Translate<TResult>(DbDataReader)

Converts an existing DbDataReader to objects.

public:
generic <typename TResult>
 System::Collections::Generic::IEnumerable<TResult> ^ Translate(System::Data::Common::DbDataReader ^ reader);
public System.Collections.Generic.IEnumerable<TResult> Translate<TResult> (System.Data.Common.DbDataReader reader);
member this.Translate : System.Data.Common.DbDataReader -> seq<'Result>
Public Function Translate(Of TResult) (reader As DbDataReader) As IEnumerable(Of TResult)

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