Skip to content

Delete data ​

SQLBuilder ​

Single row ​

Standard DELETE:

c#
var cc = kit
    .setTable("ZH_PortCell")
    .where("ZH_PortCellOID", "OID")
    .doDelete();

Multiple rows ​

Different conditions, batch delete:

c#
var toDelete = new List<string>(){"OID1","OID2"};
var cc = kit
    .setTable("ZH_PortCell")
    .whereIn("ZH_PortCellOID", toDelete)
    .doDelete();

Repository ​

By primary key ​

Single:

c#
    _sysRegionRep.DeleteById("OID");

Batch:

c#
    var ids = new List<string>(){"OID1","OID2"};
    _sysRegionRep.DeleteByIds(ids);

Predicate delete ​

c#
_sysPosRep.Delete(u => u.Id == input.Id);

SQLClip ​

Basic ​

Use SQLBuilder to obtain SQLClip, then build conditions and delete:

c#
var cc = kit.useClip((c) =>
{
    return c.setTable<HHDutyItem>(out var d)
        .where(() => d.HH_DutyItemOID, demoOID)
        .doDelete();
});

Shortcut ​

c#
var demoOID = Guid.Empty.ToString();

var cc = kit.removeBy<HHDutyItem>((c, d) =>c.where(() => d.HH_DutyItemOID, demoOID));