orm 事物的使用
orm 事物的使用案例如下:
using (var tran = DataAccess.LepulsDB.DBContext.BeginTransaction())
{
try
{
if (InspectTableCheck != null)
{
var itemlist = LepulsDB.DBContext.IC_InspectItem.Select().Where(m => m.IC_InspectItemID.In(InspectTableCheck)).ToList();
var contentList = LepulsDB.DBContext.IC_InspectCotent.Select().Where(m => m.IC_InspectCotentID.In(InspectTableCheck)).ToList();
var importItemtList = new List<IC_InspectItem>();
var importContentList = new List<IC_InspectCotent>();
LepulsDB.DBContext.IC_InspectItem.InsertCustom(importItemtList).SetTransaction(tran).Execute();
LepulsDB.DBContext.IC_InspectCotent.InsertCustom(importContentList).SetTransaction(tran).Execute();
tran.Commit();
return true;
}
}
catch
{
tran.Rollback();
return false;
}
}