Delete with Filter Command Builder

The DeleteWithFilter command performs set-based deletes using a where expression or filter object.


This accepts a SQL expression, with optional parameter object, or a filter object.

SQL Generation

If soft delete is enabled for this table, an update operation will be generated to set the deleted flag.


Implementation of the delete varies by database.

SQL Server

SQL Server uses an UPDATE statement with an optional OUTPUT clause.


SQLite uses a separate DELETE and optional SELECT statement.