public void FindUserSession_BySessionKey_DoesNotFindUserSession()
        {
            var repository = new DapperRepository();

            var userid = repository.Insert(new User {
                UserName = "******"
            });

            repository.Insert(new UserSession {
                SessionKey = _sessionKey, UserId = userid
            });

            var query = new FindSessionForUserDapper();

            var result = query.Execute(_invalidSessionKey);

            Assert.That(result, Is.Null);
        }
        public void FindUserSession_BySessionKey_FindsUserSession()
        {
            var repository = new DapperRepository();

            var userid = repository.Insert(new User {
                UserName = "******"
            });
            var id = repository.Insert(new UserSession {
                SessionKey = _sessionKey, UserId = userid
            });

            var query = new FindSessionForUserDapper();

            var result = query.Execute(_sessionKey);

            Assert.That(result, Is.Not.Null);
            Assert.That(result.Id, Is.EqualTo(id));
            Assert.That(result.SessionKey, Is.EqualTo(_sessionKey));
        }