public async void CanGetNumberOfFlightsPerMonth() { // Arrange var items = Builder <FlightDc> .CreateListOfSize(78) .All() .With(x => x.Year, 2013) .TheFirst(1) .With(x => x.Month, 1) .TheNext(2) .With(x => x.Month, 2) .TheNext(3) .With(x => x.Month, 3) .TheNext(4) .With(x => x.Month, 4) .TheNext(5) .With(x => x.Month, 5) .TheNext(6) .With(x => x.Month, 6) .TheNext(7) .With(x => x.Month, 7) .TheNext(8) .With(x => x.Month, 8) .TheNext(9) .With(x => x.Month, 9) .TheNext(10) .With(x => x.Month, 10) .TheNext(11) .With(x => x.Month, 11) .TheNext(12) .With(x => x.Month, 12) .Build(); context.Flights.AddRange(items); context.SaveChanges(); // Act var result = await flightsRepository.GetNumberOfFlightsPerMonth(); result.GroupBy(x => x.Month); //Assert Assert.Equal(1, result.ElementAt(0).NumberOfFlights); Assert.Equal(2, result.ElementAt(1).NumberOfFlights); Assert.Equal(3, result.ElementAt(2).NumberOfFlights); Assert.Equal(4, result.ElementAt(3).NumberOfFlights); Assert.Equal(5, result.ElementAt(4).NumberOfFlights); Assert.Equal(6, result.ElementAt(5).NumberOfFlights); Assert.Equal(7, result.ElementAt(6).NumberOfFlights); Assert.Equal(8, result.ElementAt(7).NumberOfFlights); Assert.Equal(9, result.ElementAt(8).NumberOfFlights); Assert.Equal(10, result.ElementAt(9).NumberOfFlights); Assert.Equal(11, result.ElementAt(10).NumberOfFlights); Assert.Equal(12, result.ElementAt(11).NumberOfFlights); }