public async Task FindAsync_given_id_exists_returns_dto()
        {
            using (var connection = await this.CreateConnectionAsync())
                using (var context = await this.CreateContextAsync(connection))
                {
                    var entity = this.CreateDummySessionEntity();

                    context.Sessions.Add(entity);
                    context.SaveChanges();

                    var repository = new SessionRepository(context);

                    var session = await repository.FindAsync(1);

                    Assert.Equal(1, session.Id);
                    Assert.Equal("A1B2C3D", session.SessionKey);
                    Assert.Equal("item 1", session.Items.FirstOrDefault()?.Title);
                }
        }