Delete data

SQLBuilder

Single row

Standard DELETE:

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

Multiple rows

Different conditions, batch delete:

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

Repository

By primary key

Single:

    _sysRegionRep.DeleteById("OID");

Batch:

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

Predicate delete

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

SQLClip

Basic

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

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

Shortcut

var demoOID = Guid.Empty.ToString();

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