public void Test()
{
using (MysqlRepository mysqlRepository = new MysqlRepository())
{
using (SqlServerRepository sqlServerRepository = new SqlServerRepository())
{
try
{
//开启mysql事务
var mysqlUnitWork = mysqlRepository.UnitOfWork.BeginTransaction(() =>
{
mysqlRepository.Insert(new Comment()
{
Content = "test"
});
});
//开始sqlserver事务
var sqlserverUnitWork = sqlServerRepository.UnitOfWork.BeginTransaction(() =>
{
//sqlServerRepository.Insert(new Lige.Model.Order()
//{
// Remark = "test"
//});
});
//都完成后一起提交
mysqlUnitWork.Commit();
sqlserverUnitWork.Commit();
}
catch (System.Exception ex)
{
}
}
}
}
public void Test()
{
using (MysqlRepository mysqlRepository = new MysqlRepository())
{
var aaa = mysqlRepository.QuerySet <Comment>()
.Distinct()
.PageList(1, 1, x => new
{
id = Function.Concat(Function.Concat(x.Content, "test"), x.ArticleId.ToString())
});
//mysqlRepository.UnitOfWork.BeginTransaction(() =>
//{
// mysqlRepository.Insert(new Comment
// {
// Content = "test11111",
// ArticleId = 11,
// Type = 1,
// SubTime = DateTime.Now,
// PId = 0,
// RefCommentId = 0
// });
// MysqlRepository1 mysqlRepository1 = new MysqlRepository1();
// mysqlRepository1.Insert(new News
// {
// NewsLabel = "test",
// Headlines = "test",
// Content = "test",
// NewsFrom = "test",
// });
// //throw new System.Exception("test");
//});
//mysqlRepository.UnitOfWork.Commit();
}
}