public void GetAllByUserAndSectionId_ShouldReturnEmptyArray_WhenWrongUserOrSectionId()
        {
            // Arrange
            var context = GetContext(TestData.generalDataPoints);
            var repo    = new SqlGeneralDataPointRepo(context);

            var userId         = _rnd.Next(1, _maxUserId);
            var wrongUserId    = 999;
            var sectionId      = _rnd.Next(1, _maxSectionId);
            var wrongSectionId = 999;

            // Act
            var generalDataPoints1 = repo.GetAllByUserAndSectionId(wrongUserId, sectionId);
            var generalDataPoints2 = repo.GetAllByUserAndSectionId(userId, wrongSectionId);

            // Assert
            Assert.Empty(generalDataPoints1);
            Assert.Empty(generalDataPoints2);

            context.Database.EnsureDeleted();
            context.Dispose();
        }
        public void GetAllByUserAndSectionId_ShouldReturnGeneralDataPoints()
        {
            // Arrange
            var context = GetContext(TestData.generalDataPoints);
            var repo    = new SqlGeneralDataPointRepo(context);

            var userId    = _rnd.Next(1, _maxUserId);
            var sectionId = _rnd.Next(1, _maxSectionId);

            // Act
            var generalDataPoints = repo.GetAllByUserAndSectionId(userId, sectionId);

            // Assert
            Assert.Equal(TestData.generalDataPoints.Where(
                             v => v.User.Id == userId && v.Section.Id == sectionId),
                         generalDataPoints);

            context.Database.EnsureDeleted();
            context.Dispose();
        }