public void TestCommandWithInheritedTransaction()
{
connection.Execute("create table #TransactionTest ([ID] int, [Value] varchar(32));");
try
{
using (var transaction = connection.BeginTransaction())
{
var transactedConnection = new TransactedConnection(connection, transaction);
transactedConnection.Execute("insert into #TransactionTest ([ID], [Value]) values (1, 'ABC');");
transaction.Rollback();
}
connection.Query<int>("select count(*) from #TransactionTest;").Single().IsEqualTo(0);
}
finally
{
connection.Execute("drop table #TransactionTest;");
}
}
public UserRepository(IRepositoryContext context) : base(context)
{
dbContext = _dbContext;
}
public void TestCommandWithInheritedTransaction()
{
connection.ExecuteNonQuery("create table TransactionTest (ID integer, Value varchar(32));");
try
{
using (var transaction = connection.BeginTransaction())
{
var transactedConnection = new TransactedConnection(connection, transaction);
transactedConnection.Execute("insert into TransactionTest (ID, Value) values (1, 'ABC');");
connection.RollbackTransaction();
}
Assert.IsEqualTo(Enumerable.Single(connection.Query<int>("select count(*) from TransactionTest;")), 0);
}
finally
{
connection.ExecuteNonQuery("drop table TransactionTest;");
}
}
private DapperRepositoryReadContext getRepositoryReadContext(TransactedConnection context)
{
return(new DapperRepositoryReadContext(context));
}
/// <summary>
/// 通过构造函数注入得到数据上下文对象实例
/// </summary>
/// <param name="dbContext"></param>
public DapperRepositoryReadBase(IRepositoryReadContext context) : base(context)
{
var dapperRepositoryContext = (DapperRepositoryReadContext)context;
_dbContext = dapperRepositoryContext.Session;
}
public BaseRepository()
{
Connection = new TransactedConnection(ConnectionStringKey);
}
public RoleRepository(IRepositoryContext dbcontext) : base(dbcontext)
{
dbContext = _dbContext;
}
public AuthDPRepositoryContext(TransactedConnection session) : base(session)
{
}
