public void IsInTransaction_Should_Return_False_When_No_Transaction_Exists()
{
var mockDataContext = MockRepository.GenerateStub <ILinqSession>();
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
Assert.That(!unitOfWork.IsInTransaction);
}
public void TransactionalFlush_Starts_A_Transaction_With_Default_Isolation_And_Commits_When_Flush_Succeeds()
{
var mockDataContext = MockRepository.GenerateMock <ILinqSession>();
var mockConnection = MockRepository.GenerateMock <IDbConnection>();
var mockTransaction = MockRepository.GenerateMock <IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
mockDataContext.Expect(x => x.SubmitChanges());
mockConnection.Expect(x => x.State).Return(ConnectionState.Closed); //First call should be closed
mockConnection.Expect(x => x.Open());
mockTransaction.Expect(x => x.Commit());
mockConnection.Expect(x => x.State).Return(ConnectionState.Open); //Second call should be open
mockConnection.Expect(x => x.Close());
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
unitOfWork.TransactionalFlush();
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void Dispose()
{
if ( this.TransactionScope != null )
{
(this.TransactionScope as IDisposable).Dispose();
this.TransactionScope = null;
this.UnitOfWork = null;
}
}
public void Flush_Calls_Underlying_DataContext_SubmitChanges()
{
var mockDataContext = MockRepository.GenerateMock <ILinqSession>();
mockDataContext.Expect(x => x.SubmitChanges());
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
unitOfWork.Flush();
mockDataContext.VerifyAllExpectations();
}
public void BeginTransaction_Should_Start_A_New_Transaction_With_Specified_IsolatinLevel()
{
var isoLevel = IsolationLevel.Snapshot;
var mockDataContext = MockRepository.GenerateMock<ILinqSession>();
var mockConnection = MockRepository.GenerateMock<IDbConnection>();
var mockTransaction = MockRepository.GenerateStub<IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(isoLevel)).Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
Assert.That(!unitOfWork.IsInTransaction);
unitOfWork.BeginTransaction(IsolationLevel.Snapshot);
Assert.That(unitOfWork.IsInTransaction);
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void BeginTransaction_Throws_InvalidOperationException_When_Transaction_Already_Running()
{
var mockDataContext = MockRepository.GenerateMock<ILinqSession>();
var mockConnection = MockRepository.GenerateMock<IDbConnection>();
var mockTransaction = MockRepository.GenerateMock<IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments().Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
unitOfWork.BeginTransaction();
Assert.That(unitOfWork.IsInTransaction);
Assert.Throws<InvalidOperationException>(() => unitOfWork.BeginTransaction());
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void Begin_Transaction_Should_Start_A_New_Transaction_With_Default_IsolationLevel()
{
var mockDataContext = MockRepository.GenerateMock <ILinqSession>();
var mockConnection = MockRepository.GenerateMock <IDbConnection>();
var mockTransaction = MockRepository.GenerateMock <IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.ReadCommitted)).Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
Assert.That(!unitOfWork.IsInTransaction);
unitOfWork.BeginTransaction();
Assert.That(unitOfWork.IsInTransaction);
//mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void BeginTransaction_Should_Start_A_New_Transaction_With_Specified_IsolatinLevel()
{
var isoLevel = IsolationLevel.Snapshot;
var mockDataContext = MockRepository.GenerateMock <ILinqSession>();
var mockConnection = MockRepository.GenerateMock <IDbConnection>();
var mockTransaction = MockRepository.GenerateStub <IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(isoLevel)).Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
Assert.That(!unitOfWork.IsInTransaction);
unitOfWork.BeginTransaction(IsolationLevel.Snapshot);
Assert.That(unitOfWork.IsInTransaction);
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void TransactionalFlush_Rollsback_Transaction_When_Flush_Throws_Exception()
{
var mockDataContext = MockRepository.GenerateMock <ILinqSession>();
var mockConnection = MockRepository.GenerateMock <IDbConnection>();
var mockTransaction = MockRepository.GenerateMock <IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
mockDataContext.Expect(x => x.SubmitChanges()).Throw(new Exception());
mockTransaction.Expect(x => x.Rollback());
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
Assert.Throws <Exception>(unitOfWork.TransactionalFlush);
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
TransactionalFlush_Starts_A_Transaction_With_Specified_IsolationLevel_And_Commits_When_Flush_Succeeds()
{
var mockDataContext = MockRepository.GenerateMock <ILinqSession>();
var mockConnection = MockRepository.GenerateMock <IDbConnection>();
var mockTransaction = MockRepository.GenerateMock <IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
mockDataContext.Expect(x => x.SubmitChanges());
mockTransaction.Expect(x => x.Commit());
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
unitOfWork.TransactionalFlush(IsolationLevel.ReadUncommitted);
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void BeginTransaction_Throws_InvalidOperationException_When_Transaction_Already_Running()
{
var mockDataContext = MockRepository.GenerateMock <ILinqSession>();
var mockConnection = MockRepository.GenerateMock <IDbConnection>();
var mockTransaction = MockRepository.GenerateMock <IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments().Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
unitOfWork.BeginTransaction();
Assert.That(unitOfWork.IsInTransaction);
Assert.Throws <InvalidOperationException>(() => unitOfWork.BeginTransaction());
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void TransactionalFlush_Uses_Existing_Transaction_When_Transactional_AlreadyRunning()
{
var mockDataContext = MockRepository.GenerateMock <ILinqSession>();
var mockConnection = MockRepository.GenerateMock <IDbConnection>();
var mockTransaction = MockRepository.GenerateMock <IDbTransaction>();
mockDataContext.Expect(x => x.Connection).Repeat.Any().Return(mockConnection);
mockConnection.Stub(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Repeat.Once()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
unitOfWork.BeginTransaction();
unitOfWork.TransactionalFlush();
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void Dispose_UnitOfWork_Disposed_Underlying_Transaction_And_Session()
{
var mockDataContext = MockRepository.GenerateMock <ILinqSession>();
var mockConnection = MockRepository.GenerateMock <IDbConnection>();
var mockTransaction = MockRepository.GenerateMock <IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
mockTransaction.Expect(x => x.Dispose());
mockDataContext.Expect(x => x.Dispose());
using (var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext))
{
unitOfWork.BeginTransaction();
}
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void Rollback_Transaction_Releases_Transaction_From_UnitOfWork()
{
var mockDataContext = MockRepository.GenerateMock <ILinqSession>();
var mockConnection = MockRepository.GenerateMock <IDbConnection>();
var mockTransaction = MockRepository.GenerateMock <IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
mockTransaction.Expect(x => x.Rollback());
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
var transaction = unitOfWork.BeginTransaction();
Assert.That(unitOfWork.IsInTransaction);
transaction.Rollback();
Assert.That(!unitOfWork.IsInTransaction);
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public LinqToSqlTransaction(LinqToSqlUnitOfWork unitOfWork)
{
this.UnitOfWork = unitOfWork;
this.TransactionScope = new TransactionScope();
}
public void Flush_Calls_Underlying_DataContext_SubmitChanges()
{
var mockDataContext = MockRepository.GenerateMock<ILinqSession>();
mockDataContext.Expect(x => x.SubmitChanges());
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
unitOfWork.Flush();
mockDataContext.VerifyAllExpectations();
}
public void IsInTransaction_Should_Return_False_When_No_Transaction_Exists()
{
var mockDataContext = MockRepository.GenerateStub<ILinqSession>();
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
Assert.That(!unitOfWork.IsInTransaction);
}
public void Rollback_Transaction_Releases_Transaction_From_UnitOfWork()
{
var mockDataContext = MockRepository.GenerateMock<ILinqSession>();
var mockConnection = MockRepository.GenerateMock<IDbConnection>();
var mockTransaction = MockRepository.GenerateMock<IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
mockTransaction.Expect(x => x.Rollback());
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
var transaction = unitOfWork.BeginTransaction();
Assert.That(unitOfWork.IsInTransaction);
transaction.Rollback();
Assert.That(!unitOfWork.IsInTransaction);
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void TransactionalFlush_Rollsback_Transaction_When_Flush_Throws_Exception()
{
var mockDataContext = MockRepository.GenerateMock<ILinqSession>();
var mockConnection = MockRepository.GenerateMock<IDbConnection>();
var mockTransaction = MockRepository.GenerateMock<IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
mockDataContext.Expect(x => x.SubmitChanges()).Throw(new Exception());
mockTransaction.Expect(x => x.Rollback());
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
Assert.Throws<Exception>(unitOfWork.TransactionalFlush);
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void TransactionalFlush_Starts_A_Transaction_With_Default_Isolation_And_Commits_When_Flush_Succeeds()
{
var mockDataContext = MockRepository.GenerateMock<ILinqSession>();
var mockConnection = MockRepository.GenerateMock<IDbConnection>();
var mockTransaction = MockRepository.GenerateMock<IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
mockDataContext.Expect(x => x.SubmitChanges());
mockConnection.Expect(x => x.State).Return(ConnectionState.Closed); //First call should be closed
mockConnection.Expect(x => x.Open());
mockTransaction.Expect(x => x.Commit());
mockConnection.Expect(x => x.State).Return(ConnectionState.Open); //Second call should be open
mockConnection.Expect(x => x.Close());
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
unitOfWork.TransactionalFlush();
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void TransactionalFlush_Starts_A_Transaction_With_Specified_IsolationLevel_And_Commits_When_Flush_Succeeds()
{
var mockDataContext = MockRepository.GenerateMock<ILinqSession>();
var mockConnection = MockRepository.GenerateMock<IDbConnection>();
var mockTransaction = MockRepository.GenerateMock<IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
mockDataContext.Expect(x => x.SubmitChanges());
mockTransaction.Expect(x => x.Commit());
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
unitOfWork.TransactionalFlush(IsolationLevel.ReadUncommitted);
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void TransactionalFlush_Uses_Existing_Transaction_When_Transactional_AlreadyRunning()
{
var mockDataContext = MockRepository.GenerateMock<ILinqSession>();
var mockConnection = MockRepository.GenerateMock<IDbConnection>();
var mockTransaction = MockRepository.GenerateMock<IDbTransaction>();
mockDataContext.Expect(x => x.Connection).Repeat.Any().Return(mockConnection);
mockConnection.Stub(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Repeat.Once()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
unitOfWork.BeginTransaction();
unitOfWork.TransactionalFlush();
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void Begin_Transaction_Should_Start_A_New_Transaction_With_Default_IsolationLevel()
{
var mockDataContext = MockRepository.GenerateMock<ILinqSession>();
var mockConnection = MockRepository.GenerateMock<IDbConnection>();
var mockTransaction = MockRepository.GenerateMock<IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.ReadCommitted)).Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext);
Assert.That(!unitOfWork.IsInTransaction);
unitOfWork.BeginTransaction();
Assert.That(unitOfWork.IsInTransaction);
//mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
public void Dispose_UnitOfWork_Disposed_Underlying_Transaction_And_Session()
{
var mockDataContext = MockRepository.GenerateMock<ILinqSession>();
var mockConnection = MockRepository.GenerateMock<IDbConnection>();
var mockTransaction = MockRepository.GenerateMock<IDbTransaction>();
mockDataContext.Stub(x => x.Connection).Return(mockConnection);
mockConnection.Expect(x => x.BeginTransaction(IsolationLevel.Unspecified))
.IgnoreArguments()
.Return(mockTransaction);
mockDataContext.Expect(x => x.Transaction = mockTransaction);
mockTransaction.Expect(x => x.Dispose());
mockDataContext.Expect(x => x.Dispose());
using (var unitOfWork = new LinqToSqlUnitOfWork(mockDataContext))
{
unitOfWork.BeginTransaction();
}
mockDataContext.VerifyAllExpectations();
mockConnection.VerifyAllExpectations();
mockTransaction.VerifyAllExpectations();
}
