public void AddRecord()
        {
            var context          = new aspnetdbEntities();
            var testUser         = context.aspnet_Membership.First();
            var friendRepository = new EfFriendRepository();
            var testFreindEmail  = Guid.NewGuid().ToString();

            friendRepository.Create(testUser.UserId, testFreindEmail);

            bool friendExists = context.Friends.Any(f => f.UserId == testUser.UserId && f.EmailAddress == testFreindEmail);

            Assert.IsTrue(friendExists);

            context.Friends.Remove(context.Friends.FirstOrDefault(f => f.UserId == testUser.UserId && f.EmailAddress == testFreindEmail));
            context.SaveChanges();
        }
        public void AddRecordTx()
        {
            Guid testUserId;

            using (var context = new aspnetdbEntities())
            {
                testUserId = context.aspnet_Membership.First().UserId;
            }

            var friendRepository = new EfFriendRepository();
            var testEmail        = Guid.NewGuid().ToString();

            friendRepository.Create(testUserId, testEmail);

            using (var context = new aspnetdbEntities())
            {
                bool friendExists = context.Friends.Any(f => f.UserId == testUserId && f.EmailAddress == testEmail);
                Assert.IsTrue(friendExists);

                //context.DeleteObject(context.Friends.FirstOrDefault(f => f.UserId == testUserId && f.EmailAddress == testEmail));
                //context.SaveChanges();
            }
        }