Unit of work

Overview

A unit of work groups operations that commit or roll back together—essentially a transaction boundary with a friendlier API for entities.

Construction

Full name or shortcut:

var work= DBCash.useUnitOfWork(0);
var work2= DBCash.useWork(0);

From DBInstance:

var db = DBCash.GetDBInstance(0);
var work3= db.useWork();

Usage

work.Insert(new HHDutyItem());
work.InsertRange(new List<HHDutyItem>());
work.Update(new HHDutyItem());
work.UpdateRange(new List<HHDutyItem>());
work.Delete(new HHDutyItem());
work.DeleteRange(new List<HHDutyItem>());

work.AddSQL(new SQLCmd("insert into HHDutyItem(id) values('123')"));
work.AddSQLs(new List<SQLCmd>() { });

work.InsertBySQL((kit) =>
{
    kit.setTable("HHDutyItem")
    .set("id", 1)
    .set("name", "123");  
}
);
work.UpdateBySQL((kit) =>
{
    kit.setTable("HHDutyItem")
        .set("sex", 1)
        .set("name", "123")
        .where("id", 1);
}
);
work.DeleteBySQL((kit) =>
{
    kit.setTable("HHDutyItem")
    .where("id", 1);
}
);

work.Commit();

Commit

work.Commit();

API reference

AddSQL / AddSQLs

work.AddSQL(new SQLCmd("insert into HHDutyItem(id) values('123')"));

work.AddSQLs(new List<SQLCmd>() { });

InsertBySQL

work.InsertBySQL((kit) =>
{
    kit.setTable("HHDutyItem")
    .set("id", 1)
    .set("name", "123");
});

Insert / InsertRange

work.Insert(new HHDutyItem());

work.InsertRange(new List<HHDutyItem>());

Update / UpdateRange

work.Update(new HHDutyItem());

work.UpdateRange(new List<HHDutyItem>());

UpdateBySQL

work.UpdateBySQL((kit) =>
{
    kit.setTable("HHDutyItem")
    .set("sex", 1)
    .set("name", "123")
    .where("id", 1);
});

Delete / DeleteRange

work.Delete(new HHDutyItem());

work.DeleteRange(new List<HHDutyItem>(
    
))

DeleteById / DeleteByIds

work.DeleteById<HHDutyItem>(1);

work.DeleteByIds<HHDutyItem>(new List<int>() { 1, 2, 3 });

DeleteBySQL

work.DeleteBySQL((kit) =>
{
    kit.setTable("HHDutyItem")
    .where("id", 1);
});

Commit

work.Commit();