public void GetAllByMarkAndSectionId_ShouldReturnEmptyArray_WhenWrongMarkOrSectionId()
        {
            // Arrange
            var context = GetContext(TestData.markGeneralDataPoints);
            var repo    = new SqlMarkGeneralDataPointRepo(context);

            var markId    = _rnd.Next(1, _maxMarkId);
            var sectionId = _rnd.Next(1, _maxSectionId);

            // Act
            var markGeneralDataPoints1 = repo.GetAllByMarkAndSectionId(
                999, sectionId);
            var markGeneralDataPoints2 = repo.GetAllByMarkAndSectionId(
                markId, 999);

            // Assert
            Assert.Empty(markGeneralDataPoints1);
            Assert.Empty(markGeneralDataPoints2);

            context.Database.EnsureDeleted();
            context.Dispose();
        }
        public void GetAllByMarkAndSectionId_ShouldReturnMarkGeneralDataPoints()
        {
            // Arrange
            var context = GetContext(TestData.markGeneralDataPoints);
            var repo    = new SqlMarkGeneralDataPointRepo(context);

            var markId    = _rnd.Next(1, _maxMarkId);
            var sectionId = _rnd.Next(1, _maxSectionId);

            // Act
            var markGeneralDataPoints = repo.GetAllByMarkAndSectionId(markId, sectionId);

            // Assert
            Assert.Equal(TestData.markGeneralDataPoints.Where(
                             v => v.Mark.Id == markId && v.Section.Id == sectionId),
                         markGeneralDataPoints);

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