public void TestInitialize()
        {
            // start the transaction
            _transactionScope = new TransactionScope();

            // create some test data
            SessionTestDataFactory.CreateStandardTestData();
        }
        public void Initialize()
        {
            _transactionScope = new TransactionScope();

            using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MainConnectionString"].ConnectionString))
            {
                connection.Open();
                SessionTestDataFactory.CreateStandardSpeaker(connection);
                _speakerId = SessionTestDataFactory.GetLastSpeakerId(connection);
            }
        }