public void TestInitialize()
        {
            TestDataContext testDataContext = new TestDataContext(_connectionString);
            var userCountDto = new UserCountDto
            {
                Id = Guid.NewGuid(),
                HotZonesDestroyed = 10,
                Miles = 11,
                UserId = _userId,
                PeakAttack = 111,
                ZombiesKilled = 1111,
                ZombiePacksDestroyed = 11111,
                AccumulatedMoney = 500
            };

            testDataContext.UserCountDtos.InsertOnSubmit(userCountDto);
            testDataContext.SubmitChanges();

            UserDto userDto = new UserDto { Id = _userId, DisplayName = "name", Email = string.Empty };
            testDataContext.UserDtos.InsertOnSubmit(userDto);
            testDataContext.SubmitChanges();
        }
        private void GivenUser(int withFacebookId, int level, string name, long killed = 0, long miles = 0, long packs = 0, long hotzones = 0, long money = 0, long streak = 0)
        {
            TestDataContext testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString);
            Guid userId = Guid.NewGuid();
            UserDto userDto = new UserDto
            {
                Id = userId,
                BaseLineAttackPower = 0,
                BaseLineEnergy = 0,
                CurrentBaseAttack = 0,
                CurrentBaseEnergy = 0,
                DisplayName = name,
                Email = string.Empty,
                FacebookUserId = withFacebookId,
                Latitude = 0,
                Level = level,
                ZoneId = Guid.Empty
            };

            testDataContext.UserDtos.InsertOnSubmit(userDto);
            testDataContext.SubmitChanges();

            UserCountDto userCountDto = new UserCountDto
            {
                AccumulatedMoney = money,
                HotZonesDestroyed = hotzones,
                Id = Guid.NewGuid(),
                Miles = miles,
                PeakAttack = streak,
                UserId = userId,
                ZombiePacksDestroyed = packs,
                ZombiesKilled = killed
            };

            testDataContext.UserCountDtos.InsertOnSubmit(userCountDto);
            testDataContext.SubmitChanges();

            _userIds.Add(userId);
        }
 partial void UpdateUserCountDto(UserCountDto instance);
 partial void DeleteUserCountDto(UserCountDto instance);
 partial void InsertUserCountDto(UserCountDto instance);