DatabaseFixture.cs

DatabaseFixture.cs

public class DatabaseFixture
{
    public TransactionScope transactionScope;

    public DatabaseFixture()
    {
        ConnectionString = "Your ConnectionString";
    }

    public string ConnectionString { get; set; }
    
    [SetUp]
    public void SetUp()
    {
        transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, new TimeSpan(0, 5, 0));
    }

    [TearDown]
    public void TearDown()
    {
        transactionScope.Dispose();
    }
}

[TestFixture]
public class MemberRepositoryFixture: DatabaseFixture
{
    [Test]
    public void ShouldCreateAndFindMember()
    {
        var member = CreateMember();
        using (var repository = new MemberRepository(this.ConnectionString))
        {
            repository.Create(member);
            repository.SubmitChanges();
        }

        using (var repository = new MemberRepository(this.ConnectionString))
        {
            var found = repository.FindById(member.Id);
            Assert.IsNotNull(found);
            Assert.AreEqual(found.Id, member.Id);
            Assert.AreEqual(found.FirstName, member.FirstName);
            Assert.AreEqual(found.LastName, member.LastName);
            Assert.AreEqual(found.Gender, member.Gender);
        }
    }
}