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;
}
}

posted @ 2017-10-09 14:00  飞刀软件  阅读(125)  评论(0编辑  收藏  举报