Session.Delete(ICollection) Method

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v23.2.dll

Declaration

public void Delete(
    ICollection objects
)

Public Sub Delete(
    objects As ICollection
)

Remarks

If a persistent object has the DeferredDeletionAttribute, the Delete method does not physically delete the underlying database record. It uses a hidden GCRecord field to mark the object as deleted. Clear all references to the object to delete this object when the Session.PurgeDeletedObjects method is called.

If the DeferredDeletionAttribute is not set, the Delete method removes the underlying database record if this operation does not violate foreign key constraints.

How to Delete All Objects in an XPCollection

The following code deletes all objects in an XPCollection and deletes the corresponding database records:

using DevExpress.Xpo;  
using DevExpress.Data.Filtering;  
// ...  
var colDelete = new XPCollection<YourPersistentType>(theSession, new BinaryOperator("YourPropertyName", true)); // Objects for deletion.
theSession.Delete(colDelete); 

Imports DevExpress.Xpo
Imports DevExpress.Data.Filtering
' ...
Dim colDelete = New XPCollection(Of YourPersistentType)(theSession, New BinaryOperator("YourPropertyName", True))
theSession.Delete(colDelete)

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Delete(ICollection) method.

XPCollection<OrderDetail> orderDetails = new XPCollection<OrderDetail>(uow);
uow.Delete(orderDetails);
uow.Delete(docs);

XPCollection<Sequence> sequencList = new XPCollection<Sequence>(uow);
uow.Delete(personList);
uow.Delete(addressList);

Dim sequencList As New XPCollection(Of Sequence)(uow)
uow.Delete(personList)
uow.Delete(addressList)