事务，锁，并发

最新推荐文章于 2024-05-30 22:34:35 发布

一个大猴子

最新推荐文章于 2024-05-30 22:34:35 发布

阅读量329

点赞数

分类专栏： asp.net MVC

本文链接：https://blog.csdn.net/qq_15185769/article/details/49664771

版权

asp.net 同时被 2 个专栏收录

41 篇文章 0 订阅

订阅专栏

MVC

33 篇文章 0 订阅

订阅专栏

1、微软自带事务和锁

private static object _lock = new object();

try
{
using (TransactionScope scope = new TransactionScope())
{
lock (_lock)
{

}
scope.Complete();
}
}
catch (Exception ex)
{
TJson.setSucc(jOutput, false, "添加失败");
TTracer.WriteLog(ex.ToString());

}

2、 StringBuilder sWhere = new StringBuilder();
IList<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
TransactionOptions transactionOption = new TransactionOptions();
transactionOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;//设置事务的隔离级别
transactionOption.Timeout = new TimeSpan(0, 0, 60); //设置事务超时时间60秒
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,transactionOption))
{
foreach (var item in queryWhere)
{
if (item.Value.ToString() != "")
{
sWhere.Append(" and " + item.Key + " like '%" + item.Value + "%'");
}
}
string mySQL = string.Format(@"(select * from EHECD_StoreInformation where 1=1 {0})", sWhere.ToMSSQLValue());
string etpageSQL = EtPageSQL.GetMSSsqlPagingSQL(pageNumber, pageSize, mySQL);
list = dbhelper.GetDictionaryList(etpageSQL);
scope.Complete();

}
return list;