Delete

Use DeleteFrom<T>() with an explicit filter.

var affected = await connection
    .UseDb4Net(Db4NetOptions.Sqlite)
    .DeleteFrom<User>()
    .Where(u => u.Id, Op.Eq, 1)
    .ExecuteAsync();

Filters use the same Where(...), OrWhere(...), WhereGroup(...), and OrWhereGroup(...) APIs as select queries.

Delete by Key

Use WhereKey(entity) when key metadata should become the delete predicate.

var affected = db.DeleteFrom<User>()
    .WhereKey(user)
    .Execute();

Delete(entity) and WhereKey(entity) require exactly one mapped key and a non-default key value. Use explicit Where(...) clauses for composite-key models.

All Rows

DELETE requires a WHERE clause by default.

var affected = db.DeleteFrom<User>()
    .AllowAllRows()
    .Execute();

WARNING

Call AllowAllRows() only when intentionally deleting every row.