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

            var userId    = TestData.users[0].Id;
            var sectionId = TestData.generalDataSections[0].Id;
            var text      = TestData.generalDataPoints[0].Text;

            // Act
            var generalDataPoint1 = repo.GetByUniqueKey(999, sectionId, text);
            var generalDataPoint2 = repo.GetByUniqueKey(userId, 999, text);
            var generalDataPoint3 = repo.GetByUniqueKey(userId, sectionId, "NotFound");

            // Assert
            Assert.Null(generalDataPoint1);
            Assert.Null(generalDataPoint2);
            Assert.Null(generalDataPoint3);

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

            int id = _rnd.Next(1, TestData.generalDataPoints.Count());
            var foundGeneralDataPoint = TestData.generalDataPoints.FirstOrDefault(v => v.Id == id);
            var userId    = foundGeneralDataPoint.User.Id;
            var sectionId = foundGeneralDataPoint.Section.Id;
            var text      = foundGeneralDataPoint.Text;

            // Act
            var generalDataPoint = repo.GetByUniqueKey(userId, sectionId, text);

            // Assert
            Assert.Equal(id, generalDataPoint.Id);

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