Article
11/18/2011

Table<TEntity>.DeleteOnSubmit Method

Microsoft Silverlight will reach end of support after October 2021. Learn more.

Puts an entity from this table into a pending delete state.

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

Syntax

'Declaration
Public Sub DeleteOnSubmit ( _
    entity As TEntity _
)

public void DeleteOnSubmit(
    TEntity entity
)

Parameters

entity
Type: TEntity
The entity to be deleted.

Implements

ITable<TEntity>.DeleteOnSubmit(TEntity)

Remarks

The removed entity does not disappear from the query results until after SubmitChanges is called. Disconnected entities must first be attached before they can be deleted.

Note:
LINQ to SQL does not support or recognize cascade-delete operations. If you want to delete a row in a table that has constraints against it, you must either set the ON DELETE CASCADE rule in the foreign-key constraint in the database, or use your own code to first delete the child objects that prevent the parent object from being deleted. Otherwise, an exception is thrown.

Topic	Location
How to: Delete Rows From the Database (LINQ to SQL)	LINQ to SQL
Insert, Update, and Delete Operations (LINQ to SQL)	LINQ to SQL
Object States and Change-Tracking (LINQ to SQL)	LINQ to SQL
How to: Delete Rows From the Database (LINQ to SQL)	LINQ to SQL
Insert, Update, and Delete Operations (LINQ to SQL)	LINQ to SQL
Object States and Change-Tracking (LINQ to SQL)	LINQ to SQL

Version Information

Silverlight for Windows Phone

Supported in: Windows Phone OS 7.1

Platforms

For a list of the operating systems and browsers that are supported by Silverlight, see Supported Operating Systems and Browsers.

Share via