public async Task <IHttpActionResult> Get2()
{
//测试分布式事务
List <string> message = new List <string>();
//开始事务
_client.BeginTran();
try
{
message.Add("开始事务");
var query = await _entype.QueryAsync();
message.Add($"表中总数据{query.Count}");
message.Add($"add 一条数据");
await _entype.AddAsync(new BA_SysEnType
{
Name = "测试",
IsEnd = true,
IsSys = true,
Level = 1
});
var list = await _area.QueryAsync();
var list2 = await _entype.QueryAsync();
message.Add($"add之后表中总数据{list2.Count}");
message.Add("抛出一个错误");
////抛出错误
//int a = 0;
//var b = 1 / a;
message.Add("提交事务");
_client.CommitTran();
var list3 = await _entype.QueryAsync();
message.Add($"事务提交之后表中总数据{list3.Count}");
return(Json(message));
}
catch (Exception ex)
{
_client.RollbackTran();
message.Add("回滚事务");
var query = await _entype.QueryAsync();
message.Add($"回滚事务之后表中总数据{query.Count}");
return(BadRequest(string.Join(",", message)));
}
}
