public async Task CreateAsync_given_dto_returns_created_Session()
        {
            using (var connection = await this.CreateConnectionAsync())
                using (var context = await this.CreateContextAsync(connection))
                {
                    var repository = new SessionRepository(context);
                    var dto        = this.CreateDummySessionDTO();

                    var session = await repository.CreateAsync(dto);

                    Assert.Equal(1, session.Id);
                    Assert.Equal("A1B2C3D", session.SessionKey);
                }
        }