Insert data

SQLBuilder

Single row

Standard INSERT INTO ... VALUES:

kit.setTable("HH_SysUser")
.set("Id",YitIdHelper.NextId())
.set("Account", row["USR_LOGIN"])
.set("Password", newpwd)
.set("Phone", row["MobilePhone"])
.set("Sex", 1)
.set("Status","1",false)
.set("AccountType","666")
.set("OrgId",0)
.set("OrderNo",100)
.set("IsDelete","0",false)
.doInsert();

Multiple rows

INSERT INTO ... VALUES with multiple value groups.

TIP

Each newRow() starts a new row. Keep chaining until doInsert() without mixing flows. For mixed insert/update, use BatchSQL.

kit.setTable("KB_DeptWorkor");
foreach (DataRow man in dt.Rows)
{
    kit.newRow()
        .set("KB_DeptWorkorOID", Guid.NewGuid())
        .set("HH_Org_FK", row.HH_Org_FK)
        .set("Dw_Task", "1")
        .set("Dw_Belong", "1", false)
        .set("SYS_LAST_UPD", DateTime.Now)
        .set("SYS_Deleted", "0", false);
}
var cc= kit.doInsert();

Repository

Single entity

_sysRegionRep.Insert(sysRegion)

Many entities

_sysRegionRep.InsertRange(sysRegions)