static async Task <int> DoRollbackAllAndDisposeTestAsync(ISqlConnectionTransactionController controller, int tranCount, int messageId)
{
var message = Guid.NewGuid().ToString();
using (var tran = controller.BeginTransaction())
{
tran.Status.Should().Be(SqlTransactionStatus.Opened);
controller.TransactionCount.Should().Be(tranCount + 1);
(await AddMessageAsync(controller, message)).Should().Be(++messageId);
(await ReadMessageAsync(controller, messageId)).Should().Be(message);
tran.RollbackAll();
controller.TransactionCount.Should().Be(0);
tran.Status.Should().Be(SqlTransactionStatus.Rollbacked);
}
(await ReadMessageAsync(controller, 2)).Should().BeNull();
message = Guid.NewGuid().ToString();
using (var tran = controller.BeginTransaction())
{
tran.Status.Should().Be(SqlTransactionStatus.Opened);
controller.TransactionCount.Should().Be(1);
(await AddMessageAsync(controller, message)).Should().Be(++messageId);
(await ReadMessageAsync(controller, messageId)).Should().Be(message);
}
controller.TransactionCount.Should().Be(0);
(await ReadMessageAsync(controller, messageId)).Should().BeNull();
return(messageId);
}
static async Task <int> DoCommitTestAsync(ISqlConnectionTransactionController controller, int tranCount, int messageId)
{
var message = Guid.NewGuid().ToString();
using (var tran = controller.BeginTransaction())
{
tran.Status.Should().Be(SqlTransactionStatus.Opened);
controller.TransactionCount.Should().Be(tranCount + 1);
(await AddMessageAsync(controller, message)).Should().Be(++messageId);
(await ReadMessageAsync(controller, messageId)).Should().Be(message);
tran.Commit();
controller.TransactionCount.Should().Be(tranCount);
tran.Status.Should().Be(SqlTransactionStatus.Committed);
}
(await ReadMessageAsync(controller, messageId)).Should().Be(message);
return(messageId);
}
static int DoCommitTest(ISqlConnectionTransactionController controller, int tranCount, int messageId)
{
var message = Guid.NewGuid().ToString();
using (var tran = controller.BeginTransaction())
{
tran.Status.Should().Be(SqlTransactionStatus.Opened);
controller.TransactionCount.Should().Be(tranCount + 1);
AddMessage(controller, message).Should().Be(++messageId);
ReadMessage(controller, messageId).Should().Be(message);
tran.Commit();
controller.TransactionCount.Should().Be(tranCount);
tran.Status.Should().Be(SqlTransactionStatus.Committed);
}
ReadMessage(controller, messageId).Should().Be(message);
return(messageId);
}