DataContext.Translate DataContext.Translate DataContext.Translate DataContext.Translate Method

Definition

Converts an existing IDataReader to objects.

Overloads

Translate(DbDataReader) Translate(DbDataReader) Translate(DbDataReader) Translate(DbDataReader)

Converts an existing DbDataReader to objects.

Translate(Type, DbDataReader) Translate(Type, DbDataReader) Translate(Type, DbDataReader) Translate(Type, DbDataReader)

Converts an existing DbDataReader to objects.

Translate<TResult>(DbDataReader) Translate<TResult>(DbDataReader) Translate<TResult>(DbDataReader) 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) Translate(DbDataReader) Translate(DbDataReader) 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
Returns

A list of objects returned by the conversion.

Translate(Type, DbDataReader) Translate(Type, DbDataReader) Translate(Type, DbDataReader) 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 Type Type 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.

Returns

A list of objects returned by the conversion.

Translate<TResult>(DbDataReader) Translate<TResult>(DbDataReader) Translate<TResult>(DbDataReader) 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
Returns
IEnumerable<TResult>

A collection of objects returned by the conversion.

Applies to