Table(Of TEntity).Attach Method (TEntity)


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

Attaches a disconnected or "detached" entity to a new DataContext when original values are required for optimistic concurrency checks.

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

Public Sub Attach (
	entity As TEntity


Type: TEntity

The original values of the entity to be attached.

Use the Attach methods with entities that have been created in one DataContext, serialized to a client, and then deserialized back to perform an update or delete operation. Because the new DataContext has no way of tracking what the original values were for a disconnected entity, the client is responsible for supplying those values. In this version of Attach, the entity is assumed to be in its original value state. After calling this method, you can then update its fields, for example with additional data sent from the client.

When a new entity is attached, deferred loaders for any child collections (for example, EntitySet collections of entities from associated tables) are initialized. When SubmitChanges is called, members of the child collections are put into an Unmodified state. To update members of a child collection, you must explicitly call Attach and specify that entity.

For more information, see Data Retrieval and CUD Operations in N-Tier Applications (LINQ to SQL).

Do not try to Attach an entity that has not been detached through serialization. Entities that have not been serialized still maintain associations with deferred loaders that can cause unexpected results if the entity becomes tracked by a second data context.

.NET Framework
Available since 3.5
Windows Phone Silverlight
Available since 7.1
Return to top