public async void UpdateAsync_UpdatesInContext()
        {
            var facility = FacilityGenerator.Create();

            using (var context = new booking_facilitiesContext(contextOptions))
            {
                context.Database.EnsureCreated();
                context.Facility.Add(facility);
                context.SaveChanges();
                var repository  = new FacilityRepository(context);
                var newFacility = await repository.GetByIdAsync(facility.FacilityId);

                newFacility.FacilityName = "Court 1";
                newFacility.SportId      = 2;
                Assert.Equal(1, await context.Facility.CountAsync());
                Assert.Equal(newFacility, await context.Facility.SingleAsync());
            }
        }
        public async void GetByIdAsync_ReturnsCorrectItems()
        {
            var list     = FacilityGenerator.CreateList(5);
            var expected = list[2];

            using (var context = new booking_facilitiesContext(contextOptions))
            {
                context.Database.EnsureCreated();
                context.Facility.AddRange(list);
                context.SaveChanges();
                Assert.Equal(list.Count, await context.Facility.CountAsync());
                var repository = new FacilityRepository(context);
                var facility   = await repository.GetByIdAsync(expected.FacilityId);

                Assert.IsType <Facility>(facility);
                Assert.Equal(expected, facility);
            }
        }