Duration (Pacific Standard Time):
To (Pacific Standard Time):
  • None
User Action:
  • None

DataContext.Translate Method (Type, DbDataReader)


The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Converts an existing DbDataReader to objects.

Namespace:   System.Data.Linq
Assembly:  System.Data.Linq (in System.Data.Linq.dll)

Public Function Translate (
	elementType As Type,
	reader As DbDataReader
) As IEnumerable


Type: System.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.

Type: System.Data.Common.DbDataReader

The IDataReader to be converted.

Return Value

Type: System.Collections.IEnumerable

A list of objects returned by the conversion.

.NET Framework
Available since 3.5
Return to top